<br><font size=2 face="Trebuchet MS">Hi Mauricio</font><tt><font size=2>,</font></tt>
<br><font size=2 face="Trebuchet MS">No I haven't change the Mysql driver
and neither in the pom.xml file.</font>
<br><font size=2 face="Trebuchet MS">Currently I am working on <b>MySql
5.0.9</b></font>
<br><font size=2 face="Trebuchet MS">and driver I am using is <b>mysql-connector-java-5.0.4-bin.</b></font>
<br>
<br><font size=2 face="Trebuchet MS">Can you tell me which version of Mysql
you are using and the name of the jar files you are using to run the project.</font>
<br><font size=2 face="Trebuchet MS">May there can be a problem in version
of some jar files I am using.</font>
<br>
<br><font size=2 face="Trebuchet MS">Jar files I am using to run the project
are : </font>
<br><font size=2 face="Trebuchet MS">1. javax.persistence.jar
</font>
<br><font size=2 face="Trebuchet MS">2. antlr-runtime.jar</font>
<br><font size=2 face="Trebuchet MS">3. drools-api.jar</font>
<br><font size=2 face="Trebuchet MS">4. drools-compiler.jar</font>
<br><font size=2 face="Trebuchet MS">5. drools-core.jar</font>
<br><font size=2 face="Trebuchet MS">6. drools-decisiontables.jar</font>
<br><font size=2 face="Trebuchet MS">7. drools-jsr94.jar</font>
<br><font size=2 face="Trebuchet MS">8. drools-templates.jar</font>
<br><font size=2 face="Trebuchet MS">9. joda-time.jar</font>
<br><font size=2 face="Trebuchet MS">10. jsr94.jar</font>
<br><font size=2 face="Trebuchet MS">11. jxl.jar"</font>
<br><font size=2 face="Trebuchet MS">12. mvel2.jar</font>
<br><font size=2 face="Trebuchet MS">13. org.eclipse.jdt.core_3.4.4.v_894_R34x.jar</font>
<br><font size=2 face="Trebuchet MS">14. xpp3.jar</font>
<br><font size=2 face="Trebuchet MS">15. xpp3_min.jar</font>
<br><font size=2 face="Trebuchet MS">16. xstream.jar</font>
<br><font size=2 face="Trebuchet MS">17. junitperf.jar</font>
<br><font size=2 face="Trebuchet MS">18.junit.jar"</font>
<br><font size=2 face="Trebuchet MS">19. btm-1.3.2.jar</font>
<br><font size=2 face="Trebuchet MS">20. drools-persistence.jar</font>
<br><font size=2 face="Trebuchet MS">21. log4j-1.2.15.jar</font>
<br><font size=2 face="Trebuchet MS">22. h2-1.0.77.jar"/></font>
<br><font size=2 face="Trebuchet MS">23. javassist.jar"/></font>
<br><font size=2 face="Trebuchet MS">24 hibernate-annotations-3.4.0.GA.jar</font>
<br><font size=2 face="Trebuchet MS">25. hibernate-entitymanager-3.4.0.GA.jar</font>
<br><font size=2 face="Trebuchet MS">26. dom4j-1.6.1.jar</font>
<br><font size=2 face="Trebuchet MS">27. hibernate-commons-annotations-3.1.0.GA.jar</font>
<br><font size=2 face="Trebuchet MS">28. commons-logging-1.0.4.jar</font>
<br><font size=2 face="Trebuchet MS">29. jta.jar</font>
<br><font size=2 face="Trebuchet MS">30. slf4j-jdk14-1.5.2.jar</font>
<br><font size=2 face="Trebuchet MS">31. slf4j-api-1.5.2.jar</font>
<br><font size=2 face="Trebuchet MS">32. hibernate-core-3.3.1.GA.jar</font>
<br><font size=2 face="Trebuchet MS">33. commons-collections-3.2.jar</font>
<br><font size=2 face="Trebuchet MS">34. antlr-2.7.5.jar</font>
<br><font size=2 face="Trebuchet MS">35. mysql-connector-java-5.0.4-bin.jar</font>
<br>
<br><font size=2 face="Trebuchet MS">Please tell me if I am using any wrong
version of jar files. Also if possible can you please mail me your configured
project with jar files as I need this demo project working urgently.</font>
<br>
<br><font size=2 face="Trebuchet MS">Thanks & Regards<br>
<br>
Pardeep Ruhil<br>
</font>
<br>
<br><tt><font size=2><br>
<br>
>Hmm.. that's weird.. I have it working here..<br>
>Did you change the MySQL Driver? or something in the pom.xml file?<br>
>with which version of MySQL are you working?<br>
<br>
<br>
2009/10/22 <Pardeep.Ruhil@lntinfotech.com><br>
<br>
>><br>
>> Hi,<br>
>> I am trying to run the project given at<br>
>> http://blog.athico.com/2009/09/drools-flow-variable-persistence.html.<br>
>> I am successfully able to run the same in default H2 database,
but when I<br>
>> am trying to run the project, taking Mysql database for persistence.
I am<br>
>> not able to run the demo project as i m getting this error.<br>
><br>
><br>
> ct 23, 2009 8:54:25 AM org.hibernate.impl.SessionFactoryObjectFactory<br>
> addInstance<br>
> INFO: Not binding factory to JNDI, no JNDI name configured<br>
> Oct 23, 2009 8:54:25 AM org.hibernate.tool.hbm2ddl.SchemaExport execute<br>
> INFO: Running hbm2ddl schema export<br>
> Oct 23, 2009 8:54:25 AM org.hibernate.tool.hbm2ddl.SchemaExport execute<br>
> INFO: exporting generated schema to database<br>
> Oct 23, 2009 8:54:26 AM org.hibernate.tool.hbm2ddl.SchemaExport execute<br>
> INFO: schema export complete<br>
> Oct 23, 2009 8:54:26 AM bitronix.tm.BitronixTransactionManager logVersion<br>
> INFO: Bitronix Transaction Manager version 1.3.2<br>
> Oct 23, 2009 8:54:26 AM bitronix.tm.Configuration buildServerIdArray<br>
> WARNING: cannot get this JVM unique ID. Make sure it is configured
and you<br>
> only use ASCII characters. Will use IP address instead (unsafe for<br>
> production usage!).<br>
> Oct 23, 2009 8:54:26 AM bitronix.tm.Configuration buildServerIdArray<br>
> INFO: JVM unique ID: <172.17.88.140><br>
> Oct 23, 2009 8:54:27 AM bitronix.tm.journal.DiskJournal open<br>
> WARNING: active log file is unclean, previous server crash ?<br>
> Oct 23, 2009 8:54:27 AM bitronix.tm.recovery.Recoverer run<br>
> INFO: recovery committed 0 dangling transaction(s) and rolled back
0<br>
> aborted transaction(s) on 1 resource(s) [jdbc/testDS1]<br>
> Fri Oct 23 08:54:27 IST 2009 DEBUG: Executing XA statement: XA START<br>
> 0x3137322e31372e38382e313430000001247f6c815f00000000,0x3137322e31372e38382e313430000001247f6c81ad00000002,0x42746e78<br>
> Fri Oct 23 08:54:27 IST 2009 DEBUG: Executing XA statement: XA END<br>
> 0x3137322e31372e38382e313430000001247f6c815f00000000,0x3137322e31372e38382e313430000001247f6c81ad00000002,0x42746e78<br>
> Fri Oct 23 08:54:27 IST 2009 DEBUG: Executing XA statement: XA COMMIT<br>
> 0x3137322e31372e38382e313430000001247f6c815f00000000,0x3137322e31372e38382e313430000001247f6c81ad00000002,0x42746e78<br>
> ONE PHASE<br>
> Kession id is1<br>
> Session object<br>
> isorg.drools.process.command.impl.CommandBasedStatefulKnowledgeSession@152b6f5<br>
> ### Starting process ###<br>
> Fri Oct 23 08:54:28 IST 2009 DEBUG: Executing XA statement: XA START<br>
> 0x3137322e31372e38382e313430000001247f6c81fb00000007,0x3137322e31372e38382e313430000001247f6c821b00000009,0x42746e78<br>
> x Ac = SomeString<br>
> y = VARIABLE: null - This is a test Entity<br>
> z = Serializable Variable: This is a test SerializableObject<br>
> Fri Oct 23 08:54:28 IST 2009 DEBUG: Executing XA statement: XA END<br>
> 0x3137322e31372e38382e313430000001247f6c81fb00000007,0x3137322e31372e38382e313430000001247f6c821b00000009,0x42746e78<br>
> Fri Oct 23 08:54:28 IST 2009 DEBUG: Executing XA statement: XA COMMIT<br>
> 0x3137322e31372e38382e313430000001247f6c81fb00000007,0x3137322e31372e38382e313430000001247f6c821b00000009,0x42746e78<br>
> ONE PHASE<br>
> ### Retrieving process instance ###<br>
> Fri Oct 23 08:54:28 IST 2009 DEBUG: Executing XA statement: XA START<br>
> 0x3137322e31372e38382e313430000001247f6c82880000000e,0x3137322e31372e38382e313430000001247f6c828800000010,0x42746e78<br>
> AUTO<br>
> Oct 23, 2009 8:54:28 AM org.hibernate.util.JDBCExceptionReporter<br>
> logExceptions<br>
> WARNING: SQL Error: 0, SQLState: null<br>
> Oct 23, 2009 8:54:28 AM org.hibernate.util.JDBCExceptionReporter<br>
> logExceptions<br>
> SEVERE: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection<br>
> from datasource jdbc/testDS1 in state ACCESSIBLE wrapping<br>
> com.mysql.jdbc.jdbc2.optional.MysqlXAConnection@126aaca on<br>
> com.mysql.jdbc.jdbc2.optional.ConnectionWrapper@1a1b2f<br>
> Oct 23, 2009 8:54:28 AM org.hibernate.event.def.DefaultLoadEventListener<br>
> onLoad<br>
> INFO: Error performing load command<br>
> *org.hibernate.exception.GenericJDBCException*: could not load an
entity:<br>
> [org.drools.persistence.session.SessionInfo#1]<br>
> at<br>
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(*<br>
> SQLStateConverter.java:126*)<br>
> at org.hibernate.exception.SQLStateConverter.convert(*<br>
> SQLStateConverter.java:114*)<br>
> at org.hibernate.exception.JDBCExceptionHelper.convert(*<br>
> JDBCExceptionHelper.java:66*)<br>
> at org.hibernate.loader.Loader.loadEntity(*Loader.java:1895*)<br>
> at org.hibernate.loader.entity.AbstractEntityLoader.load(*<br>
> AbstractEntityLoader.java:71*)<br>
> at org.hibernate.loader.entity.AbstractEntityLoader.load(*<br>
> AbstractEntityLoader.java:65*)<br>
> at org.hibernate.persister.entity.AbstractEntityPersister.load(*<br>
> AbstractEntityPersister.java:3072*)<br>
> at<br>
> org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(*<br>
> DefaultLoadEventListener.java:434*)<br>
> at org.hibernate.event.def.DefaultLoadEventListener.doLoad(*<br>
> DefaultLoadEventListener.java:415*)<br>
> at org.hibernate.event.def.DefaultLoadEventListener.load(*<br>
> DefaultLoadEventListener.java:165*)<br>
> at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(*<br>
> DefaultLoadEventListener.java:223*)<br>
> at org.hibernate.event.def.DefaultLoadEventListener.onLoad(*<br>
> DefaultLoadEventListener.java:126*)<br>
> at org.hibernate.impl.SessionImpl.fireLoad(*SessionImpl.java:905*)<br>
> at org.hibernate.impl.SessionImpl.get(*SessionImpl.java:842*)<br>
> at org.hibernate.impl.SessionImpl.get(*SessionImpl.java:835*)<br>
> at org.hibernate.ejb.AbstractEntityManagerImpl.find(*<br>
> AbstractEntityManagerImpl.java:182*)<br>
> at<br>
> org.drools.persistence.session.SingleSessionCommandService.<init>(*<br>
> SingleSessionCommandService.java:153*)<br>
> at<br>
> org.drools.persistence.jpa.impl.JPAKnowledgeServiceProviderImpl.loadStatefulKnowledgeSession(<br>
> *JPAKnowledgeServiceProviderImpl.java:75*)<br>
> at<br>
> org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(<br>
> *JPAKnowledgeService.java:102*)<br>
> at org.plugtree.labs.VariablePersistenceStrategiesTest.testApp(*<br>
> VariablePersistenceStrategiesTest.java:158*)<br>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(*Native
Method*)<br>
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)<br>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)<br>
> at java.lang.reflect.Method.invoke(Unknown
Source)<br>
> at junit.framework.TestCase.runTest(*TestCase.java:154*)<br>
> at junit.framework.TestCase.runBare(*TestCase.java:127*)<br>
> at junit.framework.TestResult$1.protect(*TestResult.java:106*)<br>
> at junit.framework.TestResult.runProtected(*TestResult.java:124*)<br>
> at junit.framework.TestResult.run(*TestResult.java:109*)<br>
> at junit.framework.TestCase.run(*TestCase.java:118*)<br>
> at junit.framework.TestSuite.runTest(*TestSuite.java:208*)<br>
> at junit.framework.TestSuite.run(*TestSuite.java:203*)<br>
> at<br>
> org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(*<br>
> JUnit3TestReference.java:130*)<br>
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(*<br>
> TestExecution.java:38*)<br>
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(<br>
> *RemoteTestRunner.java:460*)<br>
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(<br>
> *RemoteTestRunner.java:673*)<br>
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(*<br>
> RemoteTestRunner.java:386*)<br>
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(*<br>
> RemoteTestRunner.java:196*)<br>
> Caused by: *java.sql.SQLException*: error enlisting a JdbcConnectionHandle<br>
> of a JdbcPooledConnection from datasource jdbc/testDS1 in state ACCESSIBLE<br>
> wrapping com.mysql.jdbc.jdbc2.optional.MysqlXAConnection@126aaca on<br>
> com.mysql.jdbc.jdbc2.optional.ConnectionWrapper@1a1b2f<br>
> at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(*<br>
> JdbcConnectionHandle.java:61*)<br>
> at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(<br>
> *JdbcConnectionHandle.java:200*)<br>
> at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(*<br>
> AbstractBatcher.java:534*)<br>
> at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(*<br>
> AbstractBatcher.java:452*)<br>
> at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(*<br>
> AbstractBatcher.java:161*)<br>
> at org.hibernate.loader.Loader.prepareQueryStatement(*<br>
> Loader.java:1573*)<br>
> at org.hibernate.loader.Loader.doQuery(*Loader.java:696*)<br>
> at<br>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(*<br>
> Loader.java:259*)<br>
> at org.hibernate.loader.Loader.loadEntity(*Loader.java:1881*)<br>
> ... 34 more<br>
> Caused by: *bitronix.tm.internal.BitronixSystemException*: cannot
enlist<br>
> an XAResourceHolderState with uniqueName=jdbc/testDS1<br>
> XAResource=com.mysql.jdbc.jdbc2.optional.MysqlXAConnection@126aaca
with<br>
> XID a Bitronix XID [3137322E31372E38382E313430000001247F6C82880000000E
:<br>
> 3137322E31372E38382E313430000001247F6C828800000010], error=XAER_OUTSIDE<br>
> at bitronix.tm.BitronixTransaction.enlistResource(*<br>
> BitronixTransaction.java:83*)<br>
> at bitronix.tm.resource.common.TransactionContextHelper.enlist(*</font></tt>
<br><tt><font size=2>> TransactionContextHelper.java:267*)<br>
> at<br>
> bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(<br>
> *TransactionContextHelper.java:49*)<br>
> at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(*<br>
> JdbcConnectionHandle.java:59*)<br>
> ... 42 more<br>
> Caused by: *com.mysql.jdbc.jdbc2.optional.MysqlXAException*: XAER_OUTSIDE:<br>
> Some work is done outside global transaction<br>
> at<br>
> com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(<br>
> *MysqlXAConnection.java:562*)<br>
> at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(<br>
> *MysqlXAConnection.java:545*)<br>
> at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(*<br>
> MysqlXAConnection.java:485*)<br>
> at bitronix.tm.internal.XAResourceHolderState.start(*<br>
> XAResourceHolderState.java:179*)<br>
> at bitronix.tm.internal.XAResourceManager.enlist(*<br>
> XAResourceManager.java:89*)<br>
> at bitronix.tm.BitronixTransaction.enlistResource(*<br>
> BitronixTransaction.java:76*)<br>
> ... 45 more<br>
><br>
> When I searched for this exception I got to know that : In MySql for
XA<br>
> transactions For *XA START*<http://dev.mysql.com/doc/refman/5.0/en/xa-statements.html>,<br>
> the JOIN and RESUME clauses are not supported.<br>
> for more details<br>
> http://dev.mysql.com/doc/refman/5.0/en/xa-restrictions.html.<br>
> But in the class org.drools.persistence.session.<br>
> SingleSessionCommandService.java we are using code for join transaction<br>
> * this*.em.joinTransaction();<br>
> sessionInfo = *this*.em.find(
SessionInfo.*class*, sessionId<br>
> );<br>
><br>
> So please tell me how to get rid of this exception. Also is there
something<br>
> which I have missed for configuation with Mysql database.<br>
> Please help me to get resovle this problem.<br>
><br>
> Thanks & Regards<br>
> Pardeep Ruhil<br>
</font></tt>
<br>
<BR>
______________________________________________________________________<BR>