1 Reply Latest reply on Jan 11, 2008 6:58 AM by Ronald van Kuijk

    JBPM-3.2.2 Migrated to Oracle 10g,Hibernate_Sequence is acce

    Soumyajit Paul Newbie

      Hi All,
      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>

      Then I found that due to dependency of different tables and as the single sequence is being used by every table,sequence is accessed globally and that's why this strange behaviour is reflected in Oracle.

      As compared to Hypersonic,It doesn't follow the SQL-200n standard.Sequence never accessed globally even same sequence is accessed by different table.

      To eradicarte the problem what may be the possible solution?????
      Any comment and suggestion is most welcome

      Thanks
      Soumya