Hi,

I am using the org.hibernate.id.enhanced.TableGenerator using the pooled optimizer with an increment size of 100 to improve the performance of doing inserts. Originally I was using identity column for the id and while it worked there seemed to be an additional select being performed to get the id value and set it in the object. This also prevents the use of batching which I want to still use. The identity generator works fine in hibernate but I have the problem where I have stored procs that also need to insert into the same table. How can I insert from an external process to hibernate and stilll maintain that the id's will be unique?

Regards

Anyone have any ideas? Is it even possible to do?