[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1160) Incorrect use of getGeneratedKey() for Oracle

Incorrect use of getGeneratedKey() for Oracle --------------------------------------------- Key: HHH-1160 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1160 Project: Hibernate Core Issue Type: Bug Components: core Environment: Oracle Driver 10.2.0.1.0 Oracle DB 9.2.0.6.0 Reporter: Emmanuel Bernard Assignee: Steve Ebersole Fix For: 3.1 rc3 The problem is that Oracle's getGeneratedKeys() returns a rowID. This is Oracle's internal unique representation of a row and can not be represented as a long which is why the exception is thrown. This is within the spec for getGeneratedKeys(). To make getGeneratedKeys() work for any database, the PreparedStatement object must be created with the method that takes a String[] of columns to return from getGeneratedKeys(). This is the change that is made in Jira ticket "JBAS-2399" to make getGeneratedKeys() work for Oracle with EJB2.1.