Hi,

I am using hibernate identity generator for a db2 table. The same db2 table is getting updated via manual insert from another batch program.

The batch program used "max(primary key column) + 1" to insert in the table. After i insert using the manual query, the hibernate insert is throwing me "Index Constraint. No two rows can have same value". But when i try to insert again using the hibernate insert for the second time, its working.

Please let me know why the first hibernate insert is not working.

Any help is much appreciated.