Im trying to upgrade the Hibernate libraries from 3.x to 3.5.6.

I have a problem running one insert. I have a sequence and Oracle trigger which will use the seq to insert as ID inside the table. And my program is inserting the remaining columns. The issue is similar to below. But I past the original error by changing the property

viewtopic.php?f=1&t=975055&p=2441274#p2441274

use_get_generated_keys to false.

But now im getting the above Dialect error when im inserting a record. My HBM files looks like this

<hibernate-mapping package="com.ncr.passport.audit">

<class name="AuditLog" table="pcwauditlog" lazy="false">
<id name="instanceId" column="id" type="long">
<generator class="identity"/>
</id>
......

I tried changing the dialect from original org.hibernate.dialect.OracleDialect to org.hibernate.dialect.Oracle9Dialect but no change.

Im not sure how it worked in old version with "identity" generator class. I also tried using "select" but no effect.