For an Oracle identity column generated by the database (eg., via insert trigger) the built-in generator="identity" is not supported by Hibernate (as of version 3.2.2). Instead of this, generator="sequence-identity" is supported on Oracle 10g (see http://www.hibernate.org/hib_docs/v3/reference/en/html/mapping.html#mapping-declaration-id-generator).

In reverse-engineered databases, a dummy sequence "HIBERNATE_SEQUENCE" must be created manually, because Hibernate references this sequence in the insert statement.

Annotation Syntax Example:

See also this:

http://forum.hibernate.org/viewtopic.php?t=973262

I was able to use sequence-identity in JBoss 4.0.5SP1, but not JBoss 4.2.0. Does anyone know what needs to be changed when moving up? These versions of JBoss use different versions of Hibernate, so it might be related to that. I'm using JDK 1.5.0_11 and Oracle 10g.

I'm using

org.hibernate.dialect.Oracle9Dialect

in both hibernate.cfg.xml and hibernate-service.xml.

AFIK, Hibernate provides no Oracle10Dialect, even though this is a feature that ONLY works with Oracle 10g!



The exception I get in JBoss 4.2.0 is:


Caused by: java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:3492)
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:256)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.hibernate.util.NamedGeneratedKeysHelper.prepareStatement(NamedGeneratedKeysHelper.java:42)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:498)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.id.SequenceIdentityGenerator$Delegate.prepare(SequenceIdentityGenerator.java:76)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:30)
... 80 more


Thanks

Are you using the same version of the JDBC driver ? This id generator uses a JDBC3 feature that is only available in the latest versions of the driver. If you are using a 9i driver, it won't work. It will however work with a 9i database accessed from a 10g driver.



That's fine: Oracle9Dialect works with Oracle version 9 and upper (including Oracle 10g).