-
15. Re: Timer problems
"enazareno" wrote:
Hello,
I would like to correct my previous statement regarding the jbpm_timer table. In the websale example, it is not populated yet at the start. It only populates when entering the "evaluate web order" node or from the web when you submit the new web sale order. So, run first the web sale example, login for example cookie monster, then press "create new web sale order". Put in values and click on "Save and Close Task". Then check your jbpm_table. There should be an entry in there. Also in the console you will see the "ernie ..." alert message. The entry in the jbpm_timer will be deleted when ernie acknowledges the order. I hope this clarifies things.
Regards,
Elmo
Hi
If i do this i'll have to modify my env, couse i'm not using authentication and authorization of jbpm (identity). My application has an authentication and authorization and it will be some difficult to me to run in mey app.
But, if you see my processdefinition, it is like the websale sample.
but i will try more things!
My mail address (like asked for) is marcos@glr.com.br !
I'll appreciate some contacts ! if you prefere, this is my msn account (marcos-donato@uol.com.br) i'm on now !!
Thanks a lot -
16. Re: Timer problems
"mdonato" wrote:
"enazareno" wrote:
Hello,
I would like to correct my previous statement regarding the jbpm_timer table. In the websale example, it is not populated yet at the start. It only populates when entering the "evaluate web order" node or from the web when you submit the new web sale order. So, run first the web sale example, login for example cookie monster, then press "create new web sale order". Put in values and click on "Save and Close Task". Then check your jbpm_table. There should be an entry in there. Also in the console you will see the "ernie ..." alert message. The entry in the jbpm_timer will be deleted when ernie acknowledges the order. I hope this clarifies things.
Regards,
Elmo
One thing else,
i've observed that jbpm create events when it find a timer, and only when the flow reach the task with the timer, it will create an entry in JBPM_TIMER table, but in my case, it do not happens !
I'll try to run in jboss now !!!
testing, testing !!!! -
17. Re: Timer problems
HI,
This is my email address elmonazareno@yahoo.com.
I'm running mac and don't have an MSN account. i do have a Yahoo messenger. It's already late night and I am about to go home and
sleep. If you want, you can post me your code so i can
see it in the morning. Actually the users are not impt
for the example, it is just used for running the
websale. We can test using JBoss and
MSSQLserver if you want. I've tried other means of testing shortcuts but setting up the sample will give you lots of ideas esp. how to package the application to incorporate with your app.
(P.S. I tried sending you an email but it failed. Maybe you have blocked yahoo perhaps?)
Regards,
Elmo -
18. Re: Timer problems
"enazareno" wrote:
(P.S. I tried sending you an email but it failed. Maybe you have blocked yahoo perhaps?)
Owww !!!
You send the e-mail that matches our rules !!!
"Viruses Rule #55(Netsky). Your mail has a subject that match to virus subject and will not be accepted."
You send with subject "Hello" and it's not permitted !!! sory !
But turning back! i'll try to run it on jboss! 'couse i'm having problems with logger in websphere and some logs does not appear!!!!! (i'll see it later)
But we will keep in touch !!
See you later ! -
19. Re: Timer problems
Wow !!!!
I found a strange thing ! Take a look on this selects resuls!!!select PROCESSDEFINITION_ from JBPM_ACTION; PROCESSDEFINITION_ --------------------- NULL NULL NULL NULL NULL NULL NULL NULL (8 row(s) affected) select PROCESSDEFINITION_ from JBPM_DELEGATION; PROCESSDEFINITION_ --------------------- 150 150 151 151 151 151 151 151 (8 row(s) affected) select PROCESSDEFINITION_ from JBPM_EVENT; PROCESSDEFINITION_ --------------------- NULL NULL NULL NULL (4 row(s) affected) select PROCESSDEFINITION_ from JBPM_MODULEDEFINITION; PROCESSDEFINITION_ --------------------- 150 150 150 151 151 151 (6 row(s) affected) select PROCESSDEFINITION_ from JBPM_NODE; PROCESSDEFINITION_ --------------------- 150 150 150 151 151 151 151 151 151 151 151 151 (12 row(s) affected) select PROCESSDEFINITION_ from JBPM_PROCESSINSTANCE; PROCESSDEFINITION_ --------------------- 150 150 150 150 150 150 150 150 (8 row(s) affected) select PROCESSDEFINITION_ from JBPM_TASK; PROCESSDEFINITION_ --------------------- 150 151 151 151 151 (5 row(s) affected) select PROCESSDEFINITION_ from JBPM_TRANSITION; PROCESSDEFINITION_ --------------------- 150 150 151 151 151 151 151 151 151 151 151 151
And the log !!!!!2005-12-15 12:12:01,545 DEBUG [org.hibernate.SQL] select events0_.PROCESSDEFINITION_ as PROCESSD5_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_3_0_, events0_.EVENTTYPE_ as EVENTTYPE2_3_0_, events0_.TYPE_ as TYPE3_3_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_3_0_ from POPULIS.JBPM_EVENT events0_ where events0_.PROCESSDEFINITION_=? 2005-12-15 12:12:01,545 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement 2005-12-15 12:12:01,545 DEBUG [org.hibernate.type.LongType] binding '150' to parameter: 1 2005-12-15 12:12:01,670 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0) 2005-12-15 12:12:01,670 DEBUG [org.hibernate.loader.Loader] result set contains (possibly empty) collection: [org.jbpm.graph.def.ProcessDefinition.events#150] 2005-12-15 12:12:01,670 DEBUG [org.hibernate.engine.CollectionLoadContext] uninitialized collection: initializing 2005-12-15 12:12:01,670 DEBUG [org.hibernate.loader.Loader] processing result set 2005-12-15 12:12:01,670 DEBUG [org.hibernate.loader.Loader] done processing result set (0 rows) 2005-12-15 12:12:01,670 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1) 2005-12-15 12:12:01,670 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 2005-12-15 12:12:01,670 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement 2005-12-15 12:12:01,670 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection 2005-12-15 12:12:01,670 DEBUG [org.hibernate.jdbc.ConnectionManager] closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
This means, that when a instance of the process is created, an reach the task instance, it will look for the events associated with the process definitions, and it will never find it couse processdefinition is null.
What to do with this ??? -
20. Re: Timer problems
THis is the log for a start process instance !
select processdef0_.ID_ as col_0_0_ from POPULIS.JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc binding 'teste-timer-2' to parameter: 1 select processdef0_.ID_ as ID1_0_10_, processdef0_.NAME_ as NAME2_0_10_, processdef0_.VERSION_ as VERSION3_0_10_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_10_, processdef0_.STARTSTATE_ as STARTSTATE5_0_10_, startstate1_.ID_ as ID1_1_0_, startstate1_.NAME_ as NAME3_1_0_, startstate1_.PROCESSDEFINITION_ as PROCESSD4_1_0_, startstate1_.ACTION_ as ACTION5_1_0_, startstate1_.SUPERSTATE_ as SUPERSTATE6_1_0_, processdef2_.ID_ as ID1_0_1_, processdef2_.NAME_ as NAME2_0_1_, processdef2_.VERSION_ as VERSION3_0_1_, processdef2_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_1_, processdef2_.STARTSTATE_ as STARTSTATE5_0_1_, action3_.ID_ as ID1_4_2_, action3_.NAME_ as NAME3_4_2_, action3_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_2_, action3_.REFERENCEDACTION_ as REFERENC5_4_2_, action3_.ACTIONDELEGATION_ as ACTIONDE6_4_2_, action3_.EVENT_ as EVENT7_4_2_, action3_.PROCESSDEFINITION_ as PROCESSD8_4_2_, action3_.EXPRESSION_ as EXPRESSION9_4_2_, action3_.TIMERNAME_ as TIMERNAME10_4_2_, action3_.DUEDATE_ as DUEDATE11_4_2_, action3_.REPEAT_ as REPEAT12_4_2_, action3_.TRANSITIONNAME_ as TRANSIT13_4_2_, action3_.TIMERACTION_ as TIMERAC14_4_2_, action3_.class as class4_2_, action4_.ID_ as ID1_4_3_, action4_.NAME_ as NAME3_4_3_, action4_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_3_, action4_.REFERENCEDACTION_ as REFERENC5_4_3_, action4_.ACTIONDELEGATION_ as ACTIONDE6_4_3_, action4_.EVENT_ as EVENT7_4_3_, action4_.PROCESSDEFINITION_ as PROCESSD8_4_3_, action4_.EXPRESSION_ as EXPRESSION9_4_3_, action4_.TIMERNAME_ as TIMERNAME10_4_3_, action4_.DUEDATE_ as DUEDATE11_4_3_, action4_.REPEAT_ as REPEAT12_4_3_, action4_.TRANSITIONNAME_ as TRANSIT13_4_3_, action4_.TIMERACTION_ as TIMERAC14_4_3_, action4_.class as class4_3_, delegation5_.ID_ as ID1_6_4_, delegation5_.CLASSNAME_ as CLASSNAME2_6_4_, delegation5_.CONFIGURATION_ as CONFIGUR3_6_4_, delegation5_.CONFIGTYPE_ as CONFIGTYPE4_6_4_, delegation5_.PROCESSDEFINITION_ as PROCESSD5_6_4_, processdef6_.ID_ as ID1_0_5_, processdef6_.NAME_ as NAME2_0_5_, processdef6_.VERSION_ as VERSION3_0_5_, processdef6_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_5_, processdef6_.STARTSTATE_ as STARTSTATE5_0_5_, event7_.ID_ as ID1_3_6_, event7_.EVENTTYPE_ as EVENTTYPE2_3_6_, event7_.TYPE_ as TYPE3_3_6_, event7_.GRAPHELEMENT_ as GRAPHELE4_3_6_, processdef8_.ID_ as ID1_0_7_, processdef8_.NAME_ as NAME2_0_7_, processdef8_.VERSION_ as VERSION3_0_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_7_, processdef8_.STARTSTATE_ as STARTSTATE5_0_7_, action9_.ID_ as ID1_4_8_, action9_.NAME_ as NAME3_4_8_, action9_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_8_, action9_.REFERENCEDACTION_ as REFERENC5_4_8_, action9_.ACTIONDELEGATION_ as ACTIONDE6_4_8_, action9_.EVENT_ as EVENT7_4_8_, action9_.PROCESSDEFINITION_ as PROCESSD8_4_8_, action9_.EXPRESSION_ as EXPRESSION9_4_8_, action9_.TIMERNAME_ as TIMERNAME10_4_8_, action9_.DUEDATE_ as DUEDATE11_4_8_, action9_.REPEAT_ as REPEAT12_4_8_, action9_.TRANSITIONNAME_ as TRANSIT13_4_8_, action9_.TIMERACTION_ as TIMERAC14_4_8_, action9_.class as class4_8_, superstate10_.ID_ as ID1_1_9_, superstate10_.NAME_ as NAME3_1_9_, superstate10_.PROCESSDEFINITION_ as PROCESSD4_1_9_, superstate10_.ACTION_ as ACTION5_1_9_, superstate10_.SUPERSTATE_ as SUPERSTATE6_1_9_ from POPULIS.JBPM_PROCESSDEFINITION processdef0_ left outer join POPULIS.JBPM_NODE startstate1_ on processdef0_.STARTSTATE_=startstate1_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef2_ on startstate1_.PROCESSDEFINITION_=processdef2_.ID_ left outer join POPULIS.JBPM_ACTION action3_ on startstate1_.ACTION_=action3_.ID_ left outer join POPULIS.JBPM_ACTION action4_ on action3_.REFERENCEDACTION_=action4_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation5_ on action4_.ACTIONDELEGATION_=delegation5_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef6_ on delegation5_.PROCESSDEFINITION_=processdef6_.ID_ left outer join POPULIS.JBPM_EVENT event7_ on action4_.EVENT_=event7_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef8_ on action4_.PROCESSDEFINITION_=processdef8_.ID_ left outer join POPULIS.JBPM_ACTION action9_ on action4_.TIMERACTION_=action9_.ID_ left outer join POPULIS.JBPM_NODE superstate10_ on startstate1_.SUPERSTATE_=superstate10_.ID_ where processdef0_.ID_=? binding '150' to parameter: 1 select processdef0_.ID_ as col_0_0_ from POPULIS.JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc binding 'teste-timer-2' to parameter: 1 select definition0_.PROCESSDEFINITION_ as PROCESSD4_22_, definition0_.ID_ as ID1_22_, definition0_.NAME_ as NAME3_22_, definition0_.ID_ as ID1_12_21_, definition0_.NAME_ as NAME3_12_21_, definition0_.PROCESSDEFINITION_ as PROCESSD4_12_21_, definition0_.STARTTASK_ as STARTTASK5_12_21_, definition0_.CLASS_ as CLASS2_12_21_, task1_.ID_ as ID1_10_0_, task1_.NAME_ as NAME2_10_0_, task1_.PROCESSDEFINITION_ as PROCESSD3_10_0_, task1_.DESCRIPTION_ as DESCRIPT4_10_0_, task1_.ISBLOCKING_ as ISBLOCKING5_10_0_, task1_.DUEDATE_ as DUEDATE6_10_0_, task1_.TASKMGMTDEFINITION_ as TASKMGMT7_10_0_, task1_.TASKNODE_ as TASKNODE8_10_0_, task1_.STARTSTATE_ as STARTSTATE9_10_0_, task1_.ASSIGNMENTDELEGATION_ as ASSIGNM10_10_0_, task1_.SWIMLANE_ as SWIMLANE11_10_0_, task1_.TASKCONTROLLER_ as TASKCON12_10_0_, processdef2_.ID_ as ID1_0_1_, processdef2_.NAME_ as NAME2_0_1_, processdef2_.VERSION_ as VERSION3_0_1_, processdef2_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_1_, processdef2_.STARTSTATE_ as STARTSTATE5_0_1_, startstate3_.ID_ as ID1_1_2_, startstate3_.NAME_ as NAME3_1_2_, startstate3_.PROCESSDEFINITION_ as PROCESSD4_1_2_, startstate3_.ACTION_ as ACTION5_1_2_, startstate3_.SUPERSTATE_ as SUPERSTATE6_1_2_, processdef4_.ID_ as ID1_0_3_, processdef4_.NAME_ as NAME2_0_3_, processdef4_.VERSION_ as VERSION3_0_3_, processdef4_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_3_, processdef4_.STARTSTATE_ as STARTSTATE5_0_3_, action5_.ID_ as ID1_4_4_, action5_.NAME_ as NAME3_4_4_, action5_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_4_, action5_.REFERENCEDACTION_ as REFERENC5_4_4_, action5_.ACTIONDELEGATION_ as ACTIONDE6_4_4_, action5_.EVENT_ as EVENT7_4_4_, action5_.PROCESSDEFINITION_ as PROCESSD8_4_4_, action5_.EXPRESSION_ as EXPRESSION9_4_4_, action5_.TIMERNAME_ as TIMERNAME10_4_4_, action5_.DUEDATE_ as DUEDATE11_4_4_, action5_.REPEAT_ as REPEAT12_4_4_, action5_.TRANSITIONNAME_ as TRANSIT13_4_4_, action5_.TIMERACTION_ as TIMERAC14_4_4_, action5_.class as class4_4_, action6_.ID_ as ID1_4_5_, action6_.NAME_ as NAME3_4_5_, action6_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_5_, action6_.REFERENCEDACTION_ as REFERENC5_4_5_, action6_.ACTIONDELEGATION_ as ACTIONDE6_4_5_, action6_.EVENT_ as EVENT7_4_5_, action6_.PROCESSDEFINITION_ as PROCESSD8_4_5_, action6_.EXPRESSION_ as EXPRESSION9_4_5_, action6_.TIMERNAME_ as TIMERNAME10_4_5_, action6_.DUEDATE_ as DUEDATE11_4_5_, action6_.REPEAT_ as REPEAT12_4_5_, action6_.TRANSITIONNAME_ as TRANSIT13_4_5_, action6_.TIMERACTION_ as TIMERAC14_4_5_, action6_.class as class4_5_, delegation7_.ID_ as ID1_6_6_, delegation7_.CLASSNAME_ as CLASSNAME2_6_6_, delegation7_.CONFIGURATION_ as CONFIGUR3_6_6_, delegation7_.CONFIGTYPE_ as CONFIGTYPE4_6_6_, delegation7_.PROCESSDEFINITION_ as PROCESSD5_6_6_, processdef8_.ID_ as ID1_0_7_, processdef8_.NAME_ as NAME2_0_7_, processdef8_.VERSION_ as VERSION3_0_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_7_, processdef8_.STARTSTATE_ as STARTSTATE5_0_7_, event9_.ID_ as ID1_3_8_, event9_.EVENTTYPE_ as EVENTTYPE2_3_8_, event9_.TYPE_ as TYPE3_3_8_, event9_.GRAPHELEMENT_ as GRAPHELE4_3_8_, processdef10_.ID_ as ID1_0_9_, processdef10_.NAME_ as NAME2_0_9_, processdef10_.VERSION_ as VERSION3_0_9_, processdef10_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_9_, processdef10_.STARTSTATE_ as STARTSTATE5_0_9_, action11_.ID_ as ID1_4_10_, action11_.NAME_ as NAME3_4_10_, action11_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_10_, action11_.REFERENCEDACTION_ as REFERENC5_4_10_, action11_.ACTIONDELEGATION_ as ACTIONDE6_4_10_, action11_.EVENT_ as EVENT7_4_10_, action11_.PROCESSDEFINITION_ as PROCESSD8_4_10_, action11_.EXPRESSION_ as EXPRESSION9_4_10_, action11_.TIMERNAME_ as TIMERNAME10_4_10_, action11_.DUEDATE_ as DUEDATE11_4_10_, action11_.REPEAT_ as REPEAT12_4_10_, action11_.TRANSITIONNAME_ as TRANSIT13_4_10_, action11_.TIMERACTION_ as TIMERAC14_4_10_, action11_.class as class4_10_, superstate12_.ID_ as ID1_1_11_, superstate12_.NAME_ as NAME3_1_11_, superstate12_.PROCESSDEFINITION_ as PROCESSD4_1_11_, superstate12_.ACTION_ as ACTION5_1_11_, superstate12_.SUPERSTATE_ as SUPERSTATE6_1_11_, taskmgmtde13_.ID_ as ID1_12_12_, taskmgmtde13_.NAME_ as NAME3_12_12_, taskmgmtde13_.PROCESSDEFINITION_ as PROCESSD4_12_12_, taskmgmtde13_.STARTTASK_ as STARTTASK5_12_12_, tasknode14_.ID_ as ID1_1_13_, tasknode14_.NAME_ as NAME3_1_13_, tasknode14_.PROCESSDEFINITION_ as PROCESSD4_1_13_, tasknode14_.ACTION_ as ACTION5_1_13_, tasknode14_.SUPERSTATE_ as SUPERSTATE6_1_13_, tasknode14_.SIGNAL_ as SIGNAL9_1_13_, tasknode14_.CREATETASKS_ as CREATET10_1_13_, startstate15_.ID_ as ID1_1_14_, startstate15_.NAME_ as NAME3_1_14_, startstate15_.PROCESSDEFINITION_ as PROCESSD4_1_14_, startstate15_.ACTION_ as ACTION5_1_14_, startstate15_.SUPERSTATE_ as SUPERSTATE6_1_14_, delegation16_.ID_ as ID1_6_15_, delegation16_.CLASSNAME_ as CLASSNAME2_6_15_, delegation16_.CONFIGURATION_ as CONFIGUR3_6_15_, delegation16_.CONFIGTYPE_ as CONFIGTYPE4_6_15_, delegation16_.PROCESSDEFINITION_ as PROCESSD5_6_15_, swimlane17_.ID_ as ID1_9_16_, swimlane17_.NAME_ as NAME2_9_16_, swimlane17_.ASSIGNMENTDELEGATION_ as ASSIGNME3_9_16_, swimlane17_.TASKMGMTDEFINITION_ as TASKMGMT4_9_16_, delegation18_.ID_ as ID1_6_17_, delegation18_.CLASSNAME_ as CLASSNAME2_6_17_, delegation18_.CONFIGURATION_ as CONFIGUR3_6_17_, delegation18_.CONFIGTYPE_ as CONFIGTYPE4_6_17_, delegation18_.PROCESSDEFINITION_ as PROCESSD5_6_17_, taskmgmtde19_.ID_ as ID1_12_18_, taskmgmtde19_.NAME_ as NAME3_12_18_, taskmgmtde19_.PROCESSDEFINITION_ as PROCESSD4_12_18_, taskmgmtde19_.STARTTASK_ as STARTTASK5_12_18_, taskcontro20_.ID_ as ID1_11_19_, taskcontro20_.TASKCONTROLLERDELEGATION_ as TASKCONT2_11_19_, delegation21_.ID_ as ID1_6_20_, delegation21_.CLASSNAME_ as CLASSNAME2_6_20_, delegation21_.CONFIGURATION_ as CONFIGUR3_6_20_, delegation21_.CONFIGTYPE_ as CONFIGTYPE4_6_20_, delegation21_.PROCESSDEFINITION_ as PROCESSD5_6_20_ from POPULIS.JBPM_MODULEDEFINITION definition0_ left outer join POPULIS.JBPM_TASK task1_ on definition0_.STARTTASK_=task1_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef2_ on task1_.PROCESSDEFINITION_=processdef2_.ID_ left outer join POPULIS.JBPM_NODE startstate3_ on processdef2_.STARTSTATE_=startstate3_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef4_ on startstate3_.PROCESSDEFINITION_=processdef4_.ID_ left outer join POPULIS.JBPM_ACTION action5_ on startstate3_.ACTION_=action5_.ID_ left outer join POPULIS.JBPM_ACTION action6_ on action5_.REFERENCEDACTION_=action6_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation7_ on action6_.ACTIONDELEGATION_=delegation7_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef8_ on delegation7_.PROCESSDEFINITION_=processdef8_.ID_ left outer join POPULIS.JBPM_EVENT event9_ on action6_.EVENT_=event9_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef10_ on action6_.PROCESSDEFINITION_=processdef10_.ID_ left outer join POPULIS.JBPM_ACTION action11_ on action6_.TIMERACTION_=action11_.ID_ left outer join POPULIS.JBPM_NODE superstate12_ on startstate3_.SUPERSTATE_=superstate12_.ID_ left outer join POPULIS.JBPM_MODULEDEFINITION taskmgmtde13_ on task1_.TASKMGMTDEFINITION_=taskmgmtde13_.ID_ left outer join POPULIS.JBPM_NODE tasknode14_ on task1_.TASKNODE_=tasknode14_.ID_ left outer join POPULIS.JBPM_NODE startstate15_ on task1_.STARTSTATE_=startstate15_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation16_ on task1_.ASSIGNMENTDELEGATION_=delegation16_.ID_ left outer join POPULIS.JBPM_SWIMLANE swimlane17_ on task1_.SWIMLANE_=swimlane17_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation18_ on swimlane17_.ASSIGNMENTDELEGATION_=delegation18_.ID_ left outer join POPULIS.JBPM_MODULEDEFINITION taskmgmtde19_ on swimlane17_.TASKMGMTDEFINITION_=taskmgmtde19_.ID_ left outer join POPULIS.JBPM_TASKCONTROLLER taskcontro20_ on task1_.TASKCONTROLLER_=taskcontro20_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation21_ on taskcontro20_.TASKCONTROLLERDELEGATION_=delegation21_.ID_ where definition0_.PROCESSDEFINITION_=? binding '150' to parameter: 1 insert into POPULIS.JBPM_TOKEN (NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, NODE_, PROCESSINSTANCE_, PARENT_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) binding null to parameter: 1 binding '2005-12-15 12:12:00' to parameter: 2 binding null to parameter: 3 binding null to parameter: 4 binding '1' to parameter: 5 binding 'true' to parameter: 6 binding 'false' to parameter: 7 binding '791' to parameter: 8 binding null to parameter: 9 binding null to parameter: 10 select @@identity insert into POPULIS.JBPM_PROCESSINSTANCE (START_, END_, PROCESSDEFINITION_, ROOTTOKEN_, SUPERPROCESSTOKEN_) values (?, ?, ?, ?, ?) binding '2005-12-15 12:12:00' to parameter: 1 binding null to parameter: 2 binding '150' to parameter: 3 binding '3703' to parameter: 4 binding null to parameter: 5 select @@identity insert into POPULIS.JBPM_MODULEINSTANCE (PROCESSINSTANCE_, TASKMGMTDEFINITION_, CLASS_) values (?, ?, 'T') binding '3703' to parameter: 1 binding '336' to parameter: 2 select @@identity insert into POPULIS.JBPM_MODULEINSTANCE (PROCESSINSTANCE_, CLASS_) values (?, 'C') binding '3703' to parameter: 1 select @@identity select events0_.PROCESSDEFINITION_ as PROCESSD5_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_3_0_, events0_.EVENTTYPE_ as EVENTTYPE2_3_0_, events0_.TYPE_ as TYPE3_3_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_3_0_ from POPULIS.JBPM_EVENT events0_ where events0_.PROCESSDEFINITION_=? binding '150' to parameter: 1 select leavingtra0_.FROM_ as FROM4_15_, leavingtra0_.ID_ as ID1_15_, leavingtra0_.FROMINDEX_ as FROMINDEX6_15_, leavingtra0_.ID_ as ID1_2_14_, leavingtra0_.NAME_ as NAME2_2_14_, leavingtra0_.PROCESSDEFINITION_ as PROCESSD3_2_14_, leavingtra0_.FROM_ as FROM4_2_14_, leavingtra0_.TO_ as TO5_2_14_, processdef1_.ID_ as ID1_0_0_, processdef1_.NAME_ as NAME2_0_0_, processdef1_.VERSION_ as VERSION3_0_0_, processdef1_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_0_, processdef1_.STARTSTATE_ as STARTSTATE5_0_0_, startstate2_.ID_ as ID1_1_1_, startstate2_.NAME_ as NAME3_1_1_, startstate2_.PROCESSDEFINITION_ as PROCESSD4_1_1_, startstate2_.ACTION_ as ACTION5_1_1_, startstate2_.SUPERSTATE_ as SUPERSTATE6_1_1_, processdef3_.ID_ as ID1_0_2_, processdef3_.NAME_ as NAME2_0_2_, processdef3_.VERSION_ as VERSION3_0_2_, processdef3_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_2_, processdef3_.STARTSTATE_ as STARTSTATE5_0_2_, action4_.ID_ as ID1_4_3_, action4_.NAME_ as NAME3_4_3_, action4_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_3_, action4_.REFERENCEDACTION_ as REFERENC5_4_3_, action4_.ACTIONDELEGATION_ as ACTIONDE6_4_3_, action4_.EVENT_ as EVENT7_4_3_, action4_.PROCESSDEFINITION_ as PROCESSD8_4_3_, action4_.EXPRESSION_ as EXPRESSION9_4_3_, action4_.TIMERNAME_ as TIMERNAME10_4_3_, action4_.DUEDATE_ as DUEDATE11_4_3_, action4_.REPEAT_ as REPEAT12_4_3_, action4_.TRANSITIONNAME_ as TRANSIT13_4_3_, action4_.TIMERACTION_ as TIMERAC14_4_3_, action4_.class as class4_3_, action5_.ID_ as ID1_4_4_, action5_.NAME_ as NAME3_4_4_, action5_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_4_, action5_.REFERENCEDACTION_ as REFERENC5_4_4_, action5_.ACTIONDELEGATION_ as ACTIONDE6_4_4_, action5_.EVENT_ as EVENT7_4_4_, action5_.PROCESSDEFINITION_ as PROCESSD8_4_4_, action5_.EXPRESSION_ as EXPRESSION9_4_4_, action5_.TIMERNAME_ as TIMERNAME10_4_4_, action5_.DUEDATE_ as DUEDATE11_4_4_, action5_.REPEAT_ as REPEAT12_4_4_, action5_.TRANSITIONNAME_ as TRANSIT13_4_4_, action5_.TIMERACTION_ as TIMERAC14_4_4_, action5_.class as class4_4_, delegation6_.ID_ as ID1_6_5_, delegation6_.CLASSNAME_ as CLASSNAME2_6_5_, delegation6_.CONFIGURATION_ as CONFIGUR3_6_5_, delegation6_.CONFIGTYPE_ as CONFIGTYPE4_6_5_, delegation6_.PROCESSDEFINITION_ as PROCESSD5_6_5_, processdef7_.ID_ as ID1_0_6_, processdef7_.NAME_ as NAME2_0_6_, processdef7_.VERSION_ as VERSION3_0_6_, processdef7_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_6_, processdef7_.STARTSTATE_ as STARTSTATE5_0_6_, event8_.ID_ as ID1_3_7_, event8_.EVENTTYPE_ as EVENTTYPE2_3_7_, event8_.TYPE_ as TYPE3_3_7_, event8_.GRAPHELEMENT_ as GRAPHELE4_3_7_, processdef9_.ID_ as ID1_0_8_, processdef9_.NAME_ as NAME2_0_8_, processdef9_.VERSION_ as VERSION3_0_8_, processdef9_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_8_, processdef9_.STARTSTATE_ as STARTSTATE5_0_8_, action10_.ID_ as ID1_4_9_, action10_.NAME_ as NAME3_4_9_, action10_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_9_, action10_.REFERENCEDACTION_ as REFERENC5_4_9_, action10_.ACTIONDELEGATION_ as ACTIONDE6_4_9_, action10_.EVENT_ as EVENT7_4_9_, action10_.PROCESSDEFINITION_ as PROCESSD8_4_9_, action10_.EXPRESSION_ as EXPRESSION9_4_9_, action10_.TIMERNAME_ as TIMERNAME10_4_9_, action10_.DUEDATE_ as DUEDATE11_4_9_, action10_.REPEAT_ as REPEAT12_4_9_, action10_.TRANSITIONNAME_ as TRANSIT13_4_9_, action10_.TIMERACTION_ as TIMERAC14_4_9_, action10_.class as class4_9_, superstate11_.ID_ as ID1_1_10_, superstate11_.NAME_ as NAME3_1_10_, superstate11_.PROCESSDEFINITION_ as PROCESSD4_1_10_, superstate11_.ACTION_ as ACTION5_1_10_, superstate11_.SUPERSTATE_ as SUPERSTATE6_1_10_, node12_.ID_ as ID1_1_11_, node12_.NAME_ as NAME3_1_11_, node12_.PROCESSDEFINITION_ as PROCESSD4_1_11_, node12_.ACTION_ as ACTION5_1_11_, node12_.SUPERSTATE_ as SUPERSTATE6_1_11_, node12_.SUBPROCESSDEFINITION_ as SUBPROCE7_1_11_, node12_.DECISIONDELEGATION as DECISION8_1_11_, node12_.SIGNAL_ as SIGNAL9_1_11_, node12_.CREATETASKS_ as CREATET10_1_11_, node12_.CLASS_ as CLASS2_1_11_, processdef13_.ID_ as ID1_0_12_, processdef13_.NAME_ as NAME2_0_12_, processdef13_.VERSION_ as VERSION3_0_12_, processdef13_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_12_, processdef13_.STARTSTATE_ as STARTSTATE5_0_12_, delegation14_.ID_ as ID1_6_13_, delegation14_.CLASSNAME_ as CLASSNAME2_6_13_, delegation14_.CONFIGURATION_ as CONFIGUR3_6_13_, delegation14_.CONFIGTYPE_ as CONFIGTYPE4_6_13_, delegation14_.PROCESSDEFINITION_ as PROCESSD5_6_13_ from POPULIS.JBPM_TRANSITION leavingtra0_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef1_ on leavingtra0_.PROCESSDEFINITION_=processdef1_.ID_ left outer join POPULIS.JBPM_NODE startstate2_ on processdef1_.STARTSTATE_=startstate2_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef3_ on startstate2_.PROCESSDEFINITION_=processdef3_.ID_ left outer join POPULIS.JBPM_ACTION action4_ on startstate2_.ACTION_=action4_.ID_ left outer join POPULIS.JBPM_ACTION action5_ on action4_.REFERENCEDACTION_=action5_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation6_ on action5_.ACTIONDELEGATION_=delegation6_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef7_ on delegation6_.PROCESSDEFINITION_=processdef7_.ID_ left outer join POPULIS.JBPM_EVENT event8_ on action5_.EVENT_=event8_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef9_ on action5_.PROCESSDEFINITION_=processdef9_.ID_ left outer join POPULIS.JBPM_ACTION action10_ on action5_.TIMERACTION_=action10_.ID_ left outer join POPULIS.JBPM_NODE superstate11_ on startstate2_.SUPERSTATE_=superstate11_.ID_ left outer join POPULIS.JBPM_NODE node12_ on leavingtra0_.TO_=node12_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef13_ on node12_.SUBPROCESSDEFINITION_=processdef13_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation14_ on node12_.DECISIONDELEGATION=delegation14_.ID_ where leavingtra0_.FROM_=? binding '791' to parameter: 1 select timer0_.ID_ as col_0_0_ from POPULIS.JBPM_TIMER timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc select events0_.NODE_ as NODE6_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_3_0_, events0_.EVENTTYPE_ as EVENTTYPE2_3_0_, events0_.TYPE_ as TYPE3_3_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_3_0_ from POPULIS.JBPM_EVENT events0_ where events0_.NODE_=? binding '791' to parameter: 1 select events0_.TRANSITION_ as TRANSITION7_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_3_0_, events0_.EVENTTYPE_ as EVENTTYPE2_3_0_, events0_.TYPE_ as TYPE3_3_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_3_0_ from POPULIS.JBPM_EVENT events0_ where events0_.TRANSITION_=? binding '1025' to parameter: 1 select events0_.NODE_ as NODE6_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_3_0_, events0_.EVENTTYPE_ as EVENTTYPE2_3_0_, events0_.TYPE_ as TYPE3_3_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_3_0_ from POPULIS.JBPM_EVENT events0_ where events0_.NODE_=? binding '792' to parameter: 1 select tasks0_.TASKNODE_ as TASKNODE8_22_, tasks0_.ID_ as ID1_22_, tasks0_.ID_ as ID1_10_21_, tasks0_.NAME_ as NAME2_10_21_, tasks0_.PROCESSDEFINITION_ as PROCESSD3_10_21_, tasks0_.DESCRIPTION_ as DESCRIPT4_10_21_, tasks0_.ISBLOCKING_ as ISBLOCKING5_10_21_, tasks0_.DUEDATE_ as DUEDATE6_10_21_, tasks0_.TASKMGMTDEFINITION_ as TASKMGMT7_10_21_, tasks0_.TASKNODE_ as TASKNODE8_10_21_, tasks0_.STARTSTATE_ as STARTSTATE9_10_21_, tasks0_.ASSIGNMENTDELEGATION_ as ASSIGNM10_10_21_, tasks0_.SWIMLANE_ as SWIMLANE11_10_21_, tasks0_.TASKCONTROLLER_ as TASKCON12_10_21_, processdef1_.ID_ as ID1_0_0_, processdef1_.NAME_ as NAME2_0_0_, processdef1_.VERSION_ as VERSION3_0_0_, processdef1_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_0_, processdef1_.STARTSTATE_ as STARTSTATE5_0_0_, startstate2_.ID_ as ID1_1_1_, startstate2_.NAME_ as NAME3_1_1_, startstate2_.PROCESSDEFINITION_ as PROCESSD4_1_1_, startstate2_.ACTION_ as ACTION5_1_1_, startstate2_.SUPERSTATE_ as SUPERSTATE6_1_1_, processdef3_.ID_ as ID1_0_2_, processdef3_.NAME_ as NAME2_0_2_, processdef3_.VERSION_ as VERSION3_0_2_, processdef3_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_2_, processdef3_.STARTSTATE_ as STARTSTATE5_0_2_, action4_.ID_ as ID1_4_3_, action4_.NAME_ as NAME3_4_3_, action4_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_3_, action4_.REFERENCEDACTION_ as REFERENC5_4_3_, action4_.ACTIONDELEGATION_ as ACTIONDE6_4_3_, action4_.EVENT_ as EVENT7_4_3_, action4_.PROCESSDEFINITION_ as PROCESSD8_4_3_, action4_.EXPRESSION_ as EXPRESSION9_4_3_, action4_.TIMERNAME_ as TIMERNAME10_4_3_, action4_.DUEDATE_ as DUEDATE11_4_3_, action4_.REPEAT_ as REPEAT12_4_3_, action4_.TRANSITIONNAME_ as TRANSIT13_4_3_, action4_.TIMERACTION_ as TIMERAC14_4_3_, action4_.class as class4_3_, action5_.ID_ as ID1_4_4_, action5_.NAME_ as NAME3_4_4_, action5_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_4_, action5_.REFERENCEDACTION_ as REFERENC5_4_4_, action5_.ACTIONDELEGATION_ as ACTIONDE6_4_4_, action5_.EVENT_ as EVENT7_4_4_, action5_.PROCESSDEFINITION_ as PROCESSD8_4_4_, action5_.EXPRESSION_ as EXPRESSION9_4_4_, action5_.TIMERNAME_ as TIMERNAME10_4_4_, action5_.DUEDATE_ as DUEDATE11_4_4_, action5_.REPEAT_ as REPEAT12_4_4_, action5_.TRANSITIONNAME_ as TRANSIT13_4_4_, action5_.TIMERACTION_ as TIMERAC14_4_4_, action5_.class as class4_4_, delegation6_.ID_ as ID1_6_5_, delegation6_.CLASSNAME_ as CLASSNAME2_6_5_, delegation6_.CONFIGURATION_ as CONFIGUR3_6_5_, delegation6_.CONFIGTYPE_ as CONFIGTYPE4_6_5_, delegation6_.PROCESSDEFINITION_ as PROCESSD5_6_5_, processdef7_.ID_ as ID1_0_6_, processdef7_.NAME_ as NAME2_0_6_, processdef7_.VERSION_ as VERSION3_0_6_, processdef7_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_6_, processdef7_.STARTSTATE_ as STARTSTATE5_0_6_, event8_.ID_ as ID1_3_7_, event8_.EVENTTYPE_ as EVENTTYPE2_3_7_, event8_.TYPE_ as TYPE3_3_7_, event8_.GRAPHELEMENT_ as GRAPHELE4_3_7_, processdef9_.ID_ as ID1_0_8_, processdef9_.NAME_ as NAME2_0_8_, processdef9_.VERSION_ as VERSION3_0_8_, processdef9_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_8_, processdef9_.STARTSTATE_ as STARTSTATE5_0_8_, action10_.ID_ as ID1_4_9_, action10_.NAME_ as NAME3_4_9_, action10_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_9_, action10_.REFERENCEDACTION_ as REFERENC5_4_9_, action10_.ACTIONDELEGATION_ as ACTIONDE6_4_9_, action10_.EVENT_ as EVENT7_4_9_, action10_.PROCESSDEFINITION_ as PROCESSD8_4_9_, action10_.EXPRESSION_ as EXPRESSION9_4_9_, action10_.TIMERNAME_ as TIMERNAME10_4_9_, action10_.DUEDATE_ as DUEDATE11_4_9_, action10_.REPEAT_ as REPEAT12_4_9_, action10_.TRANSITIONNAME_ as TRANSIT13_4_9_, action10_.TIMERACTION_ as TIMERAC14_4_9_, action10_.class as class4_9_, superstate11_.ID_ as ID1_1_10_, superstate11_.NAME_ as NAME3_1_10_, superstate11_.PROCESSDEFINITION_ as PROCESSD4_1_10_, superstate11_.ACTION_ as ACTION5_1_10_, superstate11_.SUPERSTATE_ as SUPERSTATE6_1_10_, taskmgmtde12_.ID_ as ID1_12_11_, taskmgmtde12_.NAME_ as NAME3_12_11_, taskmgmtde12_.PROCESSDEFINITION_ as PROCESSD4_12_11_, taskmgmtde12_.STARTTASK_ as STARTTASK5_12_11_, processdef13_.ID_ as ID1_0_12_, processdef13_.NAME_ as NAME2_0_12_, processdef13_.VERSION_ as VERSION3_0_12_, processdef13_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_12_, processdef13_.STARTSTATE_ as STARTSTATE5_0_12_, task14_.ID_ as ID1_10_13_, task14_.NAME_ as NAME2_10_13_, task14_.PROCESSDEFINITION_ as PROCESSD3_10_13_, task14_.DESCRIPTION_ as DESCRIPT4_10_13_, task14_.ISBLOCKING_ as ISBLOCKING5_10_13_, task14_.DUEDATE_ as DUEDATE6_10_13_, task14_.TASKMGMTDEFINITION_ as TASKMGMT7_10_13_, task14_.TASKNODE_ as TASKNODE8_10_13_, task14_.STARTSTATE_ as STARTSTATE9_10_13_, task14_.ASSIGNMENTDELEGATION_ as ASSIGNM10_10_13_, task14_.SWIMLANE_ as SWIMLANE11_10_13_, task14_.TASKCONTROLLER_ as TASKCON12_10_13_, startstate15_.ID_ as ID1_1_14_, startstate15_.NAME_ as NAME3_1_14_, startstate15_.PROCESSDEFINITION_ as PROCESSD4_1_14_, startstate15_.ACTION_ as ACTION5_1_14_, startstate15_.SUPERSTATE_ as SUPERSTATE6_1_14_, delegation16_.ID_ as ID1_6_15_, delegation16_.CLASSNAME_ as CLASSNAME2_6_15_, delegation16_.CONFIGURATION_ as CONFIGUR3_6_15_, delegation16_.CONFIGTYPE_ as CONFIGTYPE4_6_15_, delegation16_.PROCESSDEFINITION_ as PROCESSD5_6_15_, swimlane17_.ID_ as ID1_9_16_, swimlane17_.NAME_ as NAME2_9_16_, swimlane17_.ASSIGNMENTDELEGATION_ as ASSIGNME3_9_16_, swimlane17_.TASKMGMTDEFINITION_ as TASKMGMT4_9_16_, delegation18_.ID_ as ID1_6_17_, delegation18_.CLASSNAME_ as CLASSNAME2_6_17_, delegation18_.CONFIGURATION_ as CONFIGUR3_6_17_, delegation18_.CONFIGTYPE_ as CONFIGTYPE4_6_17_, delegation18_.PROCESSDEFINITION_ as PROCESSD5_6_17_, taskmgmtde19_.ID_ as ID1_12_18_, taskmgmtde19_.NAME_ as NAME3_12_18_, taskmgmtde19_.PROCESSDEFINITION_ as PROCESSD4_12_18_, taskmgmtde19_.STARTTASK_ as STARTTASK5_12_18_, taskcontro20_.ID_ as ID1_11_19_, taskcontro20_.TASKCONTROLLERDELEGATION_ as TASKCONT2_11_19_, delegation21_.ID_ as ID1_6_20_, delegation21_.CLASSNAME_ as CLASSNAME2_6_20_, delegation21_.CONFIGURATION_ as CONFIGUR3_6_20_, delegation21_.CONFIGTYPE_ as CONFIGTYPE4_6_20_, delegation21_.PROCESSDEFINITION_ as PROCESSD5_6_20_ from POPULIS.JBPM_TASK tasks0_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef1_ on tasks0_.PROCESSDEFINITION_=processdef1_.ID_ left outer join POPULIS.JBPM_NODE startstate2_ on processdef1_.STARTSTATE_=startstate2_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef3_ on startstate2_.PROCESSDEFINITION_=processdef3_.ID_ left outer join POPULIS.JBPM_ACTION action4_ on startstate2_.ACTION_=action4_.ID_ left outer join POPULIS.JBPM_ACTION action5_ on action4_.REFERENCEDACTION_=action5_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation6_ on action5_.ACTIONDELEGATION_=delegation6_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef7_ on delegation6_.PROCESSDEFINITION_=processdef7_.ID_ left outer join POPULIS.JBPM_EVENT event8_ on action5_.EVENT_=event8_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef9_ on action5_.PROCESSDEFINITION_=processdef9_.ID_ left outer join POPULIS.JBPM_ACTION action10_ on action5_.TIMERACTION_=action10_.ID_ left outer join POPULIS.JBPM_NODE superstate11_ on startstate2_.SUPERSTATE_=superstate11_.ID_ left outer join POPULIS.JBPM_MODULEDEFINITION taskmgmtde12_ on tasks0_.TASKMGMTDEFINITION_=taskmgmtde12_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef13_ on taskmgmtde12_.PROCESSDEFINITION_=processdef13_.ID_ left outer join POPULIS.JBPM_TASK task14_ on taskmgmtde12_.STARTTASK_=task14_.ID_ left outer join POPULIS.JBPM_NODE startstate15_ on task14_.STARTSTATE_=startstate15_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation16_ on task14_.ASSIGNMENTDELEGATION_=delegation16_.ID_ left outer join POPULIS.JBPM_SWIMLANE swimlane17_ on task14_.SWIMLANE_=swimlane17_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation18_ on swimlane17_.ASSIGNMENTDELEGATION_=delegation18_.ID_ left outer join POPULIS.JBPM_MODULEDEFINITION taskmgmtde19_ on swimlane17_.TASKMGMTDEFINITION_=taskmgmtde19_.ID_ left outer join POPULIS.JBPM_TASKCONTROLLER taskcontro20_ on task14_.TASKCONTROLLER_=taskcontro20_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation21_ on taskcontro20_.TASKCONTROLLERDELEGATION_=delegation21_.ID_ where tasks0_.TASKNODE_=? binding '792' to parameter: 1 select swimlane0_.ID_ as ID1_9_22_, swimlane0_.NAME_ as NAME2_9_22_, swimlane0_.ASSIGNMENTDELEGATION_ as ASSIGNME3_9_22_, swimlane0_.TASKMGMTDEFINITION_ as TASKMGMT4_9_22_, delegation1_.ID_ as ID1_6_0_, delegation1_.CLASSNAME_ as CLASSNAME2_6_0_, delegation1_.CONFIGURATION_ as CONFIGUR3_6_0_, delegation1_.CONFIGTYPE_ as CONFIGTYPE4_6_0_, delegation1_.PROCESSDEFINITION_ as PROCESSD5_6_0_, processdef2_.ID_ as ID1_0_1_, processdef2_.NAME_ as NAME2_0_1_, processdef2_.VERSION_ as VERSION3_0_1_, processdef2_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_1_, processdef2_.STARTSTATE_ as STARTSTATE5_0_1_, startstate3_.ID_ as ID1_1_2_, startstate3_.NAME_ as NAME3_1_2_, startstate3_.PROCESSDEFINITION_ as PROCESSD4_1_2_, startstate3_.ACTION_ as ACTION5_1_2_, startstate3_.SUPERSTATE_ as SUPERSTATE6_1_2_, processdef4_.ID_ as ID1_0_3_, processdef4_.NAME_ as NAME2_0_3_, processdef4_.VERSION_ as VERSION3_0_3_, processdef4_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_3_, processdef4_.STARTSTATE_ as STARTSTATE5_0_3_, action5_.ID_ as ID1_4_4_, action5_.NAME_ as NAME3_4_4_, action5_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_4_, action5_.REFERENCEDACTION_ as REFERENC5_4_4_, action5_.ACTIONDELEGATION_ as ACTIONDE6_4_4_, action5_.EVENT_ as EVENT7_4_4_, action5_.PROCESSDEFINITION_ as PROCESSD8_4_4_, action5_.EXPRESSION_ as EXPRESSION9_4_4_, action5_.TIMERNAME_ as TIMERNAME10_4_4_, action5_.DUEDATE_ as DUEDATE11_4_4_, action5_.REPEAT_ as REPEAT12_4_4_, action5_.TRANSITIONNAME_ as TRANSIT13_4_4_, action5_.TIMERACTION_ as TIMERAC14_4_4_, action5_.class as class4_4_, action6_.ID_ as ID1_4_5_, action6_.NAME_ as NAME3_4_5_, action6_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_5_, action6_.REFERENCEDACTION_ as REFERENC5_4_5_, action6_.ACTIONDELEGATION_ as ACTIONDE6_4_5_, action6_.EVENT_ as EVENT7_4_5_, action6_.PROCESSDEFINITION_ as PROCESSD8_4_5_, action6_.EXPRESSION_ as EXPRESSION9_4_5_, action6_.TIMERNAME_ as TIMERNAME10_4_5_, action6_.DUEDATE_ as DUEDATE11_4_5_, action6_.REPEAT_ as REPEAT12_4_5_, action6_.TRANSITIONNAME_ as TRANSIT13_4_5_, action6_.TIMERACTION_ as TIMERAC14_4_5_, action6_.class as class4_5_, delegation7_.ID_ as ID1_6_6_, delegation7_.CLASSNAME_ as CLASSNAME2_6_6_, delegation7_.CONFIGURATION_ as CONFIGUR3_6_6_, delegation7_.CONFIGTYPE_ as CONFIGTYPE4_6_6_, delegation7_.PROCESSDEFINITION_ as PROCESSD5_6_6_, event8_.ID_ as ID1_3_7_, event8_.EVENTTYPE_ as EVENTTYPE2_3_7_, event8_.TYPE_ as TYPE3_3_7_, event8_.GRAPHELEMENT_ as GRAPHELE4_3_7_, processdef9_.ID_ as ID1_0_8_, processdef9_.NAME_ as NAME2_0_8_, processdef9_.VERSION_ as VERSION3_0_8_, processdef9_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_8_, processdef9_.STARTSTATE_ as STARTSTATE5_0_8_, action10_.ID_ as ID1_4_9_, action10_.NAME_ as NAME3_4_9_, action10_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_9_, action10_.REFERENCEDACTION_ as REFERENC5_4_9_, action10_.ACTIONDELEGATION_ as ACTIONDE6_4_9_, action10_.EVENT_ as EVENT7_4_9_, action10_.PROCESSDEFINITION_ as PROCESSD8_4_9_, action10_.EXPRESSION_ as EXPRESSION9_4_9_, action10_.TIMERNAME_ as TIMERNAME10_4_9_, action10_.DUEDATE_ as DUEDATE11_4_9_, action10_.REPEAT_ as REPEAT12_4_9_, action10_.TRANSITIONNAME_ as TRANSIT13_4_9_, action10_.TIMERACTION_ as TIMERAC14_4_9_, action10_.class as class4_9_, superstate11_.ID_ as ID1_1_10_, superstate11_.NAME_ as NAME3_1_10_, superstate11_.PROCESSDEFINITION_ as PROCESSD4_1_10_, superstate11_.ACTION_ as ACTION5_1_10_, superstate11_.SUPERSTATE_ as SUPERSTATE6_1_10_, taskmgmtde12_.ID_ as ID1_12_11_, taskmgmtde12_.NAME_ as NAME3_12_11_, taskmgmtde12_.PROCESSDEFINITION_ as PROCESSD4_12_11_, taskmgmtde12_.STARTTASK_ as STARTTASK5_12_11_, processdef13_.ID_ as ID1_0_12_, processdef13_.NAME_ as NAME2_0_12_, processdef13_.VERSION_ as VERSION3_0_12_, processdef13_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_12_, processdef13_.STARTSTATE_ as STARTSTATE5_0_12_, task14_.ID_ as ID1_10_13_, task14_.NAME_ as NAME2_10_13_, task14_.PROCESSDEFINITION_ as PROCESSD3_10_13_, task14_.DESCRIPTION_ as DESCRIPT4_10_13_, task14_.ISBLOCKING_ as ISBLOCKING5_10_13_, task14_.DUEDATE_ as DUEDATE6_10_13_, task14_.TASKMGMTDEFINITION_ as TASKMGMT7_10_13_, task14_.TASKNODE_ as TASKNODE8_10_13_, task14_.STARTSTATE_ as STARTSTATE9_10_13_, task14_.ASSIGNMENTDELEGATION_ as ASSIGNM10_10_13_, task14_.SWIMLANE_ as SWIMLANE11_10_13_, task14_.TASKCONTROLLER_ as TASKCON12_10_13_, processdef15_.ID_ as ID1_0_14_, processdef15_.NAME_ as NAME2_0_14_, processdef15_.VERSION_ as VERSION3_0_14_, processdef15_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_14_, processdef15_.STARTSTATE_ as STARTSTATE5_0_14_, taskmgmtde16_.ID_ as ID1_12_15_, taskmgmtde16_.NAME_ as NAME3_12_15_, taskmgmtde16_.PROCESSDEFINITION_ as PROCESSD4_12_15_, taskmgmtde16_.STARTTASK_ as STARTTASK5_12_15_, tasknode17_.ID_ as ID1_1_16_, tasknode17_.NAME_ as NAME3_1_16_, tasknode17_.PROCESSDEFINITION_ as PROCESSD4_1_16_, tasknode17_.ACTION_ as ACTION5_1_16_, tasknode17_.SUPERSTATE_ as SUPERSTATE6_1_16_, tasknode17_.SIGNAL_ as SIGNAL9_1_16_, tasknode17_.CREATETASKS_ as CREATET10_1_16_, startstate18_.ID_ as ID1_1_17_, startstate18_.NAME_ as NAME3_1_17_, startstate18_.PROCESSDEFINITION_ as PROCESSD4_1_17_, startstate18_.ACTION_ as ACTION5_1_17_, startstate18_.SUPERSTATE_ as SUPERSTATE6_1_17_, delegation19_.ID_ as ID1_6_18_, delegation19_.CLASSNAME_ as CLASSNAME2_6_18_, delegation19_.CONFIGURATION_ as CONFIGUR3_6_18_, delegation19_.CONFIGTYPE_ as CONFIGTYPE4_6_18_, delegation19_.PROCESSDEFINITION_ as PROCESSD5_6_18_, swimlane20_.ID_ as ID1_9_19_, swimlane20_.NAME_ as NAME2_9_19_, swimlane20_.ASSIGNMENTDELEGATION_ as ASSIGNME3_9_19_, swimlane20_.TASKMGMTDEFINITION_ as TASKMGMT4_9_19_, taskcontro21_.ID_ as ID1_11_20_, taskcontro21_.TASKCONTROLLERDELEGATION_ as TASKCONT2_11_20_, delegation22_.ID_ as ID1_6_21_, delegation22_.CLASSNAME_ as CLASSNAME2_6_21_, delegation22_.CONFIGURATION_ as CONFIGUR3_6_21_, delegation22_.CONFIGTYPE_ as CONFIGTYPE4_6_21_, delegation22_.PROCESSDEFINITION_ as PROCESSD5_6_21_ from POPULIS.JBPM_SWIMLANE swimlane0_ left outer join POPULIS.JBPM_DELEGATION delegation1_ on swimlane0_.ASSIGNMENTDELEGATION_=delegation1_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef2_ on delegation1_.PROCESSDEFINITION_=processdef2_.ID_ left outer join POPULIS.JBPM_NODE startstate3_ on processdef2_.STARTSTATE_=startstate3_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef4_ on startstate3_.PROCESSDEFINITION_=processdef4_.ID_ left outer join POPULIS.JBPM_ACTION action5_ on startstate3_.ACTION_=action5_.ID_ left outer join POPULIS.JBPM_ACTION action6_ on action5_.REFERENCEDACTION_=action6_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation7_ on action6_.ACTIONDELEGATION_=delegation7_.ID_ left outer join POPULIS.JBPM_EVENT event8_ on action6_.EVENT_=event8_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef9_ on action6_.PROCESSDEFINITION_=processdef9_.ID_ left outer join POPULIS.JBPM_ACTION action10_ on action6_.TIMERACTION_=action10_.ID_ left outer join POPULIS.JBPM_NODE superstate11_ on startstate3_.SUPERSTATE_=superstate11_.ID_ left outer join POPULIS.JBPM_MODULEDEFINITION taskmgmtde12_ on swimlane0_.TASKMGMTDEFINITION_=taskmgmtde12_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef13_ on taskmgmtde12_.PROCESSDEFINITION_=processdef13_.ID_ left outer join POPULIS.JBPM_TASK task14_ on taskmgmtde12_.STARTTASK_=task14_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef15_ on task14_.PROCESSDEFINITION_=processdef15_.ID_ left outer join POPULIS.JBPM_MODULEDEFINITION taskmgmtde16_ on task14_.TASKMGMTDEFINITION_=taskmgmtde16_.ID_ left outer join POPULIS.JBPM_NODE tasknode17_ on task14_.TASKNODE_=tasknode17_.ID_ left outer join POPULIS.JBPM_NODE startstate18_ on task14_.STARTSTATE_=startstate18_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation19_ on task14_.ASSIGNMENTDELEGATION_=delegation19_.ID_ left outer join POPULIS.JBPM_SWIMLANE swimlane20_ on task14_.SWIMLANE_=swimlane20_.ID_ left outer join POPULIS.JBPM_TASKCONTROLLER taskcontro21_ on task14_.TASKCONTROLLER_=taskcontro21_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation22_ on taskcontro21_.TASKCONTROLLERDELEGATION_=delegation22_.ID_ where swimlane0_.ID_=? binding '353' to parameter: 1 insert into POPULIS.JBPM_TASKINSTANCE (NAME_, DESCRIPTION_, ACTORID_, CREATE_, START_, END_, DUEDATE_, PRIORITY_, ISCANCELLED_, ISSIGNALLING_, ISBLOCKING_, TASK_, TOKEN_, SWIMLANINSTANCE_, TASKMGMTINSTANCE_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) binding 'task1' to parameter: 1 binding null to parameter: 2 binding null to parameter: 3 binding null to parameter: 4 binding null to parameter: 5 binding null to parameter: 6 binding null to parameter: 7 binding '3' to parameter: 8 binding 'false' to parameter: 9 binding 'true' to parameter: 10 binding 'false' to parameter: 11 binding '355' to parameter: 12 binding null to parameter: 13 binding null to parameter: 14 binding '7405' to parameter: 15 select @@identity select events0_.TASK_ as TASK8_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_3_0_, events0_.EVENTTYPE_ as EVENTTYPE2_3_0_, events0_.TYPE_ as TYPE3_3_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_3_0_ from POPULIS.JBPM_EVENT events0_ where events0_.TASK_=? binding '355' to parameter: 1 select actions0_.EVENT_ as EVENT7_10_, actions0_.ID_ as ID1_10_, actions0_.EVENTINDEX_ as EVENTINDEX15_10_, actions0_.ID_ as ID1_4_9_, actions0_.NAME_ as NAME3_4_9_, actions0_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_9_, actions0_.REFERENCEDACTION_ as REFERENC5_4_9_, actions0_.ACTIONDELEGATION_ as ACTIONDE6_4_9_, actions0_.EVENT_ as EVENT7_4_9_, actions0_.PROCESSDEFINITION_ as PROCESSD8_4_9_, actions0_.EXPRESSION_ as EXPRESSION9_4_9_, actions0_.TIMERNAME_ as TIMERNAME10_4_9_, actions0_.DUEDATE_ as DUEDATE11_4_9_, actions0_.REPEAT_ as REPEAT12_4_9_, actions0_.TRANSITIONNAME_ as TRANSIT13_4_9_, actions0_.TIMERACTION_ as TIMERAC14_4_9_, actions0_.class as class4_9_, action1_.ID_ as ID1_4_0_, action1_.NAME_ as NAME3_4_0_, action1_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_0_, action1_.REFERENCEDACTION_ as REFERENC5_4_0_, action1_.ACTIONDELEGATION_ as ACTIONDE6_4_0_, action1_.EVENT_ as EVENT7_4_0_, action1_.PROCESSDEFINITION_ as PROCESSD8_4_0_, action1_.EXPRESSION_ as EXPRESSION9_4_0_, action1_.TIMERNAME_ as TIMERNAME10_4_0_, action1_.DUEDATE_ as DUEDATE11_4_0_, action1_.REPEAT_ as REPEAT12_4_0_, action1_.TRANSITIONNAME_ as TRANSIT13_4_0_, action1_.TIMERACTION_ as TIMERAC14_4_0_, action1_.class as class4_0_, delegation2_.ID_ as ID1_6_1_, delegation2_.CLASSNAME_ as CLASSNAME2_6_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_6_1_, delegation2_.CONFIGTYPE_ as CONFIGTYPE4_6_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_6_1_, processdef3_.ID_ as ID1_0_2_, processdef3_.NAME_ as NAME2_0_2_, processdef3_.VERSION_ as VERSION3_0_2_, processdef3_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_2_, processdef3_.STARTSTATE_ as STARTSTATE5_0_2_, startstate4_.ID_ as ID1_1_3_, startstate4_.NAME_ as NAME3_1_3_, startstate4_.PROCESSDEFINITION_ as PROCESSD4_1_3_, startstate4_.ACTION_ as ACTION5_1_3_, startstate4_.SUPERSTATE_ as SUPERSTATE6_1_3_, processdef5_.ID_ as ID1_0_4_, processdef5_.NAME_ as NAME2_0_4_, processdef5_.VERSION_ as VERSION3_0_4_, processdef5_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_4_, processdef5_.STARTSTATE_ as STARTSTATE5_0_4_, action6_.ID_ as ID1_4_5_, action6_.NAME_ as NAME3_4_5_, action6_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_5_, action6_.REFERENCEDACTION_ as REFERENC5_4_5_, action6_.ACTIONDELEGATION_ as ACTIONDE6_4_5_, action6_.EVENT_ as EVENT7_4_5_, action6_.PROCESSDEFINITION_ as PROCESSD8_4_5_, action6_.EXPRESSION_ as EXPRESSION9_4_5_, action6_.TIMERNAME_ as TIMERNAME10_4_5_, action6_.DUEDATE_ as DUEDATE11_4_5_, action6_.REPEAT_ as REPEAT12_4_5_, action6_.TRANSITIONNAME_ as TRANSIT13_4_5_, action6_.TIMERACTION_ as TIMERAC14_4_5_, action6_.class as class4_5_, processdef7_.ID_ as ID1_0_6_, processdef7_.NAME_ as NAME2_0_6_, processdef7_.VERSION_ as VERSION3_0_6_, processdef7_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_6_, processdef7_.STARTSTATE_ as STARTSTATE5_0_6_, action8_.ID_ as ID1_4_7_, action8_.NAME_ as NAME3_4_7_, action8_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_7_, action8_.REFERENCEDACTION_ as REFERENC5_4_7_, action8_.ACTIONDELEGATION_ as ACTIONDE6_4_7_, action8_.EVENT_ as EVENT7_4_7_, action8_.PROCESSDEFINITION_ as PROCESSD8_4_7_, action8_.EXPRESSION_ as EXPRESSION9_4_7_, action8_.TIMERNAME_ as TIMERNAME10_4_7_, action8_.DUEDATE_ as DUEDATE11_4_7_, action8_.REPEAT_ as REPEAT12_4_7_, action8_.TRANSITIONNAME_ as TRANSIT13_4_7_, action8_.TIMERACTION_ as TIMERAC14_4_7_, action8_.class as class4_7_, superstate9_.ID_ as ID1_1_8_, superstate9_.NAME_ as NAME3_1_8_, superstate9_.PROCESSDEFINITION_ as PROCESSD4_1_8_, superstate9_.ACTION_ as ACTION5_1_8_, superstate9_.SUPERSTATE_ as SUPERSTATE6_1_8_ from POPULIS.JBPM_ACTION actions0_ left outer join POPULIS.JBPM_ACTION action1_ on actions0_.REFERENCEDACTION_=action1_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation2_ on action1_.ACTIONDELEGATION_=delegation2_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef3_ on delegation2_.PROCESSDEFINITION_=processdef3_.ID_ left outer join POPULIS.JBPM_NODE startstate4_ on processdef3_.STARTSTATE_=startstate4_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef5_ on startstate4_.PROCESSDEFINITION_=processdef5_.ID_ left outer join POPULIS.JBPM_ACTION action6_ on startstate4_.ACTION_=action6_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef7_ on action6_.PROCESSDEFINITION_=processdef7_.ID_ left outer join POPULIS.JBPM_ACTION action8_ on action6_.TIMERACTION_=action8_.ID_ left outer join POPULIS.JBPM_NODE superstate9_ on startstate4_.SUPERSTATE_=superstate9_.ID_ where actions0_.EVENT_=? binding '263' to parameter: 1 select action0_.ID_ as ID1_4_10_, action0_.NAME_ as NAME3_4_10_, action0_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_10_, action0_.REFERENCEDACTION_ as REFERENC5_4_10_, action0_.ACTIONDELEGATION_ as ACTIONDE6_4_10_, action0_.EVENT_ as EVENT7_4_10_, action0_.PROCESSDEFINITION_ as PROCESSD8_4_10_, action0_.EXPRESSION_ as EXPRESSION9_4_10_, action0_.TIMERNAME_ as TIMERNAME10_4_10_, action0_.DUEDATE_ as DUEDATE11_4_10_, action0_.REPEAT_ as REPEAT12_4_10_, action0_.TRANSITIONNAME_ as TRANSIT13_4_10_, action0_.TIMERACTION_ as TIMERAC14_4_10_, action0_.class as class4_10_, action1_.ID_ as ID1_4_0_, action1_.NAME_ as NAME3_4_0_, action1_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_0_, action1_.REFERENCEDACTION_ as REFERENC5_4_0_, action1_.ACTIONDELEGATION_ as ACTIONDE6_4_0_, action1_.EVENT_ as EVENT7_4_0_, action1_.PROCESSDEFINITION_ as PROCESSD8_4_0_, action1_.EXPRESSION_ as EXPRESSION9_4_0_, action1_.TIMERNAME_ as TIMERNAME10_4_0_, action1_.DUEDATE_ as DUEDATE11_4_0_, action1_.REPEAT_ as REPEAT12_4_0_, action1_.TRANSITIONNAME_ as TRANSIT13_4_0_, action1_.TIMERACTION_ as TIMERAC14_4_0_, action1_.class as class4_0_, delegation2_.ID_ as ID1_6_1_, delegation2_.CLASSNAME_ as CLASSNAME2_6_1_, delegation2_.CONFIGURATION_ as CONFIGUR3_6_1_, delegation2_.CONFIGTYPE_ as CONFIGTYPE4_6_1_, delegation2_.PROCESSDEFINITION_ as PROCESSD5_6_1_, processdef3_.ID_ as ID1_0_2_, processdef3_.NAME_ as NAME2_0_2_, processdef3_.VERSION_ as VERSION3_0_2_, processdef3_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_2_, processdef3_.STARTSTATE_ as STARTSTATE5_0_2_, startstate4_.ID_ as ID1_1_3_, startstate4_.NAME_ as NAME3_1_3_, startstate4_.PROCESSDEFINITION_ as PROCESSD4_1_3_, startstate4_.ACTION_ as ACTION5_1_3_, startstate4_.SUPERSTATE_ as SUPERSTATE6_1_3_, processdef5_.ID_ as ID1_0_4_, processdef5_.NAME_ as NAME2_0_4_, processdef5_.VERSION_ as VERSION3_0_4_, processdef5_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_4_, processdef5_.STARTSTATE_ as STARTSTATE5_0_4_, action6_.ID_ as ID1_4_5_, action6_.NAME_ as NAME3_4_5_, action6_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_5_, action6_.REFERENCEDACTION_ as REFERENC5_4_5_, action6_.ACTIONDELEGATION_ as ACTIONDE6_4_5_, action6_.EVENT_ as EVENT7_4_5_, action6_.PROCESSDEFINITION_ as PROCESSD8_4_5_, action6_.EXPRESSION_ as EXPRESSION9_4_5_, action6_.TIMERNAME_ as TIMERNAME10_4_5_, action6_.DUEDATE_ as DUEDATE11_4_5_, action6_.REPEAT_ as REPEAT12_4_5_, action6_.TRANSITIONNAME_ as TRANSIT13_4_5_, action6_.TIMERACTION_ as TIMERAC14_4_5_, action6_.class as class4_5_, event7_.ID_ as ID1_3_6_, event7_.EVENTTYPE_ as EVENTTYPE2_3_6_, event7_.TYPE_ as TYPE3_3_6_, event7_.GRAPHELEMENT_ as GRAPHELE4_3_6_, processdef8_.ID_ as ID1_0_7_, processdef8_.NAME_ as NAME2_0_7_, processdef8_.VERSION_ as VERSION3_0_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_7_, processdef8_.STARTSTATE_ as STARTSTATE5_0_7_, action9_.ID_ as ID1_4_8_, action9_.NAME_ as NAME3_4_8_, action9_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_8_, action9_.REFERENCEDACTION_ as REFERENC5_4_8_, action9_.ACTIONDELEGATION_ as ACTIONDE6_4_8_, action9_.EVENT_ as EVENT7_4_8_, action9_.PROCESSDEFINITION_ as PROCESSD8_4_8_, action9_.EXPRESSION_ as EXPRESSION9_4_8_, action9_.TIMERNAME_ as TIMERNAME10_4_8_, action9_.DUEDATE_ as DUEDATE11_4_8_, action9_.REPEAT_ as REPEAT12_4_8_, action9_.TRANSITIONNAME_ as TRANSIT13_4_8_, action9_.TIMERACTION_ as TIMERAC14_4_8_, action9_.class as class4_8_, superstate10_.ID_ as ID1_1_9_, superstate10_.NAME_ as NAME3_1_9_, superstate10_.PROCESSDEFINITION_ as PROCESSD4_1_9_, superstate10_.ACTION_ as ACTION5_1_9_, superstate10_.SUPERSTATE_ as SUPERSTATE6_1_9_ from POPULIS.JBPM_ACTION action0_ left outer join POPULIS.JBPM_ACTION action1_ on action0_.REFERENCEDACTION_=action1_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation2_ on action1_.ACTIONDELEGATION_=delegation2_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef3_ on delegation2_.PROCESSDEFINITION_=processdef3_.ID_ left outer join POPULIS.JBPM_NODE startstate4_ on processdef3_.STARTSTATE_=startstate4_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef5_ on startstate4_.PROCESSDEFINITION_=processdef5_.ID_ left outer join POPULIS.JBPM_ACTION action6_ on startstate4_.ACTION_=action6_.ID_ left outer join POPULIS.JBPM_EVENT event7_ on action6_.EVENT_=event7_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef8_ on action6_.PROCESSDEFINITION_=processdef8_.ID_ left outer join POPULIS.JBPM_ACTION action9_ on action6_.TIMERACTION_=action9_.ID_ left outer join POPULIS.JBPM_NODE superstate10_ on startstate4_.SUPERSTATE_=superstate10_.ID_ where action0_.ID_=? binding '381' to parameter: 1 select delegation0_.ID_ as ID1_6_10_, delegation0_.CLASSNAME_ as CLASSNAME2_6_10_, delegation0_.CONFIGURATION_ as CONFIGUR3_6_10_, delegation0_.CONFIGTYPE_ as CONFIGTYPE4_6_10_, delegation0_.PROCESSDEFINITION_ as PROCESSD5_6_10_, processdef1_.ID_ as ID1_0_0_, processdef1_.NAME_ as NAME2_0_0_, processdef1_.VERSION_ as VERSION3_0_0_, processdef1_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_0_, processdef1_.STARTSTATE_ as STARTSTATE5_0_0_, startstate2_.ID_ as ID1_1_1_, startstate2_.NAME_ as NAME3_1_1_, startstate2_.PROCESSDEFINITION_ as PROCESSD4_1_1_, startstate2_.ACTION_ as ACTION5_1_1_, startstate2_.SUPERSTATE_ as SUPERSTATE6_1_1_, processdef3_.ID_ as ID1_0_2_, processdef3_.NAME_ as NAME2_0_2_, processdef3_.VERSION_ as VERSION3_0_2_, processdef3_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_2_, processdef3_.STARTSTATE_ as STARTSTATE5_0_2_, action4_.ID_ as ID1_4_3_, action4_.NAME_ as NAME3_4_3_, action4_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_3_, action4_.REFERENCEDACTION_ as REFERENC5_4_3_, action4_.ACTIONDELEGATION_ as ACTIONDE6_4_3_, action4_.EVENT_ as EVENT7_4_3_, action4_.PROCESSDEFINITION_ as PROCESSD8_4_3_, action4_.EXPRESSION_ as EXPRESSION9_4_3_, action4_.TIMERNAME_ as TIMERNAME10_4_3_, action4_.DUEDATE_ as DUEDATE11_4_3_, action4_.REPEAT_ as REPEAT12_4_3_, action4_.TRANSITIONNAME_ as TRANSIT13_4_3_, action4_.TIMERACTION_ as TIMERAC14_4_3_, action4_.class as class4_3_, action5_.ID_ as ID1_4_4_, action5_.NAME_ as NAME3_4_4_, action5_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_4_, action5_.REFERENCEDACTION_ as REFERENC5_4_4_, action5_.ACTIONDELEGATION_ as ACTIONDE6_4_4_, action5_.EVENT_ as EVENT7_4_4_, action5_.PROCESSDEFINITION_ as PROCESSD8_4_4_, action5_.EXPRESSION_ as EXPRESSION9_4_4_, action5_.TIMERNAME_ as TIMERNAME10_4_4_, action5_.DUEDATE_ as DUEDATE11_4_4_, action5_.REPEAT_ as REPEAT12_4_4_, action5_.TRANSITIONNAME_ as TRANSIT13_4_4_, action5_.TIMERACTION_ as TIMERAC14_4_4_, action5_.class as class4_4_, delegation6_.ID_ as ID1_6_5_, delegation6_.CLASSNAME_ as CLASSNAME2_6_5_, delegation6_.CONFIGURATION_ as CONFIGUR3_6_5_, delegation6_.CONFIGTYPE_ as CONFIGTYPE4_6_5_, delegation6_.PROCESSDEFINITION_ as PROCESSD5_6_5_, event7_.ID_ as ID1_3_6_, event7_.EVENTTYPE_ as EVENTTYPE2_3_6_, event7_.TYPE_ as TYPE3_3_6_, event7_.GRAPHELEMENT_ as GRAPHELE4_3_6_, processdef8_.ID_ as ID1_0_7_, processdef8_.NAME_ as NAME2_0_7_, processdef8_.VERSION_ as VERSION3_0_7_, processdef8_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_0_7_, processdef8_.STARTSTATE_ as STARTSTATE5_0_7_, action9_.ID_ as ID1_4_8_, action9_.NAME_ as NAME3_4_8_, action9_.ISPROPAGATIONALLOWED_ as ISPROPAG4_4_8_, action9_.REFERENCEDACTION_ as REFERENC5_4_8_, action9_.ACTIONDELEGATION_ as ACTIONDE6_4_8_, action9_.EVENT_ as EVENT7_4_8_, action9_.PROCESSDEFINITION_ as PROCESSD8_4_8_, action9_.EXPRESSION_ as EXPRESSION9_4_8_, action9_.TIMERNAME_ as TIMERNAME10_4_8_, action9_.DUEDATE_ as DUEDATE11_4_8_, action9_.REPEAT_ as REPEAT12_4_8_, action9_.TRANSITIONNAME_ as TRANSIT13_4_8_, action9_.TIMERACTION_ as TIMERAC14_4_8_, action9_.class as class4_8_, superstate10_.ID_ as ID1_1_9_, superstate10_.NAME_ as NAME3_1_9_, superstate10_.PROCESSDEFINITION_ as PROCESSD4_1_9_, superstate10_.ACTION_ as ACTION5_1_9_, superstate10_.SUPERSTATE_ as SUPERSTATE6_1_9_ from POPULIS.JBPM_DELEGATION delegation0_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef1_ on delegation0_.PROCESSDEFINITION_=processdef1_.ID_ left outer join POPULIS.JBPM_NODE startstate2_ on processdef1_.STARTSTATE_=startstate2_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef3_ on startstate2_.PROCESSDEFINITION_=processdef3_.ID_ left outer join POPULIS.JBPM_ACTION action4_ on startstate2_.ACTION_=action4_.ID_ left outer join POPULIS.JBPM_ACTION action5_ on action4_.REFERENCEDACTION_=action5_.ID_ left outer join POPULIS.JBPM_DELEGATION delegation6_ on action5_.ACTIONDELEGATION_=delegation6_.ID_ left outer join POPULIS.JBPM_EVENT event7_ on action5_.EVENT_=event7_.ID_ left outer join POPULIS.JBPM_PROCESSDEFINITION processdef8_ on action5_.PROCESSDEFINITION_=processdef8_.ID_ left outer join POPULIS.JBPM_ACTION action9_ on action5_.TIMERACTION_=action9_.ID_ left outer join POPULIS.JBPM_NODE superstate10_ on startstate2_.SUPERSTATE_=superstate10_.ID_ where delegation0_.ID_=? binding '759' to parameter: 1 insert into POPULIS.JBPM_SWIMLANEINSTANCE (NAME_, ACTORID_, SWIMLANE_, TASKMGMTINSTANCE_) values (?, ?, ?, ?) binding 'direct' to parameter: 1 binding '315633' to parameter: 2 binding '353' to parameter: 3 binding '7405' to parameter: 4 select @@identity insert into POPULIS.JBPM_TOKENVARIABLEMAP (TOKEN_, CONTEXTINSTANCE_) values (?, ?) binding '3703' to parameter: 1 binding '7406' to parameter: 2 select @@identity insert into POPULIS.JBPM_VARIABLEINSTANCE (NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_, STRINGVALUE_, CLASS_) values (?, ?, ?, ?, ?, ?, 'S') binding 'aaaaaa' to parameter: 1 binding '3703' to parameter: 3 binding '3241' to parameter: 4 binding '3703' to parameter: 5 binding 'aaaaaa' to parameter: 6 select @@identity update POPULIS.JBPM_TOKEN set NAME_=?, START_=?, END_=?, NODEENTER_=?, NEXTLOGINDEX_=?, ISABLETOREACTIVATEPARENT_=?, ISTERMINATIONIMPLICIT_=?, NODE_=?, PROCESSINSTANCE_=?, PARENT_=? where ID_=? binding null to parameter: 1 binding '2005-12-15 12:12:00' to parameter: 2 binding null to parameter: 3 binding '2005-12-15 12:12:03' to parameter: 4 binding '8' to parameter: 5 binding 'true' to parameter: 6 binding 'false' to parameter: 7 binding '792' to parameter: 8 binding '3703' to parameter: 9 binding null to parameter: 10 binding '3703' to parameter: 11 update POPULIS.JBPM_TASKINSTANCE set NAME_=?, DESCRIPTION_=?, ACTORID_=?, CREATE_=?, START_=?, END_=?, DUEDATE_=?, PRIORITY_=?, ISCANCELLED_=?, ISSIGNALLING_=?, ISBLOCKING_=?, TASK_=?, TOKEN_=?, SWIMLANINSTANCE_=?, TASKMGMTINSTANCE_=? where ID_=? binding 'task1' to parameter: 1 binding null to parameter: 2 binding '315633' to parameter: 3 binding '2005-12-15 12:12:05' to parameter: 4 binding null to parameter: 5 binding null to parameter: 6 binding null to parameter: 7 binding '3' to parameter: 8 binding 'false' to parameter: 9 binding 'true' to parameter: 10 binding 'false' to parameter: 11 binding '355' to parameter: 12 binding '3703' to parameter: 13 binding '3353' to parameter: 14 binding '7405' to parameter: 15 binding '3700' to parameter: 16 update POPULIS.JBPM_MODULEINSTANCE set PROCESSINSTANCE_=?, NAME_=? where ID_=? binding '3703' to parameter: 1 binding 'org.jbpm.taskmgmt.exe.TaskMgmtInstance' to parameter: 2 binding '7405' to parameter: 3 update POPULIS.JBPM_MODULEINSTANCE set PROCESSINSTANCE_=?, NAME_=? where ID_=? binding '3703' to parameter: 1 binding 'org.jbpm.context.exe.ContextInstance' to parameter: 2 binding '7406' to parameter: 3
-
21. Re: Timer problems
Hello again,
I will try to test your process definition without using servlets. This is the code you sent<process-definition name="teste-timer"> <start-state name="start"> <transition name="tr1" to="state1"></transition> </start-state> <state name="state1"> <event type="node-enter"> <create-timer name="timer" duedate="1 minute" repeat="yes" transition="tr1" > <action name="action1" class="br.com.glr.jbpm.handlers.MailActionHandler"> <from>admin@glr.com.br</from> <message>timer</message> <subject>timer</subject> <to>marcos@glr.com.br</to> </action> </create-timer> </event> <transition name="tr1" to="end1"></transition> </state> <end-state name="end1"></end-state> </process-definition>
. Will send you a note soon.
Regards,
Elmo -
22. Re: Timer problems
Hi,
I have provided a sample class to run scheduler test without using the servlet. Maybe this could help you (i have not included import classes). This is a very crude way of testing but it helped me understand the activities inside.
This is the ActionHandler class. package is br.com.glr.jbpm.handlerspublic class MailActionHandler implements ActionHandler { String message; String to; String from; String subject; public void execute(ExecutionContext executionContext) throws Exception { System.out.println( "MAILING MESSAGE " + subject + "; to->" + to + "; from->" + from + "; message->" + message); } }
And this is my test classpublic class TestDeployer { public static void deployTest() throws Exception{ ProcessDefinition def = ProcessDefinition.parseXmlString( "<process-definition name='test-timer-process'>" + "<start-state name='start-test'>" + "<transition to='state1'/>" + "</start-state>" + "<state name='state1'>" + "<timer name='test-timer' duedate='20 seconds' repeat='10 seconds'>" + "<action name='test-timer-action' class='br.com.glr.jbpm.handlers.MailActionHandler'>" + "<from>admin@glr.com.br</from>" + "<message>timer</message>" + "<subject>timer</subject>" + "<to>marcos@glr.com.br</to>" + "</action>" + "</timer>" + "<transition to='end-test'/>" + "</state>" + "<end-state name='end-test'/>" + "</process-definition>" ); JbpmSession session = JbpmSessionFactory.getInstance().openJbpmSession(); session.beginTransaction(); session.getGraphSession().saveProcessDefinition(def); session.commitTransactionAndClose(); System.out.println( "FINISH DEPLOYMENT" ); } public static void createProcessInstance() throws Exception{ JbpmSession session = JbpmSessionFactory.getInstance().openJbpmSession(); ProcessDefinition def = session.getGraphSession().findLatestProcessDefinition("test-timer-process"); ProcessInstance proc = new ProcessInstance(def); //System.out.println( proc.getRootToken().getNode().getName() ); session.beginTransaction(); session.getGraphSession().saveProcessInstance(proc); session.commitTransactionAndClose(); System.out.println( "YOUR PROCESS INSTANCE ID " + proc.getId()); } public static void runFirstState(long id) throws Exception { JbpmSession session = JbpmSessionFactory.getInstance().openJbpmSession(); ProcessInstance proc = session.getGraphSession().loadProcessInstance(id); proc.signal(); session.beginTransaction(); session.getGraphSession().saveProcessInstance(proc); session.commitTransactionAndClose(); System.out.println( "your state name is " + proc.getRootToken().getNode().getName()); } public static void runScheduler() throws Exception{ JbpmSession session = JbpmSessionFactory.getInstance().openJbpmSession(); SchedulerThread th = new SchedulerThread(); th.start(); } public static void endState(long id) throws Exception { JbpmSession session = JbpmSessionFactory.getInstance().openJbpmSession(); ProcessInstance proc = session.getGraphSession().loadProcessInstance(id); proc.signal(); session.beginTransaction(); session.getGraphSession().saveProcessInstance(proc); session.commitTransactionAndClose(); } public static void main(String[] args) throws Exception { //test } }
You must run these codes one at a time and observe the databse (I suggest you have a clean database):
1. deployProcess();
TABLES AFFECTED: JBPM_PROCESSDEFINITION, JBPM_NODE,JBPM_TRANSITION,JBPM_NODE,JBPM_EVENT,JBPM_ACTION,JBPM_DELEGATION,JBPM_MODULEDEFINITION
2. createProcessInstance();
TABLE AFFECTED: JBPM_TOKEN, JBPM_PROCESSINSTANCE, JBPM_MODULEINSTANCE, JBPM_LOG, JBPM_TOKEN
NOTE: This will create a process instance number. You must remember this instance for our next method. Special take note of JBPM_PROCESSINSTANCE.
3. runFirstState( processId ) //processId is the id in #2
TABLES AFFECTED: JBPM_LOG, JBPM_TIMER, JBPM_TOKEN
NOTE: The JBPM_TIMER is populated at this point. At this node state, this means the timer is activated. However, you cannot see the effects until
you run the SchedulerThread.
4. runScheduler()
NOTE: This will run the thread that looks up the JBPM_TIMER. Our ActionHandler will be executed in this step. If not, you must check that
your classes are referenced properly otherwise an error occurs.
5. endState( processId );
TABLES AFFECTED: JBPM_LOG, JBPM_TIMER, JBPM_TOKEN, JBPM_PROCESSINSTANCE
NOTE: At this point, the JBPM_TIMER entry will be removed. If you try to run SchedulerThread, there will be no more actions to invoke.
Anyway, I hope this will help you in your testing. If this doesn't work just notify me. Good luck!
Regards,
Elmo
-
23. Re: Timer problems
Men!
It works in a standalone teste, but in my project it don't works !!!
the JBPM_TIMER was successfully mounted and the JBPM_LOG too ...
these was my 2 problems !!!
I dont know what else i have to do !!!!
Let me exlplain !
I work in a CMT Transaction scenario, using Data Source for connections with data base ... a SessionBean that contains methods for my business and this comunicate with my singleton class that comunicate with jbpm.
I dont know if it could be a thread problem, or a data base transaction problem !!!
i have 3 class loaders working together excluding system class loader ...
i do not use begintransaction and/or committransaction and/or close methods for transaction ! couse the container does not allow me to do it, beign a cmttransaction, the container takes care of it !!!
i really dont know what i have to do ! -
24. Re: Timer problems
Wowww !!!
It works !!!
You will not beliave !!!
See previeous code :ProcessDefinition pd = getJbpmSession().getGraphSession().findLatestProcessDefinition(name); ProcessInstance pi = new ProcessInstance(pd); if(variables!=null){ pi.getContextInstance().addVariables(variables); } pi.signal(); return new Long(pi.getId());
See the newer code :GraphSession session = getJbpmSession().getGraphSession(); ProcessDefinition pd = session.findLatestProcessDefinition(name); ProcessInstance pi = new ProcessInstance(pd); if(variables!=null){ pi.getContextInstance().addVariables(variables); } pi.signal(); session.saveProcessInstance( pi ); return new Long(pi.getId());
I haven't save the process instance, but everything was working in other process, less the log!!
i dont believe in this !!! its making me crazy !!!!
i will do more tests -
25. Re: Timer problems
Oww,
I forgot to thank you !!!
You was so cool and saves me !!
Thanks a lot ! very very much !!!! -