2 Replies Latest reply on Sep 5, 2005 1:33 AM by tryhard

    the latest jbpm.3 cannot switch db to MS Sqlserver

    aguizar

      I don't think this is a design issue but a deployment one. Anyway, from the first warning in the log trace (WARN ErrorCounter), I think the problem is caused by the dialect and/or the driver composing a query that does not adhere to sql server's particular grammar. To ease problem detection, turn on Hibernate's show_sql feature (set hibernate.show_sql to true) and repost the log trace showing the query that gets executed before the first warning in the jBPM Users forum.

        • 1. Re: the latest jbpm.3 cannot switch db to MS Sqlserver
          camunda

          Hi. we have a similar problem with mySQL. If qe query the tasklist

          session.getTaskMgmtSession().findPooledTaskInstances(Arrays.asList(users));
          


          this warning occurs and it seems that also taks are returned for already ended nodes!

          The hibernate log:
          15682 WARN [AWT-EventQueue-0] *** WARNING: Keyword 'end' is being intepreted as an identifier due to: expecting IDENT, found 'end' - org.hibernate.hql.ast.ErrorCounter.reportWarning(ErrorCounter.java:46)
          Hibernate: select distinct taskinstan2_.ID_ as ID1_, taskinstan2_.NAME_ as NAME2_26_, taskinstan2_.DESCRIPTION_ as DESCRIPT3_26_, taskinstan2_.ACTORID_ as ACTORID4_26_, taskinstan2_.CREATE_ as CREATE5_26_, taskinstan2_.START_ as START6_26_, taskinstan2_.END_ as END7_26_, taskinstan2_.DUEDATE_ as DUEDATE8_26_, taskinstan2_.PRIORITY_ as PRIORITY9_26_, taskinstan2_.ISCANCELLED_ as ISCANCE10_26_, taskinstan2_.ISSIGNALLING_ as ISSIGNA11_26_, taskinstan2_.ISBLOCKING_ as ISBLOCKING12_26_, taskinstan2_.TASK_ as TASK13_26_, taskinstan2_.TOKEN_ as TOKEN14_26_, taskinstan2_.SWIMLANINSTANCE_ as SWIMLAN15_26_, taskinstan2_.TASKMGMTINSTANCE_ as TASKMGM16_26_ from JBPM_POOLEDACTOR pooledacto0_ inner join JBPM_TASKACTORPOOL taskinstan1_ on pooledacto0_.ID_=taskinstan1_.POOLEDACTOR_ inner join JBPM_TASKINSTANCE taskinstan2_ on taskinstan1_.TASKINSTANCE_=taskinstan2_.ID_ where (pooledacto0_.ACTORID_ in (? , ? , ? , ? , ? , ? , ? , ? , ?)) and (taskinstan2_.ACTORID_ is null) and (taskinstan2_.END_ is null) and taskinstan2_.ISCANCELLED_=false
          Hibernate: select swimlanein0_.ID_ as ID1_6_, swimlanein0_.NAME_ as NAME2_29_6_, swimlanein0_.ACTORID_ as ACTORID3_29_6_, swimlanein0_.SWIMLANE_ as SWIMLANE4_29_6_, swimlanein0_.TASKMGMTINSTANCE_ as TASKMGMT5_29_6_, swimlane1_.ID_ as ID1_0_, swimlane1_.NAME_ as NAME2_13_0_, swimlane1_.ASSIGNMENTDELEGATION_ as ASSIGNME3_13_0_, swimlane1_.TASKMGMTDEFINITION_ as TASKMGMT4_13_0_, delegation2_.ID_ as ID1_1_, delegation2_.CLASSNAME_ as CLASSNAME2_10_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_10_1_, delegation2_.CONFIGTYPE_ as CONFIGTYPE4_10_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_10_1_, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtde3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as STARTTASK5_16_2_, taskmgmtin4_.ID_ as ID1_3_, taskmgmtin4_.PROCESSINSTANCE_ as PROCESSI3_23_3_, taskmgmtin4_.TASKMGMTDEFINITION_ as TASKMGMT4_23_3_, processins5_.ID_ as ID1_4_, processins5_.START_ as START2_20_4_, processins5_.END_ as END3_20_4_, processins5_.PROCESSDEFINITION_ as PROCESSD4_20_4_, processins5_.ROOTTOKEN_ as ROOTTOKEN5_20_4_, processins5_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_4_, taskmgmtde6_.ID_ as ID1_5_, taskmgmtde6_.NAME_ as NAME3_16_5_, taskmgmtde6_.PROCESSDEFINITION_ as PROCESSD4_16_5_, taskmgmtde6_.STARTTASK_ as STARTTASK5_16_5_ from JBPM_SWIMLANEINSTANCE swimlanein0_ left outer join JBPM_SWIMLANE swimlane1_ on swimlanein0_.SWIMLANE_=swimlane1_.ID_ left outer join JBPM_DELEGATION delegation2_ on swimlane1_.ASSIGNMENTDELEGATION_=delegation2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ on swimlane1_.TASKMGMTDEFINITION_=taskmgmtde3_.ID_ left outer join JBPM_MODULEINSTANCE taskmgmtin4_ on swimlanein0_.TASKMGMTINSTANCE_=taskmgmtin4_.ID_ left outer join JBPM_PROCESSINSTANCE processins5_ on taskmgmtin4_.PROCESSINSTANCE_=processins5_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde6_ on taskmgmtin4_.TASKMGMTDEFINITION_=taskmgmtde6_.ID_ where swimlanein0_.ID_=?
          Hibernate: select token0_.ID_ as ID1_11_, token0_.NAME_ as NAME2_21_11_, token0_.START_ as START3_21_11_, token0_.END_ as END4_21_11_, token0_.NODEENTER_ as NODEENTER5_21_11_, token0_.NEXTLOGINDEX_ as NEXTLOGI6_21_11_, token0_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_11_, token0_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_11_, token0_.NODE_ as NODE9_21_11_, token0_.PROCESSINSTANCE_ as PROCESS10_21_11_, token0_.PARENT_ as PARENT11_21_11_, node1_.ID_ as ID1_0_, node1_.NAME_ as NAME3_5_0_, node1_.PROCESSDEFINITION_ as PROCESSD4_5_0_, node1_.ACTION_ as ACTION5_5_0_, node1_.SUPERSTATE_ as SUPERSTATE6_5_0_, node1_.SUBPROCESSDEFINITION_ as SUBPROCE7_5_0_, node1_.DECISIONDELEGATION as DECISION8_5_0_, node1_.SIGNAL_ as SIGNAL9_5_0_, node1_.CREATETASKS_ as CREATET10_5_0_, node1_.CLASS_ as CLASS2_0_, processdef2_.ID_ as ID1_1_, processdef2_.NAME_ as NAME2_4_1_, processdef2_.VERSION_ as VERSION3_4_1_, processdef2_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_1_, processdef2_.STARTSTATE_ as STARTSTATE5_4_1_, action3_.ID_ as ID1_2_, action3_.NAME_ as NAME3_8_2_, action3_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_2_, action3_.REFERENCEDACTION_ as REFERENC5_8_2_, action3_.ACTIONDELEGATION_ as ACTIONDE6_8_2_, action3_.EVENT_ as EVENT7_8_2_, action3_.PROCESSDEFINITION_ as PROCESSD8_8_2_, action3_.EXPRESSION_ as EXPRESSION9_8_2_, action3_.TIMERNAME_ as TIMERNAME10_8_2_, action3_.DUEDATE_ as DUEDATE11_8_2_, action3_.REPEAT_ as REPEAT12_8_2_, action3_.TRANSITIONNAME_ as TRANSIT13_8_2_, action3_.TIMERACTION_ as TIMERAC14_8_2_, action3_.class as class2_, superstate4_.ID_ as ID1_3_, superstate4_.NAME_ as NAME3_5_3_, superstate4_.PROCESSDEFINITION_ as PROCESSD4_5_3_, superstate4_.ACTION_ as ACTION5_5_3_, superstate4_.SUPERSTATE_ as SUPERSTATE6_5_3_, processdef5_.ID_ as ID1_4_, processdef5_.NAME_ as NAME2_4_4_, processdef5_.VERSION_ as VERSION3_4_4_, processdef5_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_4_, processdef5_.STARTSTATE_ as STARTSTATE5_4_4_, 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_, processins7_.ID_ as ID1_6_, processins7_.START_ as START2_20_6_, processins7_.END_ as END3_20_6_, processins7_.PROCESSDEFINITION_ as PROCESSD4_20_6_, processins7_.ROOTTOKEN_ as ROOTTOKEN5_20_6_, processins7_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_6_, processdef8_.ID_ as ID1_7_, processdef8_.NAME_ as NAME2_4_7_, processdef8_.VERSION_ as VERSION3_4_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_7_, processdef8_.STARTSTATE_ as STARTSTATE5_4_7_, token9_.ID_ as ID1_8_, token9_.NAME_ as NAME2_21_8_, token9_.START_ as START3_21_8_, token9_.END_ as END4_21_8_, token9_.NODEENTER_ as NODEENTER5_21_8_, token9_.NEXTLOGINDEX_ as NEXTLOGI6_21_8_, token9_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_8_, token9_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_8_, token9_.NODE_ as NODE9_21_8_, token9_.PROCESSINSTANCE_ as PROCESS10_21_8_, token9_.PARENT_ as PARENT11_21_8_, token10_.ID_ as ID1_9_, token10_.NAME_ as NAME2_21_9_, token10_.START_ as START3_21_9_, token10_.END_ as END4_21_9_, token10_.NODEENTER_ as NODEENTER5_21_9_, token10_.NEXTLOGINDEX_ as NEXTLOGI6_21_9_, token10_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_9_, token10_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_9_, token10_.NODE_ as NODE9_21_9_, token10_.PROCESSINSTANCE_ as PROCESS10_21_9_, token10_.PARENT_ as PARENT11_21_9_, token11_.ID_ as ID1_10_, token11_.NAME_ as NAME2_21_10_, token11_.START_ as START3_21_10_, token11_.END_ as END4_21_10_, token11_.NODEENTER_ as NODEENTER5_21_10_, token11_.NEXTLOGINDEX_ as NEXTLOGI6_21_10_, token11_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_10_, token11_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_10_, token11_.NODE_ as NODE9_21_10_, token11_.PROCESSINSTANCE_ as PROCESS10_21_10_, token11_.PARENT_ as PARENT11_21_10_ from JBPM_TOKEN token0_ left outer join JBPM_NODE node1_ on token0_.NODE_=node1_.ID_ left outer join JBPM_PROCESSDEFINITION processdef2_ on node1_.PROCESSDEFINITION_=processdef2_.ID_ left outer join JBPM_ACTION action3_ on node1_.ACTION_=action3_.ID_ left outer join JBPM_NODE superstate4_ on node1_.SUPERSTATE_=superstate4_.ID_ left outer join JBPM_PROCESSDEFINITION processdef5_ on node1_.SUBPROCESSDEFINITION_=processdef5_.ID_ left outer join JBPM_DELEGATION delegation6_ on node1_.DECISIONDELEGATION=delegation6_.ID_ left outer join JBPM_PROCESSINSTANCE processins7_ on token0_.PROCESSINSTANCE_=processins7_.ID_ left outer join JBPM_PROCESSDEFINITION processdef8_ on processins7_.PROCESSDEFINITION_=processdef8_.ID_ left outer join JBPM_TOKEN token9_ on processins7_.ROOTTOKEN_=token9_.ID_ left outer join JBPM_TOKEN token10_ on processins7_.SUPERPROCESSTOKEN_=token10_.ID_ left outer join JBPM_TOKEN token11_ on token0_.PARENT_=token11_.ID_ where token0_.ID_=?
          Hibernate: select swimlanein0_.ID_ as ID1_6_, swimlanein0_.NAME_ as NAME2_29_6_, swimlanein0_.ACTORID_ as ACTORID3_29_6_, swimlanein0_.SWIMLANE_ as SWIMLANE4_29_6_, swimlanein0_.TASKMGMTINSTANCE_ as TASKMGMT5_29_6_, swimlane1_.ID_ as ID1_0_, swimlane1_.NAME_ as NAME2_13_0_, swimlane1_.ASSIGNMENTDELEGATION_ as ASSIGNME3_13_0_, swimlane1_.TASKMGMTDEFINITION_ as TASKMGMT4_13_0_, delegation2_.ID_ as ID1_1_, delegation2_.CLASSNAME_ as CLASSNAME2_10_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_10_1_, delegation2_.CONFIGTYPE_ as CONFIGTYPE4_10_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_10_1_, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtde3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as STARTTASK5_16_2_, taskmgmtin4_.ID_ as ID1_3_, taskmgmtin4_.PROCESSINSTANCE_ as PROCESSI3_23_3_, taskmgmtin4_.TASKMGMTDEFINITION_ as TASKMGMT4_23_3_, processins5_.ID_ as ID1_4_, processins5_.START_ as START2_20_4_, processins5_.END_ as END3_20_4_, processins5_.PROCESSDEFINITION_ as PROCESSD4_20_4_, processins5_.ROOTTOKEN_ as ROOTTOKEN5_20_4_, processins5_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_4_, taskmgmtde6_.ID_ as ID1_5_, taskmgmtde6_.NAME_ as NAME3_16_5_, taskmgmtde6_.PROCESSDEFINITION_ as PROCESSD4_16_5_, taskmgmtde6_.STARTTASK_ as STARTTASK5_16_5_ from JBPM_SWIMLANEINSTANCE swimlanein0_ left outer join JBPM_SWIMLANE swimlane1_ on swimlanein0_.SWIMLANE_=swimlane1_.ID_ left outer join JBPM_DELEGATION delegation2_ on swimlane1_.ASSIGNMENTDELEGATION_=delegation2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ on swimlane1_.TASKMGMTDEFINITION_=taskmgmtde3_.ID_ left outer join JBPM_MODULEINSTANCE taskmgmtin4_ on swimlanein0_.TASKMGMTINSTANCE_=taskmgmtin4_.ID_ left outer join JBPM_PROCESSINSTANCE processins5_ on taskmgmtin4_.PROCESSINSTANCE_=processins5_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde6_ on taskmgmtin4_.TASKMGMTDEFINITION_=taskmgmtde6_.ID_ where swimlanein0_.ID_=?
          Hibernate: select task0_.ID_ as ID1_17_, task0_.NAME_ as NAME2_14_17_, task0_.PROCESSDEFINITION_ as PROCESSD3_14_17_, task0_.DESCRIPTION_ as DESCRIPT4_14_17_, task0_.ISBLOCKING_ as ISBLOCKING5_14_17_, task0_.DUEDATE_ as DUEDATE6_14_17_, task0_.TASKMGMTDEFINITION_ as TASKMGMT7_14_17_, task0_.TASKNODE_ as TASKNODE8_14_17_, task0_.STARTSTATE_ as STARTSTATE9_14_17_, task0_.ASSIGNMENTDELEGATION_ as ASSIGNM10_14_17_, task0_.SWIMLANE_ as SWIMLANE11_14_17_, task0_.TASKCONTROLLER_ as TASKCON12_14_17_, 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_, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtde3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as STARTTASK5_16_2_, processdef4_.ID_ as ID1_3_, processdef4_.NAME_ as NAME2_4_3_, processdef4_.VERSION_ as VERSION3_4_3_, processdef4_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_3_, processdef4_.STARTSTATE_ as STARTSTATE5_4_3_, task5_.ID_ as ID1_4_, task5_.NAME_ as NAME2_14_4_, task5_.PROCESSDEFINITION_ as PROCESSD3_14_4_, task5_.DESCRIPTION_ as DESCRIPT4_14_4_, task5_.ISBLOCKING_ as ISBLOCKING5_14_4_, task5_.DUEDATE_ as DUEDATE6_14_4_, task5_.TASKMGMTDEFINITION_ as TASKMGMT7_14_4_, task5_.TASKNODE_ as TASKNODE8_14_4_, task5_.STARTSTATE_ as STARTSTATE9_14_4_, task5_.ASSIGNMENTDELEGATION_ as ASSIGNM10_14_4_, task5_.SWIMLANE_ as SWIMLANE11_14_4_, task5_.TASKCONTROLLER_ as TASKCON12_14_4_, tasknode6_.ID_ as ID1_5_, tasknode6_.NAME_ as NAME3_5_5_, tasknode6_.PROCESSDEFINITION_ as PROCESSD4_5_5_, tasknode6_.ACTION_ as ACTION5_5_5_, tasknode6_.SUPERSTATE_ as SUPERSTATE6_5_5_, tasknode6_.SIGNAL_ as SIGNAL9_5_5_, tasknode6_.CREATETASKS_ as CREATET10_5_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_, action8_.ID_ as ID1_7_, action8_.NAME_ as NAME3_8_7_, action8_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_7_, action8_.REFERENCEDACTION_ as REFERENC5_8_7_, action8_.ACTIONDELEGATION_ as ACTIONDE6_8_7_, action8_.EVENT_ as EVENT7_8_7_, action8_.PROCESSDEFINITION_ as PROCESSD8_8_7_, action8_.EXPRESSION_ as EXPRESSION9_8_7_, action8_.TIMERNAME_ as TIMERNAME10_8_7_, action8_.DUEDATE_ as DUEDATE11_8_7_, action8_.REPEAT_ as REPEAT12_8_7_, action8_.TRANSITIONNAME_ as TRANSIT13_8_7_, action8_.TIMERACTION_ as TIMERAC14_8_7_, action8_.class as class7_, superstate9_.ID_ as ID1_8_, superstate9_.NAME_ as NAME3_5_8_, superstate9_.PROCESSDEFINITION_ as PROCESSD4_5_8_, superstate9_.ACTION_ as ACTION5_5_8_, superstate9_.SUPERSTATE_ as SUPERSTATE6_5_8_, startstate10_.ID_ as ID1_9_, startstate10_.NAME_ as NAME3_5_9_, startstate10_.PROCESSDEFINITION_ as PROCESSD4_5_9_, startstate10_.ACTION_ as ACTION5_5_9_, startstate10_.SUPERSTATE_ as SUPERSTATE6_5_9_, delegation11_.ID_ as ID1_10_, delegation11_.CLASSNAME_ as CLASSNAME2_10_10_, delegation11_.CONFIGURATION_ as CONFIGUR3_10_10_, delegation11_.CONFIGTYPE_ as CONFIGTYPE4_10_10_, delegation11_.PROCESSDEFINITION_ as PROCESSD5_10_10_, processdef12_.ID_ as ID1_11_, processdef12_.NAME_ as NAME2_4_11_, processdef12_.VERSION_ as VERSION3_4_11_, processdef12_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_11_, processdef12_.STARTSTATE_ as STARTSTATE5_4_11_, swimlane13_.ID_ as ID1_12_, swimlane13_.NAME_ as NAME2_13_12_, swimlane13_.ASSIGNMENTDELEGATION_ as ASSIGNME3_13_12_, swimlane13_.TASKMGMTDEFINITION_ as TASKMGMT4_13_12_, delegation14_.ID_ as ID1_13_, delegation14_.CLASSNAME_ as CLASSNAME2_10_13_, delegation14_.CONFIGURATION_ as CONFIGUR3_10_13_, delegation14_.CONFIGTYPE_ as CONFIGTYPE4_10_13_, delegation14_.PROCESSDEFINITION_ as PROCESSD5_10_13_, taskmgmtde15_.ID_ as ID1_14_, taskmgmtde15_.NAME_ as NAME3_16_14_, taskmgmtde15_.PROCESSDEFINITION_ as PROCESSD4_16_14_, taskmgmtde15_.STARTTASK_ as STARTTASK5_16_14_, taskcontro16_.ID_ as ID1_15_, taskcontro16_.TASKCONTROLLERDELEGATION_ as TASKCONT2_15_15_, delegation17_.ID_ as ID1_16_, delegation17_.CLASSNAME_ as CLASSNAME2_10_16_, delegation17_.CONFIGURATION_ as CONFIGUR3_10_16_, delegation17_.CONFIGTYPE_ as CONFIGTYPE4_10_16_, delegation17_.PROCESSDEFINITION_ as PROCESSD5_10_16_ from JBPM_TASK task0_ left outer join JBPM_PROCESSDEFINITION processdef1_ on task0_.PROCESSDEFINITION_=processdef1_.ID_ left outer join JBPM_NODE startstate2_ on processdef1_.STARTSTATE_=startstate2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ on task0_.TASKMGMTDEFINITION_=taskmgmtde3_.ID_ left outer join JBPM_PROCESSDEFINITION processdef4_ on taskmgmtde3_.PROCESSDEFINITION_=processdef4_.ID_ left outer join JBPM_TASK task5_ on taskmgmtde3_.STARTTASK_=task5_.ID_ left outer join JBPM_NODE tasknode6_ on task0_.TASKNODE_=tasknode6_.ID_ left outer join JBPM_PROCESSDEFINITION processdef7_ on tasknode6_.PROCESSDEFINITION_=processdef7_.ID_ left outer join JBPM_ACTION action8_ on tasknode6_.ACTION_=action8_.ID_ left outer join JBPM_NODE superstate9_ on tasknode6_.SUPERSTATE_=superstate9_.ID_ left outer join JBPM_NODE startstate10_ on task0_.STARTSTATE_=startstate10_.ID_ left outer join JBPM_DELEGATION delegation11_ on task0_.ASSIGNMENTDELEGATION_=delegation11_.ID_ left outer join JBPM_PROCESSDEFINITION processdef12_ on delegation11_.PROCESSDEFINITION_=processdef12_.ID_ left outer join JBPM_SWIMLANE swimlane13_ on task0_.SWIMLANE_=swimlane13_.ID_ left outer join JBPM_DELEGATION delegation14_ on swimlane13_.ASSIGNMENTDELEGATION_=delegation14_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde15_ on swimlane13_.TASKMGMTDEFINITION_=taskmgmtde15_.ID_ left outer join JBPM_TASKCONTROLLER taskcontro16_ on task0_.TASKCONTROLLER_=taskcontro16_.ID_ left outer join JBPM_DELEGATION delegation17_ on taskcontro16_.TASKCONTROLLERDELEGATION_=delegation17_.ID_ where task0_.ID_=?
          Hibernate: select token0_.ID_ as ID1_11_, token0_.NAME_ as NAME2_21_11_, token0_.START_ as START3_21_11_, token0_.END_ as END4_21_11_, token0_.NODEENTER_ as NODEENTER5_21_11_, token0_.NEXTLOGINDEX_ as NEXTLOGI6_21_11_, token0_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_11_, token0_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_11_, token0_.NODE_ as NODE9_21_11_, token0_.PROCESSINSTANCE_ as PROCESS10_21_11_, token0_.PARENT_ as PARENT11_21_11_, node1_.ID_ as ID1_0_, node1_.NAME_ as NAME3_5_0_, node1_.PROCESSDEFINITION_ as PROCESSD4_5_0_, node1_.ACTION_ as ACTION5_5_0_, node1_.SUPERSTATE_ as SUPERSTATE6_5_0_, node1_.SUBPROCESSDEFINITION_ as SUBPROCE7_5_0_, node1_.DECISIONDELEGATION as DECISION8_5_0_, node1_.SIGNAL_ as SIGNAL9_5_0_, node1_.CREATETASKS_ as CREATET10_5_0_, node1_.CLASS_ as CLASS2_0_, processdef2_.ID_ as ID1_1_, processdef2_.NAME_ as NAME2_4_1_, processdef2_.VERSION_ as VERSION3_4_1_, processdef2_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_1_, processdef2_.STARTSTATE_ as STARTSTATE5_4_1_, action3_.ID_ as ID1_2_, action3_.NAME_ as NAME3_8_2_, action3_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_2_, action3_.REFERENCEDACTION_ as REFERENC5_8_2_, action3_.ACTIONDELEGATION_ as ACTIONDE6_8_2_, action3_.EVENT_ as EVENT7_8_2_, action3_.PROCESSDEFINITION_ as PROCESSD8_8_2_, action3_.EXPRESSION_ as EXPRESSION9_8_2_, action3_.TIMERNAME_ as TIMERNAME10_8_2_, action3_.DUEDATE_ as DUEDATE11_8_2_, action3_.REPEAT_ as REPEAT12_8_2_, action3_.TRANSITIONNAME_ as TRANSIT13_8_2_, action3_.TIMERACTION_ as TIMERAC14_8_2_, action3_.class as class2_, superstate4_.ID_ as ID1_3_, superstate4_.NAME_ as NAME3_5_3_, superstate4_.PROCESSDEFINITION_ as PROCESSD4_5_3_, superstate4_.ACTION_ as ACTION5_5_3_, superstate4_.SUPERSTATE_ as SUPERSTATE6_5_3_, processdef5_.ID_ as ID1_4_, processdef5_.NAME_ as NAME2_4_4_, processdef5_.VERSION_ as VERSION3_4_4_, processdef5_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_4_, processdef5_.STARTSTATE_ as STARTSTATE5_4_4_, 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_, processins7_.ID_ as ID1_6_, processins7_.START_ as START2_20_6_, processins7_.END_ as END3_20_6_, processins7_.PROCESSDEFINITION_ as PROCESSD4_20_6_, processins7_.ROOTTOKEN_ as ROOTTOKEN5_20_6_, processins7_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_6_, processdef8_.ID_ as ID1_7_, processdef8_.NAME_ as NAME2_4_7_, processdef8_.VERSION_ as VERSION3_4_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_7_, processdef8_.STARTSTATE_ as STARTSTATE5_4_7_, token9_.ID_ as ID1_8_, token9_.NAME_ as NAME2_21_8_, token9_.START_ as START3_21_8_, token9_.END_ as END4_21_8_, token9_.NODEENTER_ as NODEENTER5_21_8_, token9_.NEXTLOGINDEX_ as NEXTLOGI6_21_8_, token9_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_8_, token9_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_8_, token9_.NODE_ as NODE9_21_8_, token9_.PROCESSINSTANCE_ as PROCESS10_21_8_, token9_.PARENT_ as PARENT11_21_8_, token10_.ID_ as ID1_9_, token10_.NAME_ as NAME2_21_9_, token10_.START_ as START3_21_9_, token10_.END_ as END4_21_9_, token10_.NODEENTER_ as NODEENTER5_21_9_, token10_.NEXTLOGINDEX_ as NEXTLOGI6_21_9_, token10_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_9_, token10_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_9_, token10_.NODE_ as NODE9_21_9_, token10_.PROCESSINSTANCE_ as PROCESS10_21_9_, token10_.PARENT_ as PARENT11_21_9_, token11_.ID_ as ID1_10_, token11_.NAME_ as NAME2_21_10_, token11_.START_ as START3_21_10_, token11_.END_ as END4_21_10_, token11_.NODEENTER_ as NODEENTER5_21_10_, token11_.NEXTLOGINDEX_ as NEXTLOGI6_21_10_, token11_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_10_, token11_.ISTERMINATIONIMPLICIT_ as ISTERMIN8_21_10_, token11_.NODE_ as NODE9_21_10_, token11_.PROCESSINSTANCE_ as PROCESS10_21_10_, token11_.PARENT_ as PARENT11_21_10_ from JBPM_TOKEN token0_ left outer join JBPM_NODE node1_ on token0_.NODE_=node1_.ID_ left outer join JBPM_PROCESSDEFINITION processdef2_ on node1_.PROCESSDEFINITION_=processdef2_.ID_ left outer join JBPM_ACTION action3_ on node1_.ACTION_=action3_.ID_ left outer join JBPM_NODE superstate4_ on node1_.SUPERSTATE_=superstate4_.ID_ left outer join JBPM_PROCESSDEFINITION processdef5_ on node1_.SUBPROCESSDEFINITION_=processdef5_.ID_ left outer join JBPM_DELEGATION delegation6_ on node1_.DECISIONDELEGATION=delegation6_.ID_ left outer join JBPM_PROCESSINSTANCE processins7_ on token0_.PROCESSINSTANCE_=processins7_.ID_ left outer join JBPM_PROCESSDEFINITION processdef8_ on processins7_.PROCESSDEFINITION_=processdef8_.ID_ left outer join JBPM_TOKEN token9_ on processins7_.ROOTTOKEN_=token9_.ID_ left outer join JBPM_TOKEN token10_ on processins7_.SUPERPROCESSTOKEN_=token10_.ID_ left outer join JBPM_TOKEN token11_ on token0_.PARENT_=token11_.ID_ where token0_.ID_=?
          Hibernate: select swimlanein0_.ID_ as ID1_6_, swimlanein0_.NAME_ as NAME2_29_6_, swimlanein0_.ACTORID_ as ACTORID3_29_6_, swimlanein0_.SWIMLANE_ as SWIMLANE4_29_6_, swimlanein0_.TASKMGMTINSTANCE_ as TASKMGMT5_29_6_, swimlane1_.ID_ as ID1_0_, swimlane1_.NAME_ as NAME2_13_0_, swimlane1_.ASSIGNMENTDELEGATION_ as ASSIGNME3_13_0_, swimlane1_.TASKMGMTDEFINITION_ as TASKMGMT4_13_0_, delegation2_.ID_ as ID1_1_, delegation2_.CLASSNAME_ as CLASSNAME2_10_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_10_1_, delegation2_.CONFIGTYPE_ as CONFIGTYPE4_10_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_10_1_, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtde3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as STARTTASK5_16_2_, taskmgmtin4_.ID_ as ID1_3_, taskmgmtin4_.PROCESSINSTANCE_ as PROCESSI3_23_3_, taskmgmtin4_.TASKMGMTDEFINITION_ as TASKMGMT4_23_3_, processins5_.ID_ as ID1_4_, processins5_.START_ as START2_20_4_, processins5_.END_ as END3_20_4_, processins5_.PROCESSDEFINITION_ as PROCESSD4_20_4_, processins5_.ROOTTOKEN_ as ROOTTOKEN5_20_4_, processins5_.SUPERPROCESSTOKEN_ as SUPERPRO6_20_4_, taskmgmtde6_.ID_ as ID1_5_, taskmgmtde6_.NAME_ as NAME3_16_5_, taskmgmtde6_.PROCESSDEFINITION_ as PROCESSD4_16_5_, taskmgmtde6_.STARTTASK_ as STARTTASK5_16_5_ from JBPM_SWIMLANEINSTANCE swimlanein0_ left outer join JBPM_SWIMLANE swimlane1_ on swimlanein0_.SWIMLANE_=swimlane1_.ID_ left outer join JBPM_DELEGATION delegation2_ on swimlane1_.ASSIGNMENTDELEGATION_=delegation2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ on swimlane1_.TASKMGMTDEFINITION_=taskmgmtde3_.ID_ left outer join JBPM_MODULEINSTANCE taskmgmtin4_ on swimlanein0_.TASKMGMTINSTANCE_=taskmgmtin4_.ID_ left outer join JBPM_PROCESSINSTANCE processins5_ on taskmgmtin4_.PROCESSINSTANCE_=processins5_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde6_ on taskmgmtin4_.TASKMGMTDEFINITION_=taskmgmtde6_.ID_ where swimlanein0_.ID_=?
          
          


          • 2. Re: the latest jbpm.3 cannot switch db to MS Sqlserver
            tryhard

            I've solve the problem.
            just add the entry "hibernate.query.substitutions=true 1,false 0"
            to hibernate.properties.

            regards,
            tryhard.