[jboss-user] [JBoss jBPM] - Re: Problem with getting process instance's creator

Tue Feb 27 09:49:58 EST 2007

"kukeltje" wrote : - What is the behaviour you see?
  | 
I just check jbpm_swimlaneinstance. I look for a place in database where the login on creator is stored what is needed for quering all proccess instances started by given login.

"kukeltje" wrote : 
  | - What version of jBPM?
  | [/quote="kukeltje"]
  | 3.1.4
  | 
  | "kukeltje" wrote : 
  |   | - What does the debug output log?
  |   | 
  | After starting a process?
  | 
  | 
  |   | 15:47:55,813 INFO  [STDOUT] Hibernate: select top ? processdef0_.ID_ as ID1_2994_, processdef0_.NAME_ as NAME2_2994_, processdef0_.VERSION_ as VERSION3_2994_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_2994_, processdef0_.STARTSTATE_ as STARTSTATE5_2994_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc
  |   | 15:47:55,819 INFO  [STDOUT] Hibernate: insert into JBPM_TOKEN (ID_, VERSION_, NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, ISSUSPENDED_, NODE_, PROCESSINSTANCE_, PARENT_, SUBPROCESSINSTANCE_) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  |   | 15:47:55,820 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,821 INFO  [STDOUT] Hibernate: insert into JBPM_PROCESSINSTANCE (ID_, VERSION_, START_, END_, ISSUSPENDED_, PROCESSDEFINITION_, ROOTTOKEN_, SUPERPROCESSTOKEN_) values (null, ?, ?, ?, ?, ?, ?, ?)
  |   | 15:47:55,822 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,823 INFO  [STDOUT] Hibernate: select definition0_.PROCESSDEFINITION_ as PROCESSD4_1_, definition0_.ID_ as ID1_1_, definition0_.NAME_ as NAME3_1_, definition0_.ID_ as ID1_3006_0_, definition0_.NAME_ as NAME3_3006_0_, definition0_.PROCESSDEFINITION_ as PROCESSD4_3006_0_, definition0_.STARTTASK_ as STARTTASK5_3006_0_, definition0_.CLASS_ as CLASS2_3006_0_ from JBPM_MODULEDEFINITION definition0_ where definition0_.PROCESSDEFINITION_=?
  |   | 15:47:55,835 INFO  [STDOUT] Hibernate: select events0_.PROCESSDEFINITION_ as PROCESSD5_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_2997_0_, events0_.EVENTTYPE_ as EVENTTYPE2_2997_0_, events0_.TYPE_ as TYPE3_2997_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_2997_0_ from JBPM_EVENT events0_ where events0_.PROCESSDEFINITION_=?
  |   | 15:47:55,837 INFO  [STDOUT] Hibernate: select node0_.ID_ as ID1_2995_0_, node0_.NAME_ as NAME3_2995_0_, node0_.PROCESSDEFINITION_ as PROCESSD4_2995_0_, node0_.ISASYNC_ as ISASYNC5_2995_0_, node0_.ACTION_ as ACTION6_2995_0_, node0_.SUPERSTATE_ as SUPERSTATE7_2995_0_, node0_.SUBPROCESSDEFINITION_ as SUBPROCE8_2995_0_, node0_.DECISIONEXPRESSION_ as DECISION9_2995_0_, node0_.DECISIONDELEGATION as DECISIO10_2995_0_, node0_.SIGNAL_ as SIGNAL11_2995_0_, node0_.CREATETASKS_ as CREATET12_2995_0_, node0_.ENDTASKS_ as ENDTASKS13_2995_0_, node0_.CLASS_ as CLASS2_2995_0_ from JBPM_NODE node0_ where node0_.ID_=?
  |   | 15:47:55,839 INFO  [STDOUT] Hibernate: select leavingtra0_.FROM_ as FROM4_1_, leavingtra0_.ID_ as ID1_1_, leavingtra0_.FROMINDEX_ as FROMINDEX6_1_, leavingtra0_.ID_ as ID1_2996_0_, leavingtra0_.NAME_ as NAME2_2996_0_, leavingtra0_.PROCESSDEFINITION_ as PROCESSD3_2996_0_, leavingtra0_.FROM_ as FROM4_2996_0_, leavingtra0_.TO_ as TO5_2996_0_ from JBPM_TRANSITION leavingtra0_ where leavingtra0_.FROM_=?
  |   | 15:47:55,842 INFO  [STDOUT] Hibernate: select events0_.NODE_ as NODE6_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_2997_0_, events0_.EVENTTYPE_ as EVENTTYPE2_2997_0_, events0_.TYPE_ as TYPE3_2997_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_2997_0_ from JBPM_EVENT events0_ where events0_.NODE_=?
  |   | 15:47:55,844 INFO  [STDOUT] Hibernate: select events0_.TRANSITION_ as TRANSITION7_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_2997_0_, events0_.EVENTTYPE_ as EVENTTYPE2_2997_0_, events0_.TYPE_ as TYPE3_2997_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_2997_0_ from JBPM_EVENT events0_ where events0_.TRANSITION_=?
  |   | 15:47:55,846 INFO  [STDOUT] Hibernate: select node0_.ID_ as ID1_2995_0_, node0_.NAME_ as NAME3_2995_0_, node0_.PROCESSDEFINITION_ as PROCESSD4_2995_0_, node0_.ISASYNC_ as ISASYNC5_2995_0_, node0_.ACTION_ as ACTION6_2995_0_, node0_.SUPERSTATE_ as SUPERSTATE7_2995_0_, node0_.SUBPROCESSDEFINITION_ as SUBPROCE8_2995_0_, node0_.DECISIONEXPRESSION_ as DECISION9_2995_0_, node0_.DECISIONDELEGATION as DECISIO10_2995_0_, node0_.SIGNAL_ as SIGNAL11_2995_0_, node0_.CREATETASKS_ as CREATET12_2995_0_, node0_.ENDTASKS_ as ENDTASKS13_2995_0_, node0_.CLASS_ as CLASS2_2995_0_ from JBPM_NODE node0_ where node0_.ID_=?
  |   | 15:47:55,848 INFO  [STDOUT] Hibernate: select events0_.NODE_ as NODE6_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_2997_0_, events0_.EVENTTYPE_ as EVENTTYPE2_2997_0_, events0_.TYPE_ as TYPE3_2997_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_2997_0_ from JBPM_EVENT events0_ where events0_.NODE_=?
  |   | 15:47:55,855 INFO  [STDOUT] Hibernate: select tasks0_.TASKNODE_ as TASKNODE11_1_, tasks0_.ID_ as ID1_1_, tasks0_.ID_ as ID1_3004_0_, tasks0_.NAME_ as NAME2_3004_0_, tasks0_.PROCESSDEFINITION_ as PROCESSD3_3004_0_, tasks0_.DESCRIPTION_ as DESCRIPT4_3004_0_, tasks0_.ISBLOCKING_ as ISBLOCKING5_3004_0_, tasks0_.ISSIGNALLING_ as ISSIGNAL6_3004_0_, tasks0_.DUEDATE_ as DUEDATE7_3004_0_, tasks0_.ACTORIDEXPRESSION_ as ACTORIDE8_3004_0_, tasks0_.POOLEDACTORSEXPRESSION_ as POOLEDAC9_3004_0_, tasks0_.TASKMGMTDEFINITION_ as TASKMGM10_3004_0_, tasks0_.TASKNODE_ as TASKNODE11_3004_0_, tasks0_.STARTSTATE_ as STARTSTATE12_3004_0_, tasks0_.ASSIGNMENTDELEGATION_ as ASSIGNM13_3004_0_, tasks0_.SWIMLANE_ as SWIMLANE14_3004_0_, tasks0_.TASKCONTROLLER_ as TASKCON15_3004_0_ from JBPM_TASK tasks0_ where tasks0_.TASKNODE_=?
  |   | 15:47:55,856 WARN  [ProxyWarnLog] Narrowing proxy to class org.jbpm.graph.node.TaskNode - this operation breaks ==
  |   | 15:47:55,864 INFO  [STDOUT] Hibernate: insert into JBPM_TASKINSTANCE (ID_, NAME_, DESCRIPTION_, ACTORID_, CREATE_, START_, END_, DUEDATE_, PRIORITY_, ISCANCELLED_, ISSUSPENDED_, ISOPEN_, ISSIGNALLING_, ISBLOCKING_, TASK_, TOKEN_, SWIMLANINSTANCE_, TASKMGMTINSTANCE_, CLASS_) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'T')
  |   | 15:47:55,865 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,866 INFO  [STDOUT] Hibernate: select events0_.TASK_ as TASK8_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_2997_0_, events0_.EVENTTYPE_ as EVENTTYPE2_2997_0_, events0_.TYPE_ as TYPE3_2997_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_2997_0_ from JBPM_EVENT events0_ where events0_.TASK_=?
  |   | 15:47:55,975 INFO  [STDOUT] Hibernate: insert into JBPM_LOG (ID_, INDEX_, DATE_, TOKEN_, PARENT_, CLASS_) values (null, ?, ?, ?, ?, 'I')
  |   | 15:47:55,976 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,976 INFO  [STDOUT] Hibernate: insert into JBPM_LOG (ID_, INDEX_, DATE_, TOKEN_, PARENT_, TRANSITION_, CLASS_) values (null, ?, ?, ?, ?, ?, 'S')
  |   | 15:47:55,977 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,978 INFO  [STDOUT] Hibernate: insert into JBPM_LOG (ID_, INDEX_, DATE_, TOKEN_, PARENT_, TRANSITION_, SOURCENODE_, DESTINATIONNODE_, CLASS_) values (null, ?, ?, ?, ?, ?, ?, ?, 'T')
  |   | 15:47:55,979 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,980 INFO  [STDOUT] Hibernate: insert into JBPM_LOG (ID_, INDEX_, DATE_, TOKEN_, PARENT_, TASKINSTANCE_, TASKACTORID_, CLASS_) values (null, ?, ?, ?, ?, ?, ?, '1')
  |   | 15:47:55,980 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,982 INFO  [STDOUT] Hibernate: insert into JBPM_MODULEINSTANCE (ID_, PROCESSINSTANCE_, TASKMGMTDEFINITION_, CLASS_) values (null, ?, ?, 'T')
  |   | 15:47:55,982 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,983 INFO  [STDOUT] Hibernate: insert into JBPM_MODULEINSTANCE (ID_, PROCESSINSTANCE_, CLASS_) values (null, ?, 'C')
  |   | 15:47:55,984 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,985 INFO  [STDOUT] Hibernate: insert into JBPM_POOLEDACTOR (ID_, ACTORID_, SWIMLANEINSTANCE_) values (null, ?, ?)
  |   | 15:47:55,986 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:55,990 INFO  [STDOUT] Hibernate: update JBPM_TOKEN set VERSION_=?, NAME_=?, START_=?, END_=?, NODEENTER_=?, NEXTLOGINDEX_=?, ISABLETOREACTIVATEPARENT_=?, ISTERMINATIONIMPLICIT_=?, ISSUSPENDED_=?, NODE_=?, PROCESSINSTANCE_=?, PARENT_=?, SUBPROCESSINSTANCE_=? where ID_=? and VERSION_=?
  |   | 15:47:55,991 INFO  [STDOUT] Hibernate: update JBPM_PROCESSINSTANCE set VERSION_=?, START_=?, END_=?, ISSUSPENDED_=?, PROCESSDEFINITION_=?, ROOTTOKEN_=?, SUPERPROCESSTOKEN_=? where ID_=? and VERSION_=?
  |   | 15:47:55,991 INFO  [STDOUT] Hibernate: update JBPM_TASKINSTANCE set NAME_=?, DESCRIPTION_=?, ACTORID_=?, CREATE_=?, START_=?, END_=?, DUEDATE_=?, PRIORITY_=?, ISCANCELLED_=?, ISSUSPENDED_=?, ISOPEN_=?, ISSIGNALLING_=?, ISBLOCKING_=?, TASK_=?, TOKEN_=?, SWIMLANINSTANCE_=?, TASKMGMTINSTANCE_=? where ID_=?
  |   | 15:47:55,992 INFO  [STDOUT] Hibernate: update JBPM_MODULEINSTANCE set PROCESSINSTANCE_=?, NAME_=? where ID_=?
  |   | 15:47:55,992 INFO  [STDOUT] Hibernate: update JBPM_MODULEINSTANCE set PROCESSINSTANCE_=?, NAME_=? where ID_=?
  |   | 15:47:55,993 INFO  [STDOUT] Hibernate: insert into JBPM_TASKACTORPOOL (TASKINSTANCE_, POOLEDACTOR_) values (?, ?)
  |   | 15:47:55,994 INFO  [STDOUT] Hibernate: call identity()
  |   | 15:47:56,092 INFO  [STDOUT] Hibernate: select taskinstan0_.ID_ as ID1_3017_, taskinstan0_.NAME_ as NAME3_3017_, taskinstan0_.DESCRIPTION_ as DESCRIPT4_3017_, taskinstan0_.ACTORID_ as ACTORID5_3017_, taskinstan0_.CREATE_ as CREATE6_3017_, taskinstan0_.START_ as START7_3017_, taskinstan0_.END_ as END8_3017_, taskinstan0_.DUEDATE_ as DUEDATE9_3017_, taskinstan0_.PRIORITY_ as PRIORITY10_3017_, taskinstan0_.ISCANCELLED_ as ISCANCE11_3017_, taskinstan0_.ISSUSPENDED_ as ISSUSPE12_3017_, taskinstan0_.ISOPEN_ as ISOPEN13_3017_, taskinstan0_.ISSIGNALLING_ as ISSIGNA14_3017_, taskinstan0_.ISBLOCKING_ as ISBLOCKING15_3017_, taskinstan0_.TASK_ as TASK16_3017_, taskinstan0_.TOKEN_ as TOKEN17_3017_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN18_3017_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM19_3017_ from JBPM_TASKINSTANCE taskinstan0_ where taskinstan0_.ACTORID_=? and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
  |   | 15:47:56,110 INFO  [STDOUT] Hibernate: select taskinstan0_.ID_ as ID1_3017_, taskinstan0_.NAME_ as NAME3_3017_, taskinstan0_.DESCRIPTION_ as DESCRIPT4_3017_, taskinstan0_.ACTORID_ as ACTORID5_3017_, taskinstan0_.CREATE_ as CREATE6_3017_, taskinstan0_.START_ as START7_3017_, taskinstan0_.END_ as END8_3017_, taskinstan0_.DUEDATE_ as DUEDATE9_3017_, taskinstan0_.PRIORITY_ as PRIORITY10_3017_, taskinstan0_.ISCANCELLED_ as ISCANCE11_3017_, taskinstan0_.ISSUSPENDED_ as ISSUSPE12_3017_, taskinstan0_.ISOPEN_ as ISOPEN13_3017_, taskinstan0_.ISSIGNALLING_ as ISSIGNA14_3017_, taskinstan0_.ISBLOCKING_ as ISBLOCKING15_3017_, taskinstan0_.TASK_ as TASK16_3017_, taskinstan0_.TOKEN_ as TOKEN17_3017_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN18_3017_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM19_3017_ from JBPM_TASKINSTANCE taskinstan0_ where taskinstan0_.ACTORID_=? and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
  |   | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023064#4023064

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4023064