[jboss-user] [JBoss jBPM] - Re: No auto-id for jbpm when running on Oracle

mputz do-not-reply at jboss.com
Tue Dec 16 07:22:15 EST 2008

If you have created the jBPM tables using the provided jbpm.jpdl.oracle.sql script, a sequence should have been created, too:
create sequence hibernate_sequence;
The mapping files are held pretty generic when it comes to id generation:
<id name="id" column="ID_"><generator class="native" /></id>
This allows Hibernate to select the appropriate strategy depending on the configured db dialect, for Oracle it will be 'sequence'. Hibernate then calls the sequence (by default, if not further specified, the one named 'hibernate_sequence') when new rows are inserted.

Have you set the dialect in hibernate.cfg.xml?
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4196855#4196855

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4196855

More information about the jboss-user mailing list