native "id" not being generated..

hibby · **Joined:** Tue Mar 21, 2006 4:44 pm **Posts:** 4

I chose the NAtive ID generation in hbm mapping file.

The session.save(NewObj) fails with "org.hibernate.exception.ConstraintViolationException: ..." saying Insertion failed due to Null ID. I didn't populate this ID in my code assuming Native system will take care of generating this ID value(of type long in my case) when we insert. Any clues?

jt_1000 · **Posted:** Tue Mar 21, 2006 6:02 pm

depends on the native system.

Hibernate's Oracle Dialect will try to use
hibernate_sequence.nextval to get a sequence, and if you haven't created
the sequence "hibernate_sequence" then it will fail.

Others perhaps would use the "identity" field in the database -- ie, MySQL supports auto gen keys when you do an insert, whereby you don't have to pass anything for value in the key.

hibby · **Joined:** Tue Mar 21, 2006 4:44 pm **Posts:** 4

Sybase is the DB used and I guess "native" should use "identity".
I also tried "identity" as the generator class. Still the same problem.

jt_1000 · **Posted:** Wed Mar 22, 2006 12:05 am

choosing native should automatically choose the correct method - between sequence or identity.

Can you post your XML mapping file and its table definition.