<br><font size=2 face="Trebuchet MS">Hi,</font>
<br><font size=2 face="Trebuchet MS">I am trying to run the project given
at http://blog.athico.com/2009/09/drools-flow-variable-persistence.html.</font>
<br><font size=2 face="Trebuchet MS">I am successfully able to run the
same in default H2 database, but when I am trying to run the project, taking
Mysql database for persistence. I am not able to run the demo project as
i m getting this error.</font>
<br>
<br>
<br><font size=2 face="Courier New">ct 23, 2009 8:54:25 AM org.hibernate.impl.SessionFactoryObjectFactory
addInstance</font>
<br><font size=2 face="Courier New">INFO: Not binding factory to JNDI,
no JNDI name configured</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:25 AM org.hibernate.tool.hbm2ddl.SchemaExport
execute</font>
<br><font size=2 face="Courier New">INFO: Running hbm2ddl schema export</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:25 AM org.hibernate.tool.hbm2ddl.SchemaExport
execute</font>
<br><font size=2 face="Courier New">INFO: exporting generated schema to
database</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:26 AM org.hibernate.tool.hbm2ddl.SchemaExport
execute</font>
<br><font size=2 face="Courier New">INFO: schema export complete</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:26 AM bitronix.tm.BitronixTransactionManager
logVersion</font>
<br><font size=2 face="Courier New">INFO: Bitronix Transaction Manager
version 1.3.2</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:26 AM bitronix.tm.Configuration
buildServerIdArray</font>
<br><font size=2 face="Courier New">WARNING: cannot get this JVM unique
ID. Make sure it is configured and you only use ASCII characters. Will
use IP address instead (unsafe for production usage!).</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:26 AM bitronix.tm.Configuration
buildServerIdArray</font>
<br><font size=2 face="Courier New">INFO: JVM unique ID: <172.17.88.140></font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:27 AM bitronix.tm.journal.DiskJournal
open</font>
<br><font size=2 face="Courier New">WARNING: active log file is unclean,
previous server crash ?</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:27 AM bitronix.tm.recovery.Recoverer
run</font>
<br><font size=2 face="Courier New">INFO: recovery committed 0 dangling
transaction(s) and rolled back 0 aborted transaction(s) on 1 resource(s)
[jdbc/testDS1]</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:27 IST 2009 DEBUG:
Executing XA statement: XA START 0x3137322e31372e38382e313430000001247f6c815f00000000,0x3137322e31372e38382e313430000001247f6c81ad00000002,0x42746e78</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:27 IST 2009 DEBUG:
Executing XA statement: XA END 0x3137322e31372e38382e313430000001247f6c815f00000000,0x3137322e31372e38382e313430000001247f6c81ad00000002,0x42746e78</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:27 IST 2009 DEBUG:
Executing XA statement: XA COMMIT 0x3137322e31372e38382e313430000001247f6c815f00000000,0x3137322e31372e38382e313430000001247f6c81ad00000002,0x42746e78
ONE PHASE</font>
<br><font size=2 face="Courier New">Kession id is1</font>
<br><font size=2 face="Courier New">Session object isorg.drools.process.command.impl.CommandBasedStatefulKnowledgeSession@152b6f5</font>
<br><font size=2 face="Courier New">### Starting process ###</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:28 IST 2009 DEBUG:
Executing XA statement: XA START 0x3137322e31372e38382e313430000001247f6c81fb00000007,0x3137322e31372e38382e313430000001247f6c821b00000009,0x42746e78</font>
<br><font size=2 face="Courier New">x Ac = SomeString</font>
<br><font size=2 face="Courier New">y = VARIABLE: null - This is a test
Entity</font>
<br><font size=2 face="Courier New">z = Serializable Variable: This is
a test SerializableObject</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:28 IST 2009 DEBUG:
Executing XA statement: XA END 0x3137322e31372e38382e313430000001247f6c81fb00000007,0x3137322e31372e38382e313430000001247f6c821b00000009,0x42746e78</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:28 IST 2009 DEBUG:
Executing XA statement: XA COMMIT 0x3137322e31372e38382e313430000001247f6c81fb00000007,0x3137322e31372e38382e313430000001247f6c821b00000009,0x42746e78
ONE PHASE</font>
<br><font size=2 face="Courier New">### Retrieving process instance ###</font>
<br><font size=2 face="Courier New">Fri Oct 23 08:54:28 IST 2009 DEBUG:
Executing XA statement: XA START 0x3137322e31372e38382e313430000001247f6c82880000000e,0x3137322e31372e38382e313430000001247f6c828800000010,0x42746e78</font>
<br><font size=2 face="Courier New">AUTO</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:28 AM org.hibernate.util.JDBCExceptionReporter
logExceptions</font>
<br><font size=2 face="Courier New">WARNING: SQL Error: 0, SQLState: null</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:28 AM org.hibernate.util.JDBCExceptionReporter
logExceptions</font>
<br><font size=2 face="Courier New">SEVERE: error enlisting a JdbcConnectionHandle
of a JdbcPooledConnection from datasource jdbc/testDS1 in state ACCESSIBLE
wrapping com.mysql.jdbc.jdbc2.optional.MysqlXAConnection@126aaca on com.mysql.jdbc.jdbc2.optional.ConnectionWrapper@1a1b2f</font>
<br><font size=2 face="Courier New">Oct 23, 2009 8:54:28 AM org.hibernate.event.def.DefaultLoadEventListener
onLoad</font>
<br><font size=2 face="Courier New">INFO: Error performing load command</font>
<br><font size=2 color=#000080 face="Courier New"><u>org.hibernate.exception.GenericJDBCException</u></font><font size=2 color=red face="Courier New">:
could not load an entity: [org.drools.persistence.session.SessionInfo#1]</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(</font><font size=2 color=#000080 face="Courier New"><u>SQLStateConverter.java:126</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.exception.SQLStateConverter.convert(</font><font size=2 color=#000080 face="Courier New"><u>SQLStateConverter.java:114</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.exception.JDBCExceptionHelper.convert(</font><font size=2 color=#000080 face="Courier New"><u>JDBCExceptionHelper.java:66</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.Loader.loadEntity(</font><font size=2 color=#000080 face="Courier New"><u>Loader.java:1895</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.entity.AbstractEntityLoader.load(</font><font size=2 color=#000080 face="Courier New"><u>AbstractEntityLoader.java:71</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.entity.AbstractEntityLoader.load(</font><font size=2 color=#000080 face="Courier New"><u>AbstractEntityLoader.java:65</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.persister.entity.AbstractEntityPersister.load(</font><font size=2 color=#000080 face="Courier New"><u>AbstractEntityPersister.java:3072</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(</font><font size=2 color=#000080 face="Courier New"><u>DefaultLoadEventListener.java:434</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(</font><font size=2 color=#000080 face="Courier New"><u>DefaultLoadEventListener.java:415</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.event.def.DefaultLoadEventListener.load(</font><font size=2 color=#000080 face="Courier New"><u>DefaultLoadEventListener.java:165</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(</font><font size=2 color=#000080 face="Courier New"><u>DefaultLoadEventListener.java:223</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(</font><font size=2 color=#000080 face="Courier New"><u>DefaultLoadEventListener.java:126</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.impl.SessionImpl.fireLoad(</font><font size=2 color=#000080 face="Courier New"><u>SessionImpl.java:905</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.impl.SessionImpl.get(</font><font size=2 color=#000080 face="Courier New"><u>SessionImpl.java:842</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.impl.SessionImpl.get(</font><font size=2 color=#000080 face="Courier New"><u>SessionImpl.java:835</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.ejb.AbstractEntityManagerImpl.find(</font><font size=2 color=#000080 face="Courier New"><u>AbstractEntityManagerImpl.java:182</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.drools.persistence.session.SingleSessionCommandService.<init>(</font><font size=2 color=#000080 face="Courier New"><u>SingleSessionCommandService.java:153</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.drools.persistence.jpa.impl.JPAKnowledgeServiceProviderImpl.loadStatefulKnowledgeSession(</font><font size=2 color=#000080 face="Courier New"><u>JPAKnowledgeServiceProviderImpl.java:75</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(</font><font size=2 color=#000080 face="Courier New"><u>JPAKnowledgeService.java:102</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.plugtree.labs.VariablePersistenceStrategiesTest.testApp(</font><font size=2 color=#000080 face="Courier New"><u>VariablePersistenceStrategiesTest.java:158</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at sun.reflect.NativeMethodAccessorImpl.invoke0(</font><font size=2 color=#000080 face="Courier New"><u>Native
Method</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</font>
<br><font size=2 color=red face="Courier New">
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</font>
<br><font size=2 color=red face="Courier New">
at java.lang.reflect.Method.invoke(Unknown Source)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestCase.runTest(</font><font size=2 color=#000080 face="Courier New"><u>TestCase.java:154</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestCase.runBare(</font><font size=2 color=#000080 face="Courier New"><u>TestCase.java:127</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestResult$1.protect(</font><font size=2 color=#000080 face="Courier New"><u>TestResult.java:106</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestResult.runProtected(</font><font size=2 color=#000080 face="Courier New"><u>TestResult.java:124</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestResult.run(</font><font size=2 color=#000080 face="Courier New"><u>TestResult.java:109</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestCase.run(</font><font size=2 color=#000080 face="Courier New"><u>TestCase.java:118</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestSuite.runTest(</font><font size=2 color=#000080 face="Courier New"><u>TestSuite.java:208</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at junit.framework.TestSuite.run(</font><font size=2 color=#000080 face="Courier New"><u>TestSuite.java:203</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(</font><font size=2 color=#000080 face="Courier New"><u>JUnit3TestReference.java:130</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(</font><font size=2 color=#000080 face="Courier New"><u>TestExecution.java:38</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(</font><font size=2 color=#000080 face="Courier New"><u>RemoteTestRunner.java:460</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(</font><font size=2 color=#000080 face="Courier New"><u>RemoteTestRunner.java:673</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(</font><font size=2 color=#000080 face="Courier New"><u>RemoteTestRunner.java:386</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(</font><font size=2 color=#000080 face="Courier New"><u>RemoteTestRunner.java:196</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">Caused by: </font><font size=2 color=#000080 face="Courier New"><u>java.sql.SQLException</u></font><font size=2 color=red face="Courier New">:
error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource
jdbc/testDS1 in state ACCESSIBLE wrapping com.mysql.jdbc.jdbc2.optional.MysqlXAConnection@126aaca
on com.mysql.jdbc.jdbc2.optional.ConnectionWrapper@1a1b2f</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(</font><font size=2 color=#000080 face="Courier New"><u>JdbcConnectionHandle.java:61</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(</font><font size=2 color=#000080 face="Courier New"><u>JdbcConnectionHandle.java:200</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(</font><font size=2 color=#000080 face="Courier New"><u>AbstractBatcher.java:534</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(</font><font size=2 color=#000080 face="Courier New"><u>AbstractBatcher.java:452</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(</font><font size=2 color=#000080 face="Courier New"><u>AbstractBatcher.java:161</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.Loader.prepareQueryStatement(</font><font size=2 color=#000080 face="Courier New"><u>Loader.java:1573</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.Loader.doQuery(</font><font size=2 color=#000080 face="Courier New"><u>Loader.java:696</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(</font><font size=2 color=#000080 face="Courier New"><u>Loader.java:259</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.loader.Loader.loadEntity(</font><font size=2 color=#000080 face="Courier New"><u>Loader.java:1881</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
... 34 more</font>
<br><font size=2 color=red face="Courier New">Caused by: </font><font size=2 color=#000080 face="Courier New"><u>bitronix.tm.internal.BitronixSystemException</u></font><font size=2 color=red face="Courier New">:
cannot enlist an XAResourceHolderState with uniqueName=jdbc/testDS1 XAResource=com.mysql.jdbc.jdbc2.optional.MysqlXAConnection@126aaca
with XID a Bitronix XID [3137322E31372E38382E313430000001247F6C82880000000E
: 3137322E31372E38382E313430000001247F6C828800000010], error=XAER_OUTSIDE</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.BitronixTransaction.enlistResource(</font><font size=2 color=#000080 face="Courier New"><u>BitronixTransaction.java:83</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.resource.common.TransactionContextHelper.enlist(</font><font size=2 color=#000080 face="Courier New"><u>TransactionContextHelper.java:267</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(</font><font size=2 color=#000080 face="Courier New"><u>TransactionContextHelper.java:49</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(</font><font size=2 color=#000080 face="Courier New"><u>JdbcConnectionHandle.java:59</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
... 42 more</font>
<br><font size=2 color=red face="Courier New">Caused by: </font><font size=2 color=#000080 face="Courier New"><u>com.mysql.jdbc.jdbc2.optional.MysqlXAException</u></font><font size=2 color=red face="Courier New">:
XAER_OUTSIDE: Some work is done outside global transaction</font>
<br><font size=2 color=red face="Courier New">
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(</font><font size=2 color=#000080 face="Courier New"><u>MysqlXAConnection.java:562</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(</font><font size=2 color=#000080 face="Courier New"><u>MysqlXAConnection.java:545</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(</font><font size=2 color=#000080 face="Courier New"><u>MysqlXAConnection.java:485</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.internal.XAResourceHolderState.start(</font><font size=2 color=#000080 face="Courier New"><u>XAResourceHolderState.java:179</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.internal.XAResourceManager.enlist(</font><font size=2 color=#000080 face="Courier New"><u>XAResourceManager.java:89</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at bitronix.tm.BitronixTransaction.enlistResource(</font><font size=2 color=#000080 face="Courier New"><u>BitronixTransaction.java:76</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
... 45 more</font>
<br>
<br><font size=2 face="Trebuchet MS">When I searched for this exception
I got to know that : In MySql for XA transactions For </font><a href="http://dev.mysql.com/doc/refman/5.0/en/xa-statements.html"><font size=2 color=blue face="Trebuchet MS"><u>XA
START</u></font></a><font size=2 face="Trebuchet MS">, the JOIN and RESUME
clauses are not supported.</font>
<br><font size=2 face="Trebuchet MS">for more details http://dev.mysql.com/doc/refman/5.0/en/xa-restrictions.html.
</font>
<br><font size=2 face="Trebuchet MS">But in the class </font><font size=2 face="Courier New">org.drools.persistence.session</font><font size=2 face="Trebuchet MS">.</font><font size=2 face="Courier New">SingleSessionCommandService</font><font size=2 face="Trebuchet MS">.java
we are using code for join transaction</font>
<br><font size=2 color=#820040 face="Courier New"><b>
this</b></font><font size=2 face="Courier New">.</font><font size=2 color=#0021bf face="Courier New">em</font><font size=2 face="Courier New">.joinTransaction();</font>
<br><font size=2 face="Courier New">
</font><font size=2 color=#0021bf face="Courier New">sessionInfo</font><font size=2 face="Courier New">
= </font><font size=2 color=#820040 face="Courier New"><b>this</b></font><font size=2 face="Courier New">.</font><font size=2 color=#0021bf face="Courier New">em</font><font size=2 face="Courier New">.find(
SessionInfo.</font><font size=2 color=#820040 face="Courier New"><b>class</b></font><font size=2 face="Courier New">,
sessionId );</font>
<br>
<br><font size=2 face="Trebuchet MS">So please tell me how to get rid of
this exception. Also is there something which I have missed for configuation
with Mysql database.</font>
<br><font size=2 face="Trebuchet MS">Please help me to get resovle this
problem.</font>
<br>
<br><font size=2 face="Trebuchet MS">Thanks & Regards<br>
Pardeep Ruhil</font>
<BR>
______________________________________________________________________<BR>