Shiju John [https://community.jboss.org/people/shijuj] created the discussion "Re: JBPM 5.2 in DB2 - Sequence generation problem" To view the discussion, visit: https://community.jboss.org/message/797605#797605 -------------------------------------------------------------- Hi jiri Svitak, Thanks for ur replay. This is not working.  In oracle am using the sequence name SESSIONINFO_ID_SEQ But in DB2 the same sequence is not taken for sessioninfo table. My Persistance.xml look like  <properties>* <property name=++"hibernate.dialect"++* value=++"org.hibernate.dialect.DB2Dialect"++/> <property name=++"hibernate.id.new_generator_mappings"++ value=++"false"++/> <property name=++"hibernate.connection.autocommit"++ value=++"false"++/> <property name=++"hibernate.max_fetch_depth"++ value=++"3"++/> <property name=++"hibernate.hbm2ddl.auto"++ value=++"validate"++/> <property name=++"hibernate.show_sql"++ value=++"false"++/> <property name=++"hibernate.transaction.manager_lookup_class"++ value=+"com.TransactionManagerLookup"+ /> </properties> -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/797605#797605] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Shiju John [https://community.jboss.org/people/shijuj] created the discussion "Re: JBPM 5.2 in DB2 - Sequence generation problem" To view the discussion, visit: https://community.jboss.org/message/797624#797624 -------------------------------------------------------------- Hi, Am Using Hibernate 3 and JBoss 4. yes I recreated all the schema. but its not working. Am  trying with option <property name=++"hibernate.hbm2ddl.auto"++ value=++"create"++/> then it is working. But in this case also DB doesn't have a sequence named SESSIONINFO_ID_SEQ but its working properlly.  -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/797624#797624] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]