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

[mputz]

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