Hello,

When will hibernate support JDBC 3 ? (I' know it's a simple question that's not simple to implement...) In particular support for Retrieving auto-generated keys.

Thanks

Alain.
A Thankfull hibernate user.

There is a ballance against new features and backward compatibility. I cannot speak for Gavins plans but I would not expect this to get a large focus for a little while. If the bulk/most of the databases have good jdbc3 drivers then the situation would be different.

For me, this is more an issue of JDK compatibility.

I am also very interested in JDBC 3.0 and submitted a patch to support getGeneratedKeys. I have used that patch against DB2 and MySQL, which has some bulk but probably doesn't represent most databases. The patch is backward compatable with JDBC 2.0. For me it was more work to go around this issue and our databases are very large so doubling up I/O on inserts is hard to justify when a better solution exists. From Gavin's comment I should have pushed some of the common code up into the AbstractEntityPersister, which I can do right away if there is any possability that this will be committed.

http://opensource.atlassian.com/project ... key=HB-380

I forgot to mention that CVS and Sourceforge are now working so I moved these changes up and am now working directly against the 2.1 branch so providing an up-to-date patch is easy at this point. I also have unit tests that show this works for MySQL and DB2.

Ah. I didn't notice that you had updated this patch. Yes, if you refactor the common code up to AbstractEntityPersister, I would be inclined to commit this patch.