How to retrieve values generated by auto_increment in mysql

mugwump · **Joined:** Thu Feb 19, 2004 4:48 am **Posts:** 62

Hi,

is there a way/a switch to tell hibernate to populate new objects with the keys generated with the auto_increment? e.g. using Statement.RETURN_GENERATED_KEYS with the insert?!

I get all sorts of problems when inserting multiple objects (NonUniqueObjectException), because all objects have the same primary key (0) - I suppose it's just a switch that I'm missing?!

cheers
stefan

mugwump · **Joined:** Thu Feb 19, 2004 4:48 am **Posts:** 62

ok, sorry for that one. Setting

hibernate.jdbc.use_get_generated_keys true

to true obviously does the trick and also solves the update-woes.

mugwump · **Joined:** Thu Feb 19, 2004 4:48 am **Posts:** 62

setting

hibernate.jdbc.use_get_generated_keys true

does not help!

After

Transaction tx = session.beginTransaction();
session.save(unit);
tx.commit();

unit.getId() still returns 0!!!

Is there anything I can do about that?!

cheers
stf

michael · **Posted:** Fri Feb 04, 2005 12:20 pm

are you using the correct generator? identity or native

mugwump · **Joined:** Thu Feb 19, 2004 4:48 am **Posts:** 62

Whoooopeee! Great!

I'm using hibernate3 and annotations, and i added no GeneratorType to the id, so i guess the defaults were used.

When I change the Annotation to

@Id (generate=GeneratorType.AUTO)

the id's are filled!

Great! Thank you!

Leaves me thinking, what the default actually is: GeneratorType.NONE?

many thx for the help!
stf

emmanuel · **Posted:** Sat Feb 05, 2005 7:33 am

GeneratorType.NONE is equivalent to generator="assigned",
The application have to fill it itself