[jboss-user] [JBoss jBPM] - JBPM-3.2.2 Migrated to Oracle 10g, Hibernate_Sequence is acce
do-not-reply at jboss.com
Fri Jan 11 01:10:50 EST 2008
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.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
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4118914#4118914
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4118914
More information about the jboss-user