[rules-users] Rule flow persistence MY SQL

Hi , Iam trying to persistence drools workflow using my sql as back end . But iam getting "Could not commit sessions" Iam trying with example code, drool.session.conf file contains drools.workItemHandlers = MyWorkItemHandlers.conf #drools.commandService = org.drools.persistence.session.SingleSessionCommandService #drools.processInstanceManagerFactory = org.drools.persistence.processinstance.JPAProcessInstanceManagerFactory #drools.workItemManagerFactory = org.drools.persistence.processinstance.JPAWorkItemManagerFactory #drools.processSignalManagerFactory = org.drools.persistence.processinstance.JPASignalManagerFactory Folllwoing are my rf file My RF file <?xml version="1.0" encoding="UTF-8"?<process xmlns="http://drools.org/drools-5.0/process" xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:schemaLocation="http://drools.org/drools-5.0/process drools-processes-5.0.xsd" type="RuleFlow" name="droolsflow" id="org.plugtree.labs.droolsflow" package-name="org.plugtree.labs" <header <imports <import name="org.kie.lab.variablepersistence.MyEntity" / <import name="org.kie.lab.variablepersistence.MyVariableSerializable" / </imports <variables <variable name="x" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </variable <variable name="y" <type name="org.drools.process.core.datatype.impl.type.ObjectDataType" className="org.kie.lab.variablepersistence.MyEntity" / </variable <variable name="z" <type name="org.drools.process.core.datatype.impl.type.ObjectDataType" className="org.kie.lab.variablepersistence.MyVariableSerializable" / </variable <variable name="a" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </variable <variable name="b" <type name="org.drools.process.core.datatype.impl.type.ObjectDataType" className="org.kie.lab.variablepersistence.MyEntity" / </variable <variable name="c" <type name="org.drools.process.core.datatype.impl.type.ObjectDataType" className="org.kie.lab.variablepersistence.MyVariableSerializable" / </variable </variables </header <nodes <humanTask id="4" name="Human Task" x="208" y="16" width="93" height="48" <work name="Human Task" <parameter name="ActorId" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Comment" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Content" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Priority" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Skippable" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="TaskName" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter </work </humanTask <humanTask id="9" name="Human Task" x="713" y="16" width="100" height="48" <work name="Human Task" <parameter name="ActorId" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Comment" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Content" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Priority" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Skippable" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="TaskName" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter </work </humanTask <actionNode id="8" name="Action" x="601" y="20" width="80" height="40" <action type="expression" dialect="java" >System.out.println("x = " + x); System.out.println("y = " + y); System.out.println("z = " + z); System.out.println("a = " + a); System.out.println("b = " + b); System.out.println("c = " + c); kcontext.setVariable("a", "Some changed String"); kcontext.setVariable("b", new MyEntity("This is a changed test Entity")); kcontext.setVariable("c", new MyVariableSerializable("This is a changed test SerializableObject"));</action </actionNode <actionNode id="6" name="Action" x="333" y="20" width="80" height="40" <action type="expression" dialect="java" >System.out.println("x = " + x); System.out.println("y = " + y); System.out.println("z = " + z); kcontext.setVariable("a", "Some new String"); kcontext.setVariable("b", new MyEntity("This is a new test Entity")); kcontext.setVariable("c", new MyVariableSerializable("This is a new test SerializableObject"));</action </actionNode <start id="1" name="Start" x="16" y="16" width="48" height="48" / <end id="3" name="End" x="957" y="16" width="48" height="48" / <actionNode id="10" name="Action" x="845" y="16" width="80" height="48" <action type="expression" dialect="java" >System.out.println("x = " + x); System.out.println("y = " + y); System.out.println("z = " + z); System.out.println("a = " + a); System.out.println("b = " + b); System.out.println("c = " + c);</action </actionNode <humanTask id="7" name="Human Task" x="445" y="20" width="124" height="40" <work name="Human Task" <parameter name="ActorId" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Comment" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Content" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Priority" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="Skippable" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter <parameter name="TaskName" <type name="org.drools.process.core.datatype.impl.type.StringDataType" / </parameter </work </humanTask <actionNode id="5" name="Action" x="96" y="20" width="80" height="40" <action type="expression" dialect="java" >System.out.println("x = " + x); System.out.println("y = " + y); System.out.println("z = " + z);</action </actionNode </nodes <connections <connection from="5" to="4" / <connection from="8" to="9" / <connection from="7" to="8" / <connection from="4" to="6" / <connection from="10" to="3" / <connection from="9" to="10" / <connection from="6" to="7" / <connection from="1" to="5" / </connections </processpersistence.xml <?xml version="1.0" encoding="UTF-8"?<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" <persistence-unit name="org.drools.persistence.jpa" transaction-type="JTA" <provider>org.hibernate.ejb.HibernatePersistence</provider <jta-data-source>jdbc/testDS1</jta-data-source <class>org.drools.persistence.session.SessionInfo</class <class>org.drools.persistence.processinstance.ProcessInstanceInfo</class <class>org.drools.persistence.processinstance.WorkItemInfo</class <class>org.drools.persistence.processinstance.variabletypes.VariableInstanceInfo</class <class>org.drools.persistence.processinstance.variabletypes.JPAPersistedVariable</class <class>org.drools.persistence.processinstance.variabletypes.SerializablePersistedVariable</class <class>org.kie.lab.variablepersistence.MyEntity</class <class>org.kie.lab.variablepersistence.StringPersistedVariable</class <class>org.kie.lab.variablepersistence.MyVariableSerializable</class <properties <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/ <property name="hibernate.hbm2ddl.auto" value="create-drop"/ <property name="hibernate.show_sql" value="false"/ <property name="hibernate.connection.autocommit" value="false"/ <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup"/ </properties </persistence-unit</persistence Information in this e-mail is intended solely for the person(s) to whom it is addressed and may contain confidential information. If you are not the intended recipient, please notify the sender and delete this e-mail message and any other record of it from your system immediately. You should not disclose or disseminate the information to any person, use it for any purpose or store or copy the information in any form or manner.