I'm using mysql and hibernate3 and can't seem to get my primary keys filled. id is the primary key of unit, and it's set to auto_increment in mysql:

Unit unit = new Unit();
unit.setName("noId");

Session session = HibernateUtil.getSession();

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

System.out.println("Generated key: " + unit.getId());

assertTrue("generated key not returned", unit.getId()>0);

prints 0 and throws and AssertionFailedError.

Did I miss a switch here?? Is

I already set

hibernate.jdbc.use_get_generated_keys true

with no effect.

I'm using
- mysql-connector-java-3.0.9-stable
- hibernate 3.0 beta 3
- mysql 4.0.15-nt
- jdk1.5.0


any help is highly appreciated, as this really drives me mad...
cheers
stf

Ok, solved this one with the help from michael:

using @Id without giving a generator-type falls back to the default, which is GeneratorType.NONE

so, adding a
@Id (generate=GeneratorType.AUTO)

tells hibernate to use the auto_increment *and* that there is actually something that can be retrieved from the DB... - after the flush, the ids are filled now.

Case Solved, many thx michael!
stf