Hibernate version: 3.1.2

Full stack trace of any exception that occurs:

java.sql.SQLException: [mercury][SQLServer JDBC Driver]Unsupported method: Connection.prepareStatement
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.prepareStatement(Unknown Source)

Name and version of the database you are using: Sql Server 2000

The JDBC driver: Data Direct for Sql Server 3.5.27

When using Identity column in Sql Server, Hibernate tries to get the auto-generated keys.
There are 2 ways to do that:
1. Connection.prepareStatement (String sql, int autoGeneratedKeys) - that allows to retrieve the generated value of a single column in the table.
2. Connection.prepareStatement (String sql, int[] columnIndexes) - that allows to retrieve the generated value of multiple columns in the table.

Hibernate uses the second method, and I don't see why the first one is not enough - There's no way to create a schema via Hibernate that has multiple generated keys in a single table!!
And if it's to support some weird legacy schema - why is that the default behaviour in Hibernate? when there are some JDBC Drivers that only support the first method!!. (like Data Direct for Sql Server)

Should I place a feature request in JIRA for that??

I'm geting the same error with Weblogic Driver for INformix.





Getting this error with insert statements on a table with autogenerated keys

Can someone help?

I'm geting the same error with Weblogic Driver for INformix.





Getting this error with insert statements on a table with autogenerated keys

Can someone help?

you can tell hibernate to fetch the auto-generated keys in a seperate query:
set the hibernate.jdbc.use_get_generated_keys option to false in the hibernate.properties file.
This, of course, will affect performance of inserts.