<!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;">
Work Item not persisted
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/swaminathan.bhaskar">Swaminathan Bhaskar</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/760675#760675">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hello all;</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am using JPA persistence with jBPM 5.3 with MySQL database. I created a new domain specific task and a corresponding work item handler and expect the work item to be persisted along with the session info as well as process instance info when I kill the process at the point shown in red below ... but do not see that happening. Any ideas or thoughts</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here is the code for the work item handler</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">public class CustomWorkItemHandler implements WorkItemHandler {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    @Override</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    public void executeWorkItem(WorkItem item, WorkItemManager manager) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        System.out.printf("\n-----> Waiting in custom work item %s <ID:%d> for 60 secs\n", item.getName(), item.getId());</span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #ff0000;">        // Expect an entry in the DB for this work item when I kill the process<br/></span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        // Artificial wait</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        try {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            Thread.sleep(60000);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        catch (Exception ex) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        }</span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        System.out.printf("\n-----> Completing custom work item %s <ID:%d>\n", item.getName(), item.getId());</span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        manager.completeWorkItem(item.getId(), null);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    }</span></p><p style="padding-left: 30px;">    </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    @Override</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    public void abortWorkItem(WorkItem item, WorkItemManager manager) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">}</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here is the main process code:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">public class sample07 {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    public static final String BPMN_RESOURCE  = "sample07.bpmn";</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    public static final String BPM_PROCESS    = "sample07";</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    public static final String WORK_ITEM_NAME = "custom_work_item";</span></p><p style="padding-left: 30px;">    </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    public static final void main(String[] args) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        if (args.length != 2) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            System.out.printf("Usage: java %s <session-id> <process-id>\n", sample07.class.getName());</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            System.exit(1);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        }</span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        try {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            int sessionId = Integer.parseInt(args[0]);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            long processId = Long.parseLong(args[1]);</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            // Setup Datasource</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            PoolingDataSource mysqlDS = new PoolingDataSource();</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.setUniqueName("jdbc/MySQL-DS");</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.setClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource");</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.setMaxPoolSize(3);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.setAllowLocalTransactions(true);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.getDriverProperties().put("user", "mydbuser");</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.getDriverProperties().put("password", "mydbpass");</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.getDriverProperties().put("url", "jdbc:mysql://localhost:3306/mytestdb");</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            mysqlDS.init();</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            // Setup JPA persistence</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            EntityManagerFactory emf = Persistence.createEntityManagerFactory("org.jbpm.persistence.jpa");</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            Environment env = KnowledgeBaseFactory.newEnvironment();</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            env.set(EnvironmentName.TRANSACTION_MANAGER, TransactionManagerServices.getTransactionManager());</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            // Load and setup the BPM process</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            KnowledgeBuilder kbuilder = KnowledgeBuilderFactory.newKnowledgeBuilder();</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            kbuilder.add(ResourceFactory.newClassPathResource(BPMN_RESOURCE), ResourceType.BPMN2);</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            // Do we have any errors ?</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            if (kbuilder.hasErrors()) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                if (kbuilder.getErrors().size() > 0) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                    for (KnowledgeBuilderError error : kbuilder.getErrors()) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                        System.out.printf("Error building KnowledgeBase: %s\n", error.getMessage());</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                    }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                throw new RuntimeException("Error building KnowledgeBase");</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            }</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            KnowledgeBase kbase = kbuilder.newKnowledgeBase();</span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            StatefulKnowledgeSession ksession = null;</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            if (sessionId > 0) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ksession = JPAKnowledgeService.loadStatefulKnowledgeSession(sessionId, kbase, null, env);</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                JPAWorkingMemoryDbLogger logger = new JPAWorkingMemoryDbLogger(ksession);</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                // Register the custom work item handler</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ksession.getWorkItemManager().registerWorkItemHandler(WORK_ITEM_NAME, new CustomWorkItemHandler());</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ProcessInstance processInstance = ksession.getProcessInstance(processId);</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                // Did the process instance complete successfully ?</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                if (processInstance.getState() == ProcessInstance.STATE_COMPLETED) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                    System.out.printf("\n-----> Restarted business process [%s] successfully completed\n", processInstance.getProcessId());</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                }</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                logger.dispose();</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            else {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null, env);</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                JPAWorkingMemoryDbLogger logger = new JPAWorkingMemoryDbLogger(ksession);</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                // Register the custom work item handler</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ksession.getWorkItemManager().registerWorkItemHandler(WORK_ITEM_NAME, new CustomWorkItemHandler());</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                System.out.printf("\n-----> Session ID: %d\n", ksession.getId());</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                // Create the process instance</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ProcessInstance processInstance = ksession.createProcessInstance(BPM_PROCESS, null);</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                System.out.printf("\n-----> Starting new Business process %s <ID:%d>\n", processInstance.getProcessId(), processInstance.getId());</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                // Start the BPM process</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                ksession.startProcessInstance(processInstance.getId());</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                // Did the process instance complete successfully ?</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                if (processInstance.getState() == ProcessInstance.STATE_COMPLETED) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                    System.out.printf("\n-----> Business process %s <ID:%d> successfully completed\n", processInstance.getProcessId(), processInstance.getId());</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                }</span></p><p style="padding-left: 30px;">                </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">                logger.dispose();</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        catch (Exception ex) {</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            ex.printStackTrace(System.err);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">            System.exit(1);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        }</span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">        System.exit(0);</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">    }</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #0000ff;">}</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And here is the persistence.xml:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><persistence version="1.0"</span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><span>             xsi:schemaLocation="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><span>                                 </span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd</a></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><span>                                 </span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a><span> </span></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><span>                                 </span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/orm_1_0.xsd</a><span>"</span></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><span>             xmlns:orm="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a><span>"</span></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><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></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"><span>             xmlns="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a><span>"></span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">    <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA"></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <provider>org.hibernate.ejb.HibernatePersistence</provider></span></p><p style="padding-left: 30px;">               </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <jta-data-source>jdbc/MySQL-DS</jta-data-source></span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <mapping-file>META-INF/JBPMorm.xml</mapping-file></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file></span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <!-- Process Related --></span></p><p style="padding-left: 30px;">        </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <class>org.drools.persistence.info.SessionInfo</class></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <class>org.drools.persistence.info.WorkItemInfo</class></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class></span></p><p style="padding-left: 30px;">            </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <class>org.jbpm.process.audit.ProcessInstanceLog</class></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <class>org.jbpm.process.audit.NodeInstanceLog</class></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <class>org.jbpm.process.audit.VariableInstanceLog</class></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        <properties></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" /></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">            <property name="hibernate.connection.autocommit" value="false" /></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">            <property name="hibernate.max_fetch_depth" value="3"/></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">            <property name="hibernate.hbm2ddl.auto" value="update" /></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">            <property name="hibernate.show_sql" value="true" />    </span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">            <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup" /></span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">        </properties>        </span></p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;">      </persistence-unit></span></p><p style="padding-left: 30px;">    </p><p style="padding-left: 30px;"><span style="font-family: courier new,courier; font-size: 8pt; color: #008000;"></persistence></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any help appreciated.</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/760675#760675">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>