[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1860) Autogeneration of primary keys for Sybase IDENTITY columns fails with latest jConn3 driver

Autogeneration of primary keys for Sybase IDENTITY columns fails with latest jConn3 driver ------------------------------------------------------------------------------------------ Key: HHH-1860 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1860 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.0 cr1 Environment: JBoss 4.0.4GA, Adaptive Server Anywhere 9, jConnect using com.sybase.jdbc3.jdbc.SybDriver / jConn3.jar Reporter: Erica Kane Priority: Minor Sybase provides an IDENTITY column which is very useful for autogenerating primary keys for entity beans. However, if version 6.05 of jConnect (the standard Sybase driver) is used, with com.sybase.jdbc3.jdbc.SybDriver, all inserts fail with a message that it was not possible to obtain the generated identity. Changing the datasource configuration to use com.sybase.jdbc2.jdbc.SybDriver fixes the problem. Hopefully this can be fixed -- I realize it may be Sybase's fault -- but if not, I hope this spares someone else the agony of figuring it out.