For some reason the identity column call back that retrieves key fields after insert is failing saying there is not "into". Here is the statement it is running:

2003/09/26 18:10:52:168 MDT [DEBUG] SessionFactoryImpl - -prepared statement get: values IDENTITY_VAL_LOCAL()

I would agree that this seems pretty terse. This is a DB2 database and I am using a 3.0 driver. If the driver supports it, could hibernate use getGeneratedKeys from the Statement interface?

It looks like Hibernate could use the getGeneratedKeys support added with JDBC 3.0. I made a minimal change that required extending the Batcher and SessionFactoryImplementor interfaces and it seems to work OK. It was minimal because I did not add any support for configuration and assumed a JDBC 3.0 driver. Are there any plans to support getGeneratedKeys? On the surface, it looks reasonable and could be implemented in such a way as to not break existing implementors.

Hibernate can not depend upon JDBC3 API, since we must support JDK1.2.

Would this be considered if it could work fine with a 1.2 JDK? The minimal implmentation I created did not break any existing code. However, I did not make the change I put in configurable (I hard coded to assume a 3.0 driver) because I was trying to see if it would work.

Thanks

Well, I suppose you could need to implement this using reflection for the getGeneratedKeys() call. So far I'm not aware of any driver other than MySQL which supports this, but probably some SQL Server drivers support it (I never tried on JSQL).

Gavin,

I have this working using reflection and have tested with MySql/DB2/JDK 1.3/JDK1.4 but anonymous CVS at SourceForge is not working. I have tried many times over the last few days to create a patch but I can never get a connection.

At this point, I will take today's well-timed release and check it in to my CVS server. Then I could check it out and re-apply the changes and build the patches from there.

Sounds good!

I posted a patch through Jira. Let me know if there is anything else I can do. I didn't update the documentation but will provide a patch if it would be helpful.