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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...