[JBoss jBPM] - Re: Problem with getting process instance's creator
by kot.filemon
"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
19Â years, 1Â month
[JBoss jBPM] - Problem with getting process instance's creator
by kot.filemon
Hello,
I'm new to jBPM, so forgive me silly question.
How to get process instance's creator.
I tried like this
ProcessDefinition.
| <?xml version="1.0" encoding="UTF-8"?>
|
| <process-definition xmlns="" name="vacationRequest">
| <swimlane name="originator"/>
| <start-state name="start">
| <task swimlane ="originator"/>
|
| <transition name="" to="decision"/>
| </start-state>
| <task-node name="decision">
| <task name="decide">
| <assignment pooled-actors="#{vacationRequest.assign}"/>
| </task>
| <transition name="cancel" to="canceled"/>
|
| <transition name="ok" to="approved"/>
| </task-node>
| <end-state name="canceled"></end-state>
| <end-state name="approved"></end-state>
| </process-definition>
|
then I start a process (with Seam):
| @CreateProcess(definition = "vacationRequest")
| public void startProcess() {
| System.out.println("start process");
|
| }
|
or, by using API
| Jbpm bpm = Jbpm.instance();
| JbpmConfiguration conf = bpm.getJbpmConfiguration();
| JbpmContext context = conf.createJbpmContext();
| ProcessDefinition pd = context.getGraphSession().findLatestProcessDefinition(definition);
| context.setActorId(Actor.instance().getId());
| ProcessInstance p = new ProcessInstance(pd);
|
| Token t = p.getRootToken();
| t.signal();
| /*Collection taskInstances = p.getTaskMgmtInstance().getTaskInstances();
| Iterator iter = taskInstances.iterator();
| while(iter.hasNext()) {
|
| TaskInstance task = (TaskInstance) iter.next();
| System.out.println("start" + task.getName());
| task.start();
| System.out.println("end" + task.getName());
| task.end();
| System.out.println("save" + task.getName());
| context.save(task);
| }*/
|
| context.save(p);
| context.close();
| System.out.println("po jade");
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023056#4023056
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4023056
19Â years, 1Â month