<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: saving state after workitem
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/pmancham">Prasanth Manchambhatla</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/649177#649177">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>One more problem - after (a) & (b) above <span> :) </span> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>(c) I had 2 workitems. First one was inserted & updated. Second one was never inserted & the process exited. Why? [Queries can be seen from logs I pasted below]</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My sample test case </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="text-decoration: underline;"><strong>BPMN: (Also attached picture below)</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0" encoding="UTF-8"?> </p><p><definitions id="Definition"</p><p><span>             targetNamespace="</span><a class="jive-link-external-small" href="http://www.jboss.org/drools" target="_blank">http://www.jboss.org/drools</a><span>"</span></p><p><span>             typeLanguage="</span><a class="jive-link-external-small" href="http://www.java.com/javaTypes" target="_blank">http://www.java.com/javaTypes</a><span>"</span></p><p><span>             expressionLanguage="</span><a class="jive-link-external-small" href="http://www.mvel.org/2.0" target="_blank">http://www.mvel.org/2.0</a><span>"</span></p><p><span>             xmlns="</span><a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL" target="_blank">http://www.omg.org/spec/BPMN/20100524/MODEL</a><span>"</span></p><p><span>             xmlns:xsi="</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span></p><p><span>             xsi:schemaLocation="</span><a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL" target="_blank">http://www.omg.org/spec/BPMN/20100524/MODEL</a><span> BPMN20.xsd"</span></p><p><span>             xmlns:g="</span><a class="jive-link-external-small" href="http://www.jboss.org/drools/flow/gpd" target="_blank">http://www.jboss.org/drools/flow/gpd</a><span>"</span></p><p><span>             xmlns:bpmndi="</span><a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/DI" target="_blank">http://www.omg.org/spec/BPMN/20100524/DI</a><span>"</span></p><p><span>             xmlns:dc="</span><a class="jive-link-external-small" href="http://www.omg.org/spec/DD/20100524/DC" target="_blank">http://www.omg.org/spec/DD/20100524/DC</a><span>"</span></p><p><span>             xmlns:di="</span><a class="jive-link-external-small" href="http://www.omg.org/spec/DD/20100524/DI" target="_blank">http://www.omg.org/spec/DD/20100524/DI</a><span>"</span></p><p><span>             xmlns:tns="</span><a class="jive-link-external-small" href="http://www.jboss.org/drools" target="_blank">http://www.jboss.org/drools</a><span>"></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  <itemDefinition id="_result1Item" structureRef="String" /></p><p>  <itemDefinition id="_result2Item" structureRef="String" /></p><p>  <itemDefinition id="_retry1Item" structureRef="Integer" /></p><p>  <itemDefinition id="_retry2Item" structureRef="Integer" /></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  <process processType="Private" isExecutable="true" id="com.sample.bpmn.saveStateExample" name="Sample Process" tns:packageName="testPackage" ></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <!-- process variables --></p><p>    <property id="result1" itemSubjectRef="_result1Item"/></p><p>    <property id="result2" itemSubjectRef="_result2Item"/></p><p>    <property id="retry1" itemSubjectRef="_retry1Item"/></p><p>    <property id="retry2" itemSubjectRef="_retry2Item"/></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <!-- nodes --></p><p>    <startEvent id="_1" name="StartProcess" /></p><p><span>    <scriptTask id="_3" name="Script" scriptFormat="</span><a class="jive-link-external-small" href="http://www.java.com/java" target="_blank">http://www.java.com/java</a><span>" ></span></p><p>      <script>System.out.println("********** MESSAGE1 *************");</p><p>String message1 = ((String) kcontext.getVariable("result1"));</p><p>System.out.println(message1);</p><p>message1 = message1 + " World";</p><p>kcontext.setVariable("result1", message1);</p><p>System.out.println("********** END1 *************");</script></p><p>    </scriptTask></p><p><span>    <scriptTask id="_5" name="Script" scriptFormat="</span><a class="jive-link-external-small" href="http://www.java.com/java" target="_blank">http://www.java.com/java</a><span>" ></span></p><p>      <script>System.out.println("********** MESSAGE2 *************");</p><p>String message2 = ((String) kcontext.getVariable("result1"));</p><p>System.out.println(message2);</p><p>System.out.println("********** END2 *************");</script></p><p>    </scriptTask></p><p>    <endEvent id="_6" name="End" ></p><p>        <terminateEventDefinition/></p><p>    </endEvent></p><p>    <task id="_9" name="SaveState" tns:taskName="SaveState" ></p><p>      <ioSpecification></p><p>        <inputSet></p><p>        </inputSet></p><p>        <outputSet></p><p>        </outputSet></p><p>      </ioSpecification></p><p>    </task></p><p>    <task id="_10" name="SaveState" tns:taskName="SaveState" ></p><p>      <ioSpecification></p><p>        <inputSet></p><p>        </inputSet></p><p>        <outputSet></p><p>        </outputSet></p><p>      </ioSpecification></p><p>    </task></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <!-- connections --></p><p>    <sequenceFlow id="_9-_3" sourceRef="_9" targetRef="_3" /></p><p>    <sequenceFlow id="_10-_5" sourceRef="_10" targetRef="_5" /></p><p>    <sequenceFlow id="_5-_6" sourceRef="_5" targetRef="_6" /></p><p>    <sequenceFlow id="_1-_9" sourceRef="_1" targetRef="_9" /></p><p>    <sequenceFlow id="_3-_10" sourceRef="_3" targetRef="_10" /></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  </process></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  <bpmndi:BPMNDiagram></p><p>    <bpmndi:BPMNPlane bpmnElement="com.sample.bpmn.saveStateExample" ></p><p>      <bpmndi:BPMNShape bpmnElement="_1" ></p><p>        <dc:Bounds x="55" y="106" width="48" height="48" /></p><p>      </bpmndi:BPMNShape></p><p>      <bpmndi:BPMNShape bpmnElement="_3" ></p><p>        <dc:Bounds x="136" y="208" width="117" height="48" /></p><p>      </bpmndi:BPMNShape></p><p>      <bpmndi:BPMNShape bpmnElement="_5" ></p><p>        <dc:Bounds x="313" y="295" width="96" height="48" /></p><p>      </bpmndi:BPMNShape></p><p>      <bpmndi:BPMNShape bpmnElement="_6" ></p><p>        <dc:Bounds x="341" y="389" width="48" height="48" /></p><p>      </bpmndi:BPMNShape></p><p>      <bpmndi:BPMNShape bpmnElement="_9" ></p><p>        <dc:Bounds x="321" y="111" width="100" height="48" /></p><p>      </bpmndi:BPMNShape></p><p>      <bpmndi:BPMNShape bpmnElement="_10" ></p><p>        <dc:Bounds x="471" y="196" width="100" height="48" /></p><p>      </bpmndi:BPMNShape></p><p>      <bpmndi:BPMNEdge bpmnElement="_9-_3" ></p><p>        <di:waypoint x="371" y="135" /></p><p>        <di:waypoint x="194" y="232" /></p><p>      </bpmndi:BPMNEdge></p><p>      <bpmndi:BPMNEdge bpmnElement="_10-_5" ></p><p>        <di:waypoint x="521" y="220" /></p><p>        <di:waypoint x="361" y="319" /></p><p>      </bpmndi:BPMNEdge></p><p>      <bpmndi:BPMNEdge bpmnElement="_5-_6" ></p><p>        <di:waypoint x="361" y="319" /></p><p>        <di:waypoint x="365" y="413" /></p><p>      </bpmndi:BPMNEdge></p><p>      <bpmndi:BPMNEdge bpmnElement="_1-_9" ></p><p>        <di:waypoint x="79" y="130" /></p><p>        <di:waypoint x="371" y="135" /></p><p>      </bpmndi:BPMNEdge></p><p>      <bpmndi:BPMNEdge bpmnElement="_3-_10" ></p><p>        <di:waypoint x="194" y="232" /></p><p>        <di:waypoint x="521" y="220" /></p><p>      </bpmndi:BPMNEdge></p><p>    </bpmndi:BPMNPlane></p><p>  </bpmndi:BPMNDiagram></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p></definitions></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="text-decoration: underline;"><strong>SaveState WorkItem:</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>public class SaveStateWorkItemHandler implements WorkItemHandler {</p><p>    @Override</p><p>    public void executeWorkItem(WorkItem workItem, WorkItemManager workItemManager) {</p><p>        System.out.println("******** START SAVE-STATE SLEEP *************");</p><p>        final WorkItem myWorkItem = workItem;</p><p>        final WorkItemManager myWorkItemManager = workItemManager;</p><p>        Thread t = new Thread(new Runnable() {</p><p>            @Override</p><p>            public void run() {</p><p>                try {</p><p>                    for (int i=0; i<10; i++) {</p><p>                        System.out.println("i = " + i);</p><p>                        Thread.sleep(2000);</p><p>                    }</p><p>                    System.out.println("******** END SAVE-STATE SLEEP *************");</p><p>                    myWorkItemManager.completeWorkItem(myWorkItem.getId(), null);</p><p>                } catch (InterruptedException e) {</p><p>                    System.out.println("Exception while sleeping in the thread");</p><p>                    e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.</p><p>                }</p><p>            }</p><p>        });</p><p>        t.start();</p><p>        System.out.println("******** END SAVE-STATE *************");</p><p>    }</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    @Override</p><p>    public void abortWorkItem(WorkItem workItem, WorkItemManager workItemManager) {</p><p>        //Do Nothing.</p><p>        workItemManager.abortWorkItem(workItem.getId());</p><p>    }</p><p>}</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="text-decoration: underline;"><strong>Servlet that starts the workflow:</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Properties properties = new Properties();</p><p>        properties.put("drools.processInstanceManagerFactory", "org.jbpm.persistence.processinstance.JPAProcessInstanceManagerFactory");</p><p>        properties.put("drools.processSignalManagerFactory", "org.jbpm.persistence.processinstance.JPASignalManagerFactory");</p><p>        KnowledgeSessionConfiguration config = KnowledgeBaseFactory.newKnowledgeSessionConfiguration(properties);</p><p>        if (sid == -1) {</p><p>            EntityManagerFactory emf =</p><p>                    Persistence.createEntityManagerFactory("org.jbpm.persistence.jpa");</p><p>            Environment env = KnowledgeBaseFactory.newEnvironment();</p><p>            env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);</p><p>            //env.set(EnvironmentName.TRANSACTION_MANAGER,)</p><p>            // create a new knowledge session that uses JPA to store the runtime state</p><p>            StatefulKnowledgeSession ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, config, env);</p><p>            JPAWorkingMemoryDbLogger dblogger = new JPAWorkingMemoryDbLogger(ksession);</p><p>            KnowledgeRuntimeLogger logger = KnowledgeRuntimeLoggerFactory.newThreadedFileLogger(ksession, "test", 1000);</p><p>            ksession.getWorkItemManager().registerWorkItemHandler("SaveState", new SaveStateWorkItemHandler());</p><p>            int sessionId = ksession.getId();</p><p>            // invoke methods on your method here</p><p>            ProcessInstance pi = (ProcessInstance) ksession.startProcess(processId, params);</p><p>            System.out.println("Process started ... sessionId = " + sessionId + " processId = " + pi.getId());</p><p><em>               </em></p><p><em>            //Ignore the lines below - Added it for some other workflow I was testing</em></p><p>            <em>try {</em></p><p><em>                System.out.println("Sleeping for 15 seconds");</em></p><p><em>                Thread.sleep(15000);</em></p><p><em>            } catch (InterruptedException e) {</em></p><p><em>                e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.</em></p><p><em>            }</em></p><p><em>            pi.signalEvent(signal, signalData);</em></p><p><em>            System.out.println("Signaled event");</em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="text-decoration: underline;"><strong>Logs:</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,308 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select SESSIONINFO_ID_SEQ.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,308 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into SessionInfo (lastModificationDate, rulesByteArray, startDate, OPTLOCK, id) values (?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,324 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,324 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,324 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,324 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,340 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,340 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,340 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,340 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,340 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: select WORKITEMINFO_ID_SEQ.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (http--0.0.0.0-8080-4) ******** START SAVE-STATE SLEEP *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (http--0.0.0.0-8080-4) ******** END SAVE-STATE *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (Thread-69) i = 0</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,355 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,371 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into ProcessInstanceInfo (lastModificationDate, lastReadDate, processId, processInstanceByteArray, startDate, state, OPTLOCK, InstanceId) values (?, ?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,371 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into VariableInstanceLog (log_date, processId, processInstanceId, value, variableId, variableInstanceId, id) values (?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,371 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into VariableInstanceLog (log_date, processId, processInstanceId, value, variableId, variableInstanceId, id) values (?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,386 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into VariableInstanceLog (log_date, processId, processInstanceId, value, variableId, variableInstanceId, id) values (?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,386 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into VariableInstanceLog (log_date, processId, processInstanceId, value, variableId, variableInstanceId, id) values (?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,386 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into VariableInstanceLog (log_date, processId, processInstanceId, value, variableId, variableInstanceId, id) values (?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,386 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into VariableInstanceLog (log_date, processId, processInstanceId, value, variableId, variableInstanceId, id) values (?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,402 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into ProcessInstanceLog (end_date, processId, processInstanceId, start_date, id) values (?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,402 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into NodeInstanceLog (log_date, nodeId, nodeInstanceId, nodeName, processId, processInstanceId, type, id) values (?, ?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,402 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into NodeInstanceLog (log_date, nodeId, nodeInstanceId, nodeName, processId, processInstanceId, type, id) values (?, ?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,402 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into NodeInstanceLog (log_date, nodeId, nodeInstanceId, nodeName, processId, processInstanceId, type, id) values (?, ?, ?, ?, ?, ?, ?, ?)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>11:48:45,418 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: insert into WorkItemInfo (creationDate, name, processInstanceId, state, OPTLOCK, workItemByteArray, workItemId) values (?, ?, ?, ?, ?, ?, ?)</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,418 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: update ProcessInstanceInfo set lastModificationDate=?, lastReadDate=?, processId=?, processInstanceByteArray=?, startDate=?, state=?, OPTLOCK=? where InstanceId=? and OPTLOCK=?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>11:48:45,418 INFO  [stdout] (http--0.0.0.0-8080-4) Hibernate: update WorkItemInfo set creationDate=?, name=?, processInstanceId=?, state=?, OPTLOCK=?, workItemByteArray=? where workItemId=? and OPTLOCK=?</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,433 INFO  [stdout] (http--0.0.0.0-8080-4) Process started ... sessionId = 35 processId = 818</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:45,433 INFO  [stdout] (http--0.0.0.0-8080-4) Sleeping for 15 seconds</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:47,353 INFO  [stdout] (Thread-69) i = 1</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:49,366 INFO  [stdout] (Thread-69) i = 2</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:51,363 INFO  [stdout] (Thread-69) i = 3</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:53,361 INFO  [stdout] (Thread-69) i = 4</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:55,358 INFO  [stdout] (Thread-69) i = 5</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:57,355 INFO  [stdout] (Thread-69) i = 6</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:48:59,353 INFO  [stdout] (Thread-69) i = 7</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:00,414 INFO  [stdout] (http--0.0.0.0-8080-4) Signaled event</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:01,350 INFO  [stdout] (Thread-69) i = 8</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:03,348 INFO  [stdout] (Thread-69) i = 9</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,361 INFO  [stdout] (Thread-69) ******** END SAVE-STATE SLEEP *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,361 INFO  [stdout] (Thread-69) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,361 INFO  [stdout] (Thread-69) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,361 INFO  [stdout] (Thread-69) ********** MESSAGE1 *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,376 INFO  [stdout] (Thread-69) Hello</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,376 INFO  [stdout] (Thread-69) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,392 INFO  [stdout] (Thread-69) ********** END1 *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,392 INFO  [stdout] (Thread-69) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,392 INFO  [stdout] (Thread-69) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,392 INFO  [stdout] (Thread-69) Hibernate: select WORKITEMINFO_ID_SEQ.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,392 INFO  [stdout] (Thread-69) ******** START SAVE-STATE SLEEP *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,392 INFO  [stdout] (Thread-69) ******** END SAVE-STATE *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:05,408 INFO  [stdout] (Thread-70) i = 0</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:07,405 INFO  [stdout] (Thread-70) i = 1</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:09,402 INFO  [stdout] (Thread-70) i = 2</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:11,400 INFO  [stdout] (Thread-70) i = 3</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:13,397 INFO  [stdout] (Thread-70) i = 4</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:15,395 INFO  [stdout] (Thread-70) i = 5</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:17,392 INFO  [stdout] (Thread-70) i = 6</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:19,390 INFO  [stdout] (Thread-70) i = 7</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:21,403 INFO  [stdout] (Thread-70) i = 8</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:23,400 INFO  [stdout] (Thread-70) i = 9</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,397 INFO  [stdout] (Thread-70) ******** END SAVE-STATE SLEEP *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,397 INFO  [stdout] (Thread-70) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,397 INFO  [stdout] (Thread-70) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,397 INFO  [stdout] (Thread-70) ********** MESSAGE2 *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,413 INFO  [stdout] (Thread-70) Hello World</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,413 INFO  [stdout] (Thread-70) ********** END2 *************</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,413 INFO  [stdout] (Thread-70) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,413 INFO  [stdout] (Thread-70) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,413 INFO  [stdout] (Thread-70) Hibernate: select hibernate_sequence.nextval from dual</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,429 INFO  [stdout] (Thread-70) Hibernate: select processins0_.id as id57_, processins0_.end_date as end2_57_, processins0_.processId as processId57_, processins0_.processInstanceId as processI4_57_, processins0_.start_date as start5_57_ from ProcessInstanceLog processins0_ where processins0_.processInstanceId=? and (processins0_.end_date is null)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>11:49:25,444 INFO  [stdout] (Thread-70) Hibernate: select processins0_.InstanceId as col_0_0_ from ProcessInstanceInfo processins0_ inner join EventTypes eventtypes1_ on processins0_.InstanceId=eventtypes1_.InstanceId where eventtypes1_.element=?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="text-decoration: underline;"><strong><br/></strong></span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/649177#649177">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>