1 Reply Latest reply on Nov 25, 2005 4:18 AM by Joshua Yip

    3.0 (still) fails with DB2

    Richard Lewis-Shell Newbie

      Hi,

      I earlier tried JBPM 3.0b4 with DB2 and couldn't get all the DB tests working.

      I've just tried again with 3.0 (well, latest from CVS anyway), and still getting the same error. In total, 1 error and 6 failures.

      Has anyone else got 3.0 working with DB2? If so, I'd love to hear any hints.

      A sample error from manually running TaskMgmtSessionDbTest in Eclipse gives:
      Hibernate: select processins0_.ID_ as ID1_31_, processins0_.START_ as START2_20_31_, processins0_.END_ as END3_20_31_, processins0_.PROCESSDEFINITION_ as PROCESSD4_20_31_, processins0_.ROOTTOKEN_ as ROOTTOKEN5_20_31_, processins0_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_31_, processdef1_.ID_ as ID1_0_, processdef1_.NAME_ as NAME2_4_0_, processdef1_.VERSION_ as VERSION3_4_0_, processdef1_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_0_, processdef1_.STARTSTATE_ as STARTSTATE5_4_0_, startstate2_.ID_ as ID1_1_, startstate2_.NAME_ as NAME3_5_1_, startstate2_.PROCESSDEFINITION_ as PROCESSD4_5_1_, startstate2_.ACTION_ as ACTION5_5_1_, startstate2_.SUPERSTATE_ as SUPERSTATE6_5_1_, startstate2_.initiatorSwimlane as initiato7_5_1_, processdef3_.ID_ as ID1_2_, processdef3_.NAME_ as NAME2_4_2_, processdef3_.VERSION_ as VERSION3_4_2_, processdef3_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_2_, processdef3_.STARTSTATE_ as STARTSTATE5_4_2_, action4_.ID_ as ID1_3_, action4_.NAME_ as NAME3_8_3_, action4_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_3_, action4_.REFERENCEDACTION_ as REFERENC5_8_3_, action4_.ACTIONDELEGATION_ as ACTIONDE6_8_3_, action4_.EVENT_ as EVENT7_8_3_, action4_.PROCESSDEFINITION_ as PROCESSD8_8_3_, action4_.EXPRESSION_ as EXPRESSION9_8_3_, action4_.TIMERNAME_ as TIMERNAME10_8_3_, action4_.DUEDATE_ as DUEDATE11_8_3_, action4_.REPEAT_ as REPEAT12_8_3_, action4_.TRANSITIONNAME_ as TRANSIT13_8_3_, action4_.TIMERACTION_ as TIMERAC14_8_3_, action4_.class as class3_, action5_.ID_ as ID1_4_, action5_.NAME_ as NAME3_8_4_, action5_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_4_, action5_.REFERENCEDACTION_ as REFERENC5_8_4_, action5_.ACTIONDELEGATION_ as ACTIONDE6_8_4_, action5_.EVENT_ as EVENT7_8_4_, action5_.PROCESSDEFINITION_ as PROCESSD8_8_4_, action5_.EXPRESSION_ as EXPRESSION9_8_4_, action5_.TIMERNAME_ as TIMERNAME10_8_4_, action5_.DUEDATE_ as DUEDATE11_8_4_, action5_.REPEAT_ as REPEAT12_8_4_, action5_.TRANSITIONNAME_ as TRANSIT13_8_4_, action5_.TIMERACTION_ as TIMERAC14_8_4_, action5_.class as class4_, delegation6_.ID_ as ID1_5_, delegation6_.CLASSNAME_ as CLASSNAME2_10_5_, delegation6_.CONFIGURATION_ as CONFIGUR3_10_5_, delegation6_.CONFIGTYPE_ as CONFIGTYPE4_10_5_, delegation6_.PROCESSDEFINITION_ as PROCESSD5_10_5_, processdef7_.ID_ as ID1_6_, processdef7_.NAME_ as NAME2_4_6_, processdef7_.VERSION_ as VERSION3_4_6_, processdef7_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_6_, processdef7_.STARTSTATE_ as STARTSTATE5_4_6_, event8_.ID_ as ID1_7_, event8_.EVENTTYPE_ as EVENTTYPE2_7_7_, event8_.TYPE_ as TYPE3_7_7_, event8_.GRAPHELEMENT_ as GRAPHELE4_7_7_, processdef9_.ID_ as ID1_8_, processdef9_.NAME_ as NAME2_4_8_, processdef9_.VERSION_ as VERSION3_4_8_, processdef9_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_8_, processdef9_.STARTSTATE_ as STARTSTATE5_4_8_, action10_.ID_ as ID1_9_, action10_.NAME_ as NAME3_8_9_, action10_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_9_, action10_.REFERENCEDACTION_ as REFERENC5_8_9_, action10_.ACTIONDELEGATION_ as ACTIONDE6_8_9_, action10_.EVENT_ as EVENT7_8_9_, action10_.PROCESSDEFINITION_ as PROCESSD8_8_9_, action10_.EXPRESSION_ as EXPRESSION9_8_9_, action10_.TIMERNAME_ as TIMERNAME10_8_9_, action10_.DUEDATE_ as DUEDATE11_8_9_, action10_.REPEAT_ as REPEAT12_8_9_, action10_.TRANSITIONNAME_ as TRANSIT13_8_9_, action10_.TIMERACTION_ as TIMERAC14_8_9_, action10_.class as class9_, superstate11_.ID_ as ID1_10_, superstate11_.NAME_ as NAME3_5_10_, superstate11_.PROCESSDEFINITION_ as PROCESSD4_5_10_, superstate11_.ACTION_ as ACTION5_5_10_, superstate11_.SUPERSTATE_ as SUPERSTATE6_5_10_, swimlane12_.ID_ as ID1_11_, swimlane12_.NAME_ as NAME2_13_11_, swimlane12_.ASSIGNMENTDELEGATION_ as ASSIGNME3_13_11_, swimlane12_.TASKMGMTDEFINITION_ as TASKMGMT4_13_11_, delegation13_.ID_ as ID1_12_, delegation13_.CLASSNAME_ as CLASSNAME2_10_12_, delegation13_.CONFIGURATION_ as CONFIGUR3_10_12_, delegation13_.CONFIGTYPE_ as CONFIGTYPE4_10_12_, delegation13_.PROCESSDEFINITION_ as PROCESSD5_10_12_, taskmgmtde14_.ID_ as ID1_13_, taskmgmtde14_.NAME_ as NAME3_16_13_, taskmgmtde14_.PROCESSDEFINITION_ as PROCESSD4_16_13_, taskmgmtde14_.STARTTASK_ as STARTTASK5_16_13_, processdef15_.ID_ as ID1_14_, processdef15_.NAME_ as NAME2_4_14_, processdef15_.VERSION_ as VERSION3_4_14_, processdef15_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_14_, processdef15_.STARTSTATE_ as STARTSTATE5_4_14_, task16_.ID_ as ID1_15_, task16_.NAME_ as NAME2_14_15_, task16_.PROCESSDEFINITION_ as PROCESSD3_14_15_, task16_.DESCRIPTION_ as DESCRIPT4_14_15_, task16_.ISBLOCKING_ as ISBLOCKING5_14_15_, task16_.DUEDATE_ as DUEDATE6_14_15_, task16_.TASKMGMTDEFINITION_ as TASKMGMT7_14_15_, task16_.TASKNODE_ as TASKNODE8_14_15_, task16_.STARTSTATE_ as STARTSTATE9_14_15_, task16_.ASSIGNMENTDELEGATION_ as ASSIGNM10_14_15_, task16_.SWIMLANE_ as SWIMLANE11_14_15_, task16_.TASKCONTROLLER_ as TASKCON12_14_15_, processdef17_.ID_ as ID1_16_, processdef17_.NAME_ as NAME2_4_16_, processdef17_.VERSION_ as VERSION3_4_16_, processdef17_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_16_, processdef17_.STARTSTATE_ as STARTSTATE5_4_16_, taskmgmtde18_.ID_ as ID1_17_, taskmgmtde18_.NAME_ as NAME3_16_17_, taskmgmtde18_.PROCESSDEFINITION_ as PROCESSD4_16_17_, taskmgmtde18_.STARTTASK_ as STARTTASK5_16_17_, tasknode19_.ID_ as ID1_18_, tasknode19_.NAME_ as NAME3_5_18_, tasknode19_.PROCESSDEFINITION_ as PROCESSD4_5_18_, tasknode19_.ACTION_ as ACTION5_5_18_, tasknode19_.SUPERSTATE_ as SUPERSTATE6_5_18_, tasknode19_.SIGNAL_ as SIGNAL10_5_18_, tasknode19_.CREATETASKS_ as CREATET11_5_18_, startstate20_.ID_ as ID1_19_, startstate20_.NAME_ as NAME3_5_19_, startstate20_.PROCESSDEFINITION_ as PROCESSD4_5_19_, startstate20_.ACTION_ as ACTION5_5_19_, startstate20_.SUPERSTATE_ as SUPERSTATE6_5_19_, startstate20_.initiatorSwimlane as initiato7_5_19_, delegation21_.ID_ as ID1_20_, delegation21_.CLASSNAME_ as CLASSNAME2_10_20_, delegation21_.CONFIGURATION_ as CONFIGUR3_10_20_, delegation21_.CONFIGTYPE_ as CONFIGTYPE4_10_20_, delegation21_.PROCESSDEFINITION_ as PROCESSD5_10_20_, swimlane22_.ID_ as ID1_21_, swimlane22_.NAME_ as NAME2_13_21_, swimlane22_.ASSIGNMENTDELEGATION_ as ASSIGNME3_13_21_, swimlane22_.TASKMGMTDEFINITION_ as TASKMGMT4_13_21_, taskcontro23_.ID_ as ID1_22_, taskcontro23_.TASKCONTROLLERDELEGATION_ as TASKCONT2_15_22_, delegation24_.ID_ as ID1_23_, delegation24_.CLASSNAME_ as CLASSNAME2_10_23_, delegation24_.CONFIGURATION_ as CONFIGUR3_10_23_, delegation24_.CONFIGTYPE_ as CONFIGTYPE4_10_23_, delegation24_.PROCESSDEFINITION_ as PROCESSD5_10_23_, token25_.ID_ as ID1_24_, token25_.NAME_ as NAME2_21_24_, token25_.START_ as START3_21_24_, token25_.END_ as END4_21_24_, token25_.NODEENTER_ as NODEENTER5_21_24_, token25_.NEXTLOGINDEX_ as NEXTLOGI6_21_24_, token25_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_24_, token25_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_24_, token25_.NODE_ as NODE9_21_24_, token25_.PROCESSINSTANCE_ as PROCESS10_21_24_, token25_.PARENT_ as PARENT11_21_24_, node26_.ID_ as ID1_25_, node26_.NAME_ as NAME3_5_25_, node26_.PROCESSDEFINITION_ as PROCESSD4_5_25_, node26_.ACTION_ as ACTION5_5_25_, node26_.SUPERSTATE_ as SUPERSTATE6_5_25_, node26_.initiatorSwimlane as initiato7_5_25_, node26_.SUBPROCESSDEFINITION_ as SUBPROCE8_5_25_, node26_.DECISIONDELEGATION as DECISION9_5_25_, node26_.SIGNAL_ as SIGNAL10_5_25_, node26_.CREATETASKS_ as CREATET11_5_25_, node26_.CLASS_ as CLASS2_25_, processdef27_.ID_ as ID1_26_, processdef27_.NAME_ as NAME2_4_26_, processdef27_.VERSION_ as VERSION3_4_26_, processdef27_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_26_, processdef27_.STARTSTATE_ as STARTSTATE5_4_26_, delegation28_.ID_ as ID1_27_, delegation28_.CLASSNAME_ as CLASSNAME2_10_27_, delegation28_.CONFIGURATION_ as CONFIGUR3_10_27_, delegation28_.CONFIGTYPE_ as CONFIGTYPE4_10_27_, delegation28_.PROCESSDEFINITION_ as PROCESSD5_10_27_, processins29_.ID_ as ID1_28_, processins29_.START_ as START2_20_28_, processins29_.END_ as END3_20_28_, processins29_.PROCESSDEFINITION_ as PROCESSD4_20_28_, processins29_.ROOTTOKEN_ as ROOTTOKEN5_20_28_, processins29_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_28_, token30_.ID_ as ID1_29_, token30_.NAME_ as NAME2_21_29_, token30_.START_ as START3_21_29_, token30_.END_ as END4_21_29_, token30_.NODEENTER_ as NODEENTER5_21_29_, token30_.NEXTLOGINDEX_ as NEXTLOGI6_21_29_, token30_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_29_, token30_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_29_, token30_.NODE_ as NODE9_21_29_, token30_.PROCESSINSTANCE_ as PROCESS10_21_29_, token30_.PARENT_ as PARENT11_21_29_, token31_.ID_ as ID1_30_, token31_.NAME_ as NAME2_21_30_, token31_.START_ as START3_21_30_, token31_.END_ as END4_21_30_, token31_.NODEENTER_ as NODEENTER5_21_30_, token31_.NEXTLOGINDEX_ as NEXTLOGI6_21_30_, token31_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_30_, token31_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_30_, token31_.NODE_ as NODE9_21_30_, token31_.PROCESSINSTANCE_ as PROCESS10_21_30_, token31_.PARENT_ as PARENT11_21_30_ from JBPM_PROCESSINSTANCE processins0_ left outer join JBPM_PROCESSDEFINITION processdef1_ on processins0_.PROCESSDEFINITION_=processdef1_.ID_ left outer join JBPM_NODE startstate2_ on processdef1_.STARTSTATE_=startstate2_.ID_ left outer join JBPM_PROCESSDEFINITION processdef3_ on startstate2_.PROCESSDEFINITION_=processdef3_.ID_ left outer join JBPM_ACTION action4_ on startstate2_.ACTION_=action4_.ID_ left outer join JBPM_ACTION action5_ on action4_.REFERENCEDACTION_=action5_.ID_ left outer join JBPM_DELEGATION delegation6_ on action5_.ACTIONDELEGATION_=delegation6_.ID_ left outer join JBPM_PROCESSDEFINITION processdef7_ on delegation6_.PROCESSDEFINITION_=processdef7_.ID_ left outer join JBPM_EVENT event8_ on action5_.EVENT_=event8_.ID_ left outer join JBPM_PROCESSDEFINITION processdef9_ on action5_.PROCESSDEFINITION_=processdef9_.ID_ left outer join JBPM_ACTION action10_ on action5_.TIMERACTION_=action10_.ID_ left outer join JBPM_NODE superstate11_ on startstate2_.SUPERSTATE_=superstate11_.ID_ left outer join JBPM_SWIMLANE swimlane12_ on startstate2_.initiatorSwimlane=swimlane12_.ID_ left outer join JBPM_DELEGATION delegation13_ on swimlane12_.ASSIGNMENTDELEGATION_=delegation13_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde14_ on swimlane12_.TASKMGMTDEFINITION_=taskmgmtde14_.ID_ left outer join JBPM_PROCESSDEFINITION processdef15_ on taskmgmtde14_.PROCESSDEFINITION_=processdef15_.ID_ left outer join JBPM_TASK task16_ on taskmgmtde14_.STARTTASK_=task16_.ID_ left outer join JBPM_PROCESSDEFINITION processdef17_ on task16_.PROCESSDEFINITION_=processdef17_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde18_ on task16_.TASKMGMTDEFINITION_=taskmgmtde18_.ID_ left outer join JBPM_NODE tasknode19_ on task16_.TASKNODE_=tasknode19_.ID_ left outer join JBPM_NODE startstate20_ on task16_.STARTSTATE_=startstate20_.ID_ left outer join JBPM_DELEGATION delegation21_ on task16_.ASSIGNMENTDELEGATION_=delegation21_.ID_ left outer join JBPM_SWIMLANE swimlane22_ on task16_.SWIMLANE_=swimlane22_.ID_ left outer join JBPM_TASKCONTROLLER taskcontro23_ on task16_.TASKCONTROLLER_=taskcontro23_.ID_ left outer join JBPM_DELEGATION delegation24_ on taskcontro23_.TASKCONTROLLERDELEGATION_=delegation24_.ID_ left outer join JBPM_TOKEN token25_ on processins0_.ROOTTOKEN_=token25_.ID_ left outer join JBPM_NODE node26_ on token25_.NODE_=node26_.ID_ left outer join JBPM_PROCESSDEFINITION processdef27_ on node26_.SUBPROCESSDEFINITION_=processdef27_.ID_ left outer join JBPM_DELEGATION delegation28_ on node26_.DECISIONDELEGATION=delegation28_.ID_ left outer join JBPM_PROCESSINSTANCE processins29_ on token25_.PROCESSINSTANCE_=processins29_.ID_ left outer join JBPM_TOKEN token30_ on processins29_.SUPERPROCESSTOKEN_=token30_.ID_ left outer join JBPM_TOKEN token31_ on token30_.PARENT_=token31_.ID_ where processins0_.ID_=?
      15:23:01,645 WARN ErrorCounter : *** WARNING: Keyword 'end' is being intepreted as an identifier due to: expecting IDENT, found 'end'
      Hibernate: select taskinstan0_.ID_ as ID1_, taskinstan0_.NAME_ as NAME2_26_, taskinstan0_.DESCRIPTION_ as DESCRIPT3_26_, taskinstan0_.ACTORID_ as ACTORID4_26_, taskinstan0_.CREATE_ as CREATE5_26_, taskinstan0_.START_ as START6_26_, taskinstan0_.END_ as END7_26_, taskinstan0_.DUEDATE_ as DUEDATE8_26_, taskinstan0_.PRIORITY_ as PRIORITY9_26_, taskinstan0_.ISCANCELLED_ as ISCANCE10_26_, taskinstan0_.ISSIGNALLING_ as ISSIGNA11_26_, taskinstan0_.ISBLOCKING_ as ISBLOCKING12_26_, taskinstan0_.TASK_ as TASK13_26_, taskinstan0_.TOKEN_ as TOKEN14_26_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN15_26_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM16_26_ from JBPM_TASKINSTANCE taskinstan0_ where taskinstan0_.ACTORID_=? and (taskinstan0_.END_ is null) and taskinstan0_.ISCANCELLED_=false
      15:23:17,147 WARN JDBCExceptionReporter : SQL Error: -206, SQLState: 42703
      15:23:17,147 ERROR JDBCExceptionReporter : DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: FALSE
      15:23:17,147 WARN JDBCExceptionReporter : SQL Error: -727, SQLState: 56098
      15:23:17,147 ERROR JDBCExceptionReporter : DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-206;42703;FALSE
      15:23:17,147 WARN JDBCExceptionReporter : SQL Error: -727, SQLState: 56098
      15:23:17,147 ERROR JDBCExceptionReporter : DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-206;42703;FALSE
      15:23:17,147 ERROR TaskMgmtSession : org.hibernate.exception.SQLGrammarException: could not execute query
      15:23:17,147 DEBUG AbstractDbTestCase : ENDING org.jbpm.db.TaskMgmtSessionDbTest
      15:23:17,147 ERROR JbpmSession : java.lang.NullPointerException
      15:23:17,147 ERROR JbpmSession : couldn't rollback hibernate transaction
      org.hibernate.SessionException: Session is closed
      at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:131)
      at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:163)
      at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
      at org.jbpm.db.JbpmSession.handleException(JbpmSession.java:177)
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:106)
      at org.jbpm.db.AbstractDbTestCase.commitAndCloseSession(AbstractDbTestCase.java:90)
      at org.jbpm.db.AbstractDbTestCase.tearDown(AbstractDbTestCase.java:76)
      at junit.framework.TestCase.runBare(TestCase.java:130)
      at junit.framework.TestResult$1.protect(TestResult.java:106)
      at junit.framework.TestResult.runProtected(TestResult.java:124)
      at junit.framework.TestResult.run(TestResult.java:109)
      at junit.framework.TestCase.run(TestCase.java:118)
      at junit.framework.TestSuite.runTest(TestSuite.java:208)
      at junit.framework.TestSuite.run(TestSuite.java:203)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
      15:23:17,157 WARN JbpmSession : can't pop current session: are you calling JbpmSession.close() multiple times ?