hi
I have two methods that save data in same table of database using hibernate + spring...Primary key is auto-generated and has increment as generator..However i am getting a very strange result..When i save an object using first method,object gets persisted let's say at primary key value 45.Now i save some objects using other methods in same table lets say at primary key values 46,47,48.Now when i get back to saving some object with first method i get an exception saying duplicate value for key '46'.I try again and get same exception but saying duplicate value for key '47' and then for 48 and finally object gets persisted.....SO ANY IDEA WHAT SHOULD I DO? i am using declarative transaction management......


HELP is greatly appreciated....

hmm, did I get you correct that you're mixing auto-generation and using a generator?

The increment generator assumes that no other is inserting into the database at the same time. The documentation says ...when no other process is inserting data... but I guess this applies to any non-Hibernate inserts in the same process as well. You should probably use the identity generator instead.