I have migrated JBPM in Oracle 10g but I have encountered a problem regarding Hibernate_sequence that has been provided with the given Oracle script.
Actually when my JBPM was associated with Hypersonic after each deployment the Process_ID is getting increased evenly and with an interval of 1. e.g Process A if I deploy it gets it's ID as 1,then the next process deployed get it's ID 2 and so on.....But in Oracle,the scenario is completely uneven.
I changed the hibenate.cfg.xml and made the following changes......Uncomment the following section
<property name="hibernate.show_sql">true</property> <property name="hibernate.format_sql">true</property> <property name="hibernate.use_sql_comments">true</property>
more basic question is should the proessid increment with 1? The jBPM standpoint is no. It's a primary key and should not be displayed to the user or anything. jBPM supports businesskeys for that.