Menu
▾
▴
[Jboss-dev-forums] [Design of JBoss jBPM] - Re: the latest jbpm.3 cannot switch db to MS Sqlserver
|
From: camunda <nu...@jb...> - 2005-08-30 18:57:11
|
Hi. we have a similar problem with mySQL. If qe query the tasklist | session.getTaskMgmtSession().findPooledTaskInstances(Arrays.asList(user= s)); |=20 this warning occurs and it seems that also taks are returned for already en= ded nodes! The hibernate log: | 15682 WARN [AWT-EventQueue-0] *** WARNING: Keyword 'end' is being in= tepreted as an identifier due to: expecting IDENT, found 'end' - org.hibern= ate.hql.ast.ErrorCounter.reportWarning(ErrorCounter.java:46)=20 | Hibernate: select distinct taskinstan2_.ID_ as ID1_, taskinstan2_.NAME_= as NAME2_26_, taskinstan2_.DESCRIPTION_ as DESCRIPT3_26_, taskinstan2_.ACT= ORID_ as ACTORID4_26_, taskinstan2_.CREATE_ as CREATE5_26_, taskinstan2_.ST= ART_ as START6_26_, taskinstan2_.END_ as END7_26_, taskinstan2_.DUEDATE_ as= DUEDATE8_26_, taskinstan2_.PRIORITY_ as PRIORITY9_26_, taskinstan2_.ISCANC= ELLED_ as ISCANCE10_26_, taskinstan2_.ISSIGNALLING_ as ISSIGNA11_26_, taski= nstan2_.ISBLOCKING_ as ISBLOCKING12_26_, taskinstan2_.TASK_ as TASK13_26_, = taskinstan2_.TOKEN_ as TOKEN14_26_, taskinstan2_.SWIMLANINSTANCE_ as SWIMLA= N15_26_, taskinstan2_.TASKMGMTINSTANCE_ as TASKMGM16_26_ from JBPM_POOLEDAC= TOR pooledacto0_ inner join JBPM_TASKACTORPOOL taskinstan1_ on pooledacto0_= .ID_=3Dtaskinstan1_.POOLEDACTOR_ inner join JBPM_TASKINSTANCE taskinstan2_ = on taskinstan1_.TASKINSTANCE_=3Dtaskinstan2_.ID_ where (pooledacto0_.ACTORI= D_ in (? , ? , ? , ? , ? , ? , ? , ? , ?)) and (taskinstan2_.ACTORID_ is nu= ll) and (taskinstan2_.END_ is null) and taskinstan2_.ISCANCELLED_=3Dfalse | Hibernate: select swimlanein0_.ID_ as ID1_6_, swimlanein0_.NAME_ as NAM= E2_29_6_, swimlanein0_.ACTORID_ as ACTORID3_29_6_, swimlanein0_.SWIMLANE_ a= s SWIMLANE4_29_6_, swimlanein0_.TASKMGMTINSTANCE_ as TASKMGMT5_29_6_, swiml= ane1_.ID_ as ID1_0_, swimlane1_.NAME_ as NAME2_13_0_, swimlane1_.ASSIGNMENT= DELEGATION_ as ASSIGNME3_13_0_, swimlane1_.TASKMGMTDEFINITION_ as TASKMGMT4= _13_0_, delegation2_.ID_ as ID1_1_, delegation2_.CLASSNAME_ as CLASSNAME2_1= 0_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_10_1_, delegation2_.CONFIGTY= PE_ as CONFIGTYPE4_10_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_10_1= _, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtd= e3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as START= TASK5_16_2_, taskmgmtin4_.ID_ as ID1_3_, taskmgmtin4_.PROCESSINSTANCE_ as P= ROCESSI3_23_3_, taskmgmtin4_.TASKMGMTDEFINITION_ as TASKMGMT4_23_3_, proces= sins5_.ID_ as ID1_4_, processins5_.START_ as START2_20_4_, processins5_.END= _ as END3_20_4_, processins5_.PROCESSDEFINITION_ as PROCESSD4_20_4_, proces= sins5_.ROOTTOKEN_ as ROOTTOKEN5_20_4_, processins5_.SUPERPROCESSTOKEN_ as S= UPERPRO6_20_4_, taskmgmtde6_.ID_ as ID1_5_, taskmgmtde6_.NAME_ as NAME3_16_= 5_, taskmgmtde6_.PROCESSDEFINITION_ as PROCESSD4_16_5_, taskmgmtde6_.STARTT= ASK_ as STARTTASK5_16_5_ from JBPM_SWIMLANEINSTANCE swimlanein0_ left outer= join JBPM_SWIMLANE swimlane1_ on swimlanein0_.SWIMLANE_=3Dswimlane1_.ID_ l= eft outer join JBPM_DELEGATION delegation2_ on swimlane1_.ASSIGNMENTDELEGAT= ION_=3Ddelegation2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ = on swimlane1_.TASKMGMTDEFINITION_=3Dtaskmgmtde3_.ID_ left outer join JBPM_M= ODULEINSTANCE taskmgmtin4_ on swimlanein0_.TASKMGMTINSTANCE_=3Dtaskmgmtin4_= .ID_ left outer join JBPM_PROCESSINSTANCE processins5_ on taskmgmtin4_.PROC= ESSINSTANCE_=3Dprocessins5_.ID_ left outer join JBPM_MODULEDEFINITION taskm= gmtde6_ on taskmgmtin4_.TASKMGMTDEFINITION_=3Dtaskmgmtde6_.ID_ where swimla= nein0_.ID_=3D? | 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_.NOD= EENTER_ as NODEENTER5_21_11_, token0_.NEXTLOGINDEX_ as NEXTLOGI6_21_11_, to= ken0_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_11_, token0_.ISTERMINATIONI= MPLICIT_ as ISTERMIN8_21_11_, token0_.NODE_ as NODE9_21_11_, token0_.PROCES= SINSTANCE_ as PROCESS10_21_11_, token0_.PARENT_ as PARENT11_21_11_, node1_.= ID_ as ID1_0_, node1_.NAME_ as NAME3_5_0_, node1_.PROCESSDEFINITION_ as PRO= CESSD4_5_0_, node1_.ACTION_ as ACTION5_5_0_, node1_.SUPERSTATE_ as SUPERSTA= TE6_5_0_, node1_.SUBPROCESSDEFINITION_ as SUBPROCE7_5_0_, node1_.DECISIONDE= LEGATION as DECISION8_5_0_, node1_.SIGNAL_ as SIGNAL9_5_0_, node1_.CREATETA= SKS_ 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_.STA= RTSTATE_ as STARTSTATE5_4_1_, action3_.ID_ as ID1_2_, action3_.NAME_ as NAM= E3_8_2_, action3_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_2_, action3_.REFEREN= CEDACTION_ 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 TIMER= NAME10_8_2_, action3_.DUEDATE_ as DUEDATE11_8_2_, action3_.REPEAT_ as REPEA= T12_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 PROCES= SD4_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_.ISTERMINATIONIMP= LICIT_ as ISTERMIN4_4_4_, processdef5_.STARTSTATE_ as STARTSTATE5_4_4_, del= egation6_.ID_ as ID1_5_, delegation6_.CLASSNAME_ as CLASSNAME2_10_5_, deleg= ation6_.CONFIGURATION_ as CONFIGUR3_10_5_, delegation6_.CONFIGTYPE_ as CONF= IGTYPE4_10_5_, delegation6_.PROCESSDEFINITION_ as PROCESSD5_10_5_, processi= ns7_.ID_ as ID1_6_, processins7_.START_ as START2_20_6_, processins7_.END_ = as END3_20_6_, processins7_.PROCESSDEFINITION_ as PROCESSD4_20_6_, processi= ns7_.ROOTTOKEN_ as ROOTTOKEN5_20_6_, processins7_.SUPERPROCESSTOKEN_ as SUP= ERPRO6_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_, token= 9_.NEXTLOGINDEX_ as NEXTLOGI6_21_8_, token9_.ISABLETOREACTIVATEPARENT_ as I= SABLETO7_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_, token1= 0_.NODEENTER_ as NODEENTER5_21_9_, token10_.NEXTLOGINDEX_ as NEXTLOGI6_21_9= _, token10_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_9_, token10_.ISTERMIN= ATIONIMPLICIT_ as ISTERMIN8_21_9_, token10_.NODE_ as NODE9_21_9_, token10_.= PROCESSINSTANCE_ as PROCESS10_21_9_, token10_.PARENT_ as PARENT11_21_9_, to= ken11_.ID_ as ID1_10_, token11_.NAME_ as NAME2_21_10_, token11_.START_ as S= TART3_21_10_, token11_.END_ as END4_21_10_, token11_.NODEENTER_ as NODEENTE= R5_21_10_, token11_.NEXTLOGINDEX_ as NEXTLOGI6_21_10_, token11_.ISABLETOREA= CTIVATEPARENT_ as ISABLETO7_21_10_, token11_.ISTERMINATIONIMPLICIT_ as ISTE= RMIN8_21_10_, token11_.NODE_ as NODE9_21_10_, token11_.PROCESSINSTANCE_ as = PROCESS10_21_10_, token11_.PARENT_ as PARENT11_21_10_ from JBPM_TOKEN token= 0_ left outer join JBPM_NODE node1_ on token0_.NODE_=3Dnode1_.ID_ left oute= r join JBPM_PROCESSDEFINITION processdef2_ on node1_.PROCESSDEFINITION_=3Dp= rocessdef2_.ID_ left outer join JBPM_ACTION action3_ on node1_.ACTION_=3Dac= tion3_.ID_ left outer join JBPM_NODE superstate4_ on node1_.SUPERSTATE_=3Ds= uperstate4_.ID_ left outer join JBPM_PROCESSDEFINITION processdef5_ on node= 1_.SUBPROCESSDEFINITION_=3Dprocessdef5_.ID_ left outer join JBPM_DELEGATION= delegation6_ on node1_.DECISIONDELEGATION=3Ddelegation6_.ID_ left outer jo= in JBPM_PROCESSINSTANCE processins7_ on token0_.PROCESSINSTANCE_=3Dprocessi= ns7_.ID_ left outer join JBPM_PROCESSDEFINITION processdef8_ on processins7= _.PROCESSDEFINITION_=3Dprocessdef8_.ID_ left outer join JBPM_TOKEN token9_ = on processins7_.ROOTTOKEN_=3Dtoken9_.ID_ left outer join JBPM_TOKEN token10= _ on processins7_.SUPERPROCESSTOKEN_=3Dtoken10_.ID_ left outer join JBPM_TO= KEN token11_ on token0_.PARENT_=3Dtoken11_.ID_ where token0_.ID_=3D? | Hibernate: select swimlanein0_.ID_ as ID1_6_, swimlanein0_.NAME_ as NAM= E2_29_6_, swimlanein0_.ACTORID_ as ACTORID3_29_6_, swimlanein0_.SWIMLANE_ a= s SWIMLANE4_29_6_, swimlanein0_.TASKMGMTINSTANCE_ as TASKMGMT5_29_6_, swiml= ane1_.ID_ as ID1_0_, swimlane1_.NAME_ as NAME2_13_0_, swimlane1_.ASSIGNMENT= DELEGATION_ as ASSIGNME3_13_0_, swimlane1_.TASKMGMTDEFINITION_ as TASKMGMT4= _13_0_, delegation2_.ID_ as ID1_1_, delegation2_.CLASSNAME_ as CLASSNAME2_1= 0_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_10_1_, delegation2_.CONFIGTY= PE_ as CONFIGTYPE4_10_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_10_1= _, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtd= e3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as START= TASK5_16_2_, taskmgmtin4_.ID_ as ID1_3_, taskmgmtin4_.PROCESSINSTANCE_ as P= ROCESSI3_23_3_, taskmgmtin4_.TASKMGMTDEFINITION_ as TASKMGMT4_23_3_, proces= sins5_.ID_ as ID1_4_, processins5_.START_ as START2_20_4_, processins5_.END= _ as END3_20_4_, processins5_.PROCESSDEFINITION_ as PROCESSD4_20_4_, proces= sins5_.ROOTTOKEN_ as ROOTTOKEN5_20_4_, processins5_.SUPERPROCESSTOKEN_ as S= UPERPRO6_20_4_, taskmgmtde6_.ID_ as ID1_5_, taskmgmtde6_.NAME_ as NAME3_16_= 5_, taskmgmtde6_.PROCESSDEFINITION_ as PROCESSD4_16_5_, taskmgmtde6_.STARTT= ASK_ as STARTTASK5_16_5_ from JBPM_SWIMLANEINSTANCE swimlanein0_ left outer= join JBPM_SWIMLANE swimlane1_ on swimlanein0_.SWIMLANE_=3Dswimlane1_.ID_ l= eft outer join JBPM_DELEGATION delegation2_ on swimlane1_.ASSIGNMENTDELEGAT= ION_=3Ddelegation2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ = on swimlane1_.TASKMGMTDEFINITION_=3Dtaskmgmtde3_.ID_ left outer join JBPM_M= ODULEINSTANCE taskmgmtin4_ on swimlanein0_.TASKMGMTINSTANCE_=3Dtaskmgmtin4_= .ID_ left outer join JBPM_PROCESSINSTANCE processins5_ on taskmgmtin4_.PROC= ESSINSTANCE_=3Dprocessins5_.ID_ left outer join JBPM_MODULEDEFINITION taskm= gmtde6_ on taskmgmtin4_.TASKMGMTDEFINITION_=3Dtaskmgmtde6_.ID_ where swimla= nein0_.ID_=3D? | Hibernate: select task0_.ID_ as ID1_17_, task0_.NAME_ as NAME2_14_17_, = task0_.PROCESSDEFINITION_ as PROCESSD3_14_17_, task0_.DESCRIPTION_ as DESCR= IPT4_14_17_, task0_.ISBLOCKING_ as ISBLOCKING5_14_17_, task0_.DUEDATE_ as D= UEDATE6_14_17_, task0_.TASKMGMTDEFINITION_ as TASKMGMT7_14_17_, task0_.TASK= NODE_ 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_.STA= RTSTATE_ as STARTSTATE5_4_0_, startstate2_.ID_ as ID1_1_, startstate2_.NAME= _ as NAME3_5_1_, startstate2_.PROCESSDEFINITION_ as PROCESSD4_5_1_, startst= ate2_.ACTION_ as ACTION5_5_1_, startstate2_.SUPERSTATE_ as SUPERSTATE6_5_1_= , taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtde= 3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as STARTT= ASK5_16_2_, processdef4_.ID_ as ID1_3_, processdef4_.NAME_ as NAME2_4_3_, p= rocessdef4_.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 PROCE= SSD3_14_4_, task5_.DESCRIPTION_ as DESCRIPT4_14_4_, task5_.ISBLOCKING_ as I= SBLOCKING5_14_4_, task5_.DUEDATE_ as DUEDATE6_14_4_, task5_.TASKMGMTDEFINIT= ION_ as TASKMGMT7_14_4_, task5_.TASKNODE_ as TASKNODE8_14_4_, task5_.STARTS= TATE_ 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_.STARTS= TATE_ as STARTSTATE5_4_6_, action8_.ID_ as ID1_7_, action8_.NAME_ as NAME3_= 8_7_, action8_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_7_, action8_.REFERENCED= ACTION_ as REFERENC5_8_7_, action8_.ACTIONDELEGATION_ as ACTIONDE6_8_7_, ac= tion8_.EVENT_ as EVENT7_8_7_, action8_.PROCESSDEFINITION_ as PROCESSD8_8_7_= , action8_.EXPRESSION_ as EXPRESSION9_8_7_, action8_.TIMERNAME_ as TIMERNAM= E10_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_, sup= erstate9_.NAME_ as NAME3_5_8_, superstate9_.PROCESSDEFINITION_ as PROCESSD4= _5_8_, superstate9_.ACTION_ as ACTION5_5_8_, superstate9_.SUPERSTATE_ as SU= PERSTATE6_5_8_, startstate10_.ID_ as ID1_9_, startstate10_.NAME_ as NAME3_5= _9_, startstate10_.PROCESSDEFINITION_ as PROCESSD4_5_9_, startstate10_.ACTI= ON_ as ACTION5_5_9_, startstate10_.SUPERSTATE_ as SUPERSTATE6_5_9_, delegat= ion11_.ID_ as ID1_10_, delegation11_.CLASSNAME_ as CLASSNAME2_10_10_, deleg= ation11_.CONFIGURATION_ as CONFIGUR3_10_10_, delegation11_.CONFIGTYPE_ as C= ONFIGTYPE4_10_10_, delegation11_.PROCESSDEFINITION_ as PROCESSD5_10_10_, pr= ocessdef12_.ID_ as ID1_11_, processdef12_.NAME_ as NAME2_4_11_, processdef1= 2_.VERSION_ as VERSION3_4_11_, processdef12_.ISTERMINATIONIMPLICIT_ as ISTE= RMIN4_4_11_, processdef12_.STARTSTATE_ as STARTSTATE5_4_11_, swimlane13_.ID= _ as ID1_12_, swimlane13_.NAME_ as NAME2_13_12_, swimlane13_.ASSIGNMENTDELE= GATION_ as ASSIGNME3_13_12_, swimlane13_.TASKMGMTDEFINITION_ as TASKMGMT4_1= 3_12_, delegation14_.ID_ as ID1_13_, delegation14_.CLASSNAME_ as CLASSNAME2= _10_13_, delegation14_.CONFIGURATION_ as CONFIGUR3_10_13_, delegation14_.CO= NFIGTYPE_ as CONFIGTYPE4_10_13_, delegation14_.PROCESSDEFINITION_ as PROCES= SD5_10_13_, taskmgmtde15_.ID_ as ID1_14_, taskmgmtde15_.NAME_ as NAME3_16_1= 4_, taskmgmtde15_.PROCESSDEFINITION_ as PROCESSD4_16_14_, taskmgmtde15_.STA= RTTASK_ as STARTTASK5_16_14_, taskcontro16_.ID_ as ID1_15_, taskcontro16_.T= ASKCONTROLLERDELEGATION_ 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_, del= egation17_.PROCESSDEFINITION_ as PROCESSD5_10_16_ from JBPM_TASK task0_ lef= t outer join JBPM_PROCESSDEFINITION processdef1_ on task0_.PROCESSDEFINITIO= N_=3Dprocessdef1_.ID_ left outer join JBPM_NODE startstate2_ on processdef1= _.STARTSTATE_=3Dstartstate2_.ID_ left outer join JBPM_MODULEDEFINITION task= mgmtde3_ on task0_.TASKMGMTDEFINITION_=3Dtaskmgmtde3_.ID_ left outer join J= BPM_PROCESSDEFINITION processdef4_ on taskmgmtde3_.PROCESSDEFINITION_=3Dpro= cessdef4_.ID_ left outer join JBPM_TASK task5_ on taskmgmtde3_.STARTTASK_= =3Dtask5_.ID_ left outer join JBPM_NODE tasknode6_ on task0_.TASKNODE_=3Dta= sknode6_.ID_ left outer join JBPM_PROCESSDEFINITION processdef7_ on tasknod= e6_.PROCESSDEFINITION_=3Dprocessdef7_.ID_ left outer join JBPM_ACTION actio= n8_ on tasknode6_.ACTION_=3Daction8_.ID_ left outer join JBPM_NODE supersta= te9_ on tasknode6_.SUPERSTATE_=3Dsuperstate9_.ID_ left outer join JBPM_NODE= startstate10_ on task0_.STARTSTATE_=3Dstartstate10_.ID_ left outer join JB= PM_DELEGATION delegation11_ on task0_.ASSIGNMENTDELEGATION_=3Ddelegation11_= .ID_ left outer join JBPM_PROCESSDEFINITION processdef12_ on delegation11_.= PROCESSDEFINITION_=3Dprocessdef12_.ID_ left outer join JBPM_SWIMLANE swimla= ne13_ on task0_.SWIMLANE_=3Dswimlane13_.ID_ left outer join JBPM_DELEGATION= delegation14_ on swimlane13_.ASSIGNMENTDELEGATION_=3Ddelegation14_.ID_ lef= t outer join JBPM_MODULEDEFINITION taskmgmtde15_ on swimlane13_.TASKMGMTDEF= INITION_=3Dtaskmgmtde15_.ID_ left outer join JBPM_TASKCONTROLLER taskcontro= 16_ on task0_.TASKCONTROLLER_=3Dtaskcontro16_.ID_ left outer join JBPM_DELE= GATION delegation17_ on taskcontro16_.TASKCONTROLLERDELEGATION_=3Ddelegatio= n17_.ID_ where task0_.ID_=3D? | 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_.NOD= EENTER_ as NODEENTER5_21_11_, token0_.NEXTLOGINDEX_ as NEXTLOGI6_21_11_, to= ken0_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_11_, token0_.ISTERMINATIONI= MPLICIT_ as ISTERMIN8_21_11_, token0_.NODE_ as NODE9_21_11_, token0_.PROCES= SINSTANCE_ as PROCESS10_21_11_, token0_.PARENT_ as PARENT11_21_11_, node1_.= ID_ as ID1_0_, node1_.NAME_ as NAME3_5_0_, node1_.PROCESSDEFINITION_ as PRO= CESSD4_5_0_, node1_.ACTION_ as ACTION5_5_0_, node1_.SUPERSTATE_ as SUPERSTA= TE6_5_0_, node1_.SUBPROCESSDEFINITION_ as SUBPROCE7_5_0_, node1_.DECISIONDE= LEGATION as DECISION8_5_0_, node1_.SIGNAL_ as SIGNAL9_5_0_, node1_.CREATETA= SKS_ 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_.STA= RTSTATE_ as STARTSTATE5_4_1_, action3_.ID_ as ID1_2_, action3_.NAME_ as NAM= E3_8_2_, action3_.ISPROPAGATIONALLOWED_ as ISPROPAG4_8_2_, action3_.REFEREN= CEDACTION_ 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 TIMER= NAME10_8_2_, action3_.DUEDATE_ as DUEDATE11_8_2_, action3_.REPEAT_ as REPEA= T12_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 PROCES= SD4_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_.ISTERMINATIONIMP= LICIT_ as ISTERMIN4_4_4_, processdef5_.STARTSTATE_ as STARTSTATE5_4_4_, del= egation6_.ID_ as ID1_5_, delegation6_.CLASSNAME_ as CLASSNAME2_10_5_, deleg= ation6_.CONFIGURATION_ as CONFIGUR3_10_5_, delegation6_.CONFIGTYPE_ as CONF= IGTYPE4_10_5_, delegation6_.PROCESSDEFINITION_ as PROCESSD5_10_5_, processi= ns7_.ID_ as ID1_6_, processins7_.START_ as START2_20_6_, processins7_.END_ = as END3_20_6_, processins7_.PROCESSDEFINITION_ as PROCESSD4_20_6_, processi= ns7_.ROOTTOKEN_ as ROOTTOKEN5_20_6_, processins7_.SUPERPROCESSTOKEN_ as SUP= ERPRO6_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_, token= 9_.NEXTLOGINDEX_ as NEXTLOGI6_21_8_, token9_.ISABLETOREACTIVATEPARENT_ as I= SABLETO7_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_, token1= 0_.NODEENTER_ as NODEENTER5_21_9_, token10_.NEXTLOGINDEX_ as NEXTLOGI6_21_9= _, token10_.ISABLETOREACTIVATEPARENT_ as ISABLETO7_21_9_, token10_.ISTERMIN= ATIONIMPLICIT_ as ISTERMIN8_21_9_, token10_.NODE_ as NODE9_21_9_, token10_.= PROCESSINSTANCE_ as PROCESS10_21_9_, token10_.PARENT_ as PARENT11_21_9_, to= ken11_.ID_ as ID1_10_, token11_.NAME_ as NAME2_21_10_, token11_.START_ as S= TART3_21_10_, token11_.END_ as END4_21_10_, token11_.NODEENTER_ as NODEENTE= R5_21_10_, token11_.NEXTLOGINDEX_ as NEXTLOGI6_21_10_, token11_.ISABLETOREA= CTIVATEPARENT_ as ISABLETO7_21_10_, token11_.ISTERMINATIONIMPLICIT_ as ISTE= RMIN8_21_10_, token11_.NODE_ as NODE9_21_10_, token11_.PROCESSINSTANCE_ as = PROCESS10_21_10_, token11_.PARENT_ as PARENT11_21_10_ from JBPM_TOKEN token= 0_ left outer join JBPM_NODE node1_ on token0_.NODE_=3Dnode1_.ID_ left oute= r join JBPM_PROCESSDEFINITION processdef2_ on node1_.PROCESSDEFINITION_=3Dp= rocessdef2_.ID_ left outer join JBPM_ACTION action3_ on node1_.ACTION_=3Dac= tion3_.ID_ left outer join JBPM_NODE superstate4_ on node1_.SUPERSTATE_=3Ds= uperstate4_.ID_ left outer join JBPM_PROCESSDEFINITION processdef5_ on node= 1_.SUBPROCESSDEFINITION_=3Dprocessdef5_.ID_ left outer join JBPM_DELEGATION= delegation6_ on node1_.DECISIONDELEGATION=3Ddelegation6_.ID_ left outer jo= in JBPM_PROCESSINSTANCE processins7_ on token0_.PROCESSINSTANCE_=3Dprocessi= ns7_.ID_ left outer join JBPM_PROCESSDEFINITION processdef8_ on processins7= _.PROCESSDEFINITION_=3Dprocessdef8_.ID_ left outer join JBPM_TOKEN token9_ = on processins7_.ROOTTOKEN_=3Dtoken9_.ID_ left outer join JBPM_TOKEN token10= _ on processins7_.SUPERPROCESSTOKEN_=3Dtoken10_.ID_ left outer join JBPM_TO= KEN token11_ on token0_.PARENT_=3Dtoken11_.ID_ where token0_.ID_=3D? | Hibernate: select swimlanein0_.ID_ as ID1_6_, swimlanein0_.NAME_ as NAM= E2_29_6_, swimlanein0_.ACTORID_ as ACTORID3_29_6_, swimlanein0_.SWIMLANE_ a= s SWIMLANE4_29_6_, swimlanein0_.TASKMGMTINSTANCE_ as TASKMGMT5_29_6_, swiml= ane1_.ID_ as ID1_0_, swimlane1_.NAME_ as NAME2_13_0_, swimlane1_.ASSIGNMENT= DELEGATION_ as ASSIGNME3_13_0_, swimlane1_.TASKMGMTDEFINITION_ as TASKMGMT4= _13_0_, delegation2_.ID_ as ID1_1_, delegation2_.CLASSNAME_ as CLASSNAME2_1= 0_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_10_1_, delegation2_.CONFIGTY= PE_ as CONFIGTYPE4_10_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_10_1= _, taskmgmtde3_.ID_ as ID1_2_, taskmgmtde3_.NAME_ as NAME3_16_2_, taskmgmtd= e3_.PROCESSDEFINITION_ as PROCESSD4_16_2_, taskmgmtde3_.STARTTASK_ as START= TASK5_16_2_, taskmgmtin4_.ID_ as ID1_3_, taskmgmtin4_.PROCESSINSTANCE_ as P= ROCESSI3_23_3_, taskmgmtin4_.TASKMGMTDEFINITION_ as TASKMGMT4_23_3_, proces= sins5_.ID_ as ID1_4_, processins5_.START_ as START2_20_4_, processins5_.END= _ as END3_20_4_, processins5_.PROCESSDEFINITION_ as PROCESSD4_20_4_, proces= sins5_.ROOTTOKEN_ as ROOTTOKEN5_20_4_, processins5_.SUPERPROCESSTOKEN_ as S= UPERPRO6_20_4_, taskmgmtde6_.ID_ as ID1_5_, taskmgmtde6_.NAME_ as NAME3_16_= 5_, taskmgmtde6_.PROCESSDEFINITION_ as PROCESSD4_16_5_, taskmgmtde6_.STARTT= ASK_ as STARTTASK5_16_5_ from JBPM_SWIMLANEINSTANCE swimlanein0_ left outer= join JBPM_SWIMLANE swimlane1_ on swimlanein0_.SWIMLANE_=3Dswimlane1_.ID_ l= eft outer join JBPM_DELEGATION delegation2_ on swimlane1_.ASSIGNMENTDELEGAT= ION_=3Ddelegation2_.ID_ left outer join JBPM_MODULEDEFINITION taskmgmtde3_ = on swimlane1_.TASKMGMTDEFINITION_=3Dtaskmgmtde3_.ID_ left outer join JBPM_M= ODULEINSTANCE taskmgmtin4_ on swimlanein0_.TASKMGMTINSTANCE_=3Dtaskmgmtin4_= .ID_ left outer join JBPM_PROCESSINSTANCE processins5_ on taskmgmtin4_.PROC= ESSINSTANCE_=3Dprocessins5_.ID_ left outer join JBPM_MODULEDEFINITION taskm= gmtde6_ on taskmgmtin4_.TASKMGMTDEFINITION_=3Dtaskmgmtde6_.ID_ where swimla= nein0_.ID_=3D? |=20 |=20 View the original post : http://www.jboss.org/index.html?module=3Dbb&op=3Dv= iewtopic&p=3D3892297#3892297 Reply to the post : http://www.jboss.org/index.html?module=3Dbb&op=3Dpostin= g&mode=3Dreply&p=3D3892297 |
