Exception Using XA Transactions With JDBC Connector (Mule transaction is null, but enlist method is called)

• User impact:

  Medium
• Configuration:

  Hide

  <!-- XA Datasource Configuration -->

  <beans>
  <bean id="jotm" class="org.springframework.transaction.jta.JotmFactoryBean"/>
  <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
  <property name="userTransaction" ref="jotm"/>
  <property name="transactionManager" ref="jotm"/>
  </bean>

  <bean id="MAFXADataSource" class="org.mule.providers.jdbc.xa.DataSourceWrapper">
  <constructor-arg ref="xaDataSource"/>
  <constructor-arg ref="jotm"/>
  </bean>

  <bean id="xaDataSource" class="oracle.jdbc.xa.client.OracleXADataSource" destroy-method="shutdown">
  <property name="URL" value="jdbc:oracle:thin:@localhost:1521:Xe" />
  <property name="user" value="USERNAME"/>
  <property name="password" value="PASSWORD"/>
  </bean>
  </beans>

  <!-- Connector Configuration -->

  <!-- Configure the JDBC connector -->
  <connector name="jdbcConnector" className="org.mule.providers.jdbc.JdbcConnector">
  <properties>
  <container-property name="dataSource" reference="MAFXADataSource"/>
  <property name="pollingFrequency" value="10000"/>
  <map name="queries">
  <property name="getConsumerDemoRecs" value="SELECT CURRENCY FROM consumerdemo where MSGID='1'"/>
  </map>
  </properties>
  </connector>

  <!-- Endpoint Configuration -->

  <endpoint name="JDBC_GetConsumerDemoRecs" address="jdbc://getConsumerDemoRecs" transformers="MessageWrapper">
  <transaction action="ALWAYS_BEGIN" factory="org.mule.transaction.XaTransactionFactory"/>
  </endpoint>

  <!-- Transaction Manager Configuration -->
  <transaction-manager factory="org.mule.extras.jotm.JotmTransactionManagerFactory"/>

  <!-- Mule model Configuration -->

  <model name="Mule-app">

  <mule-descriptor name="XADB_Test_Component" implementation="xaDBTest">
  <inbound-router>
  <global-endpoint name="JDBC_GetConsumerDemoRecs"/>
  </inbound-router>
  </mule-descriptor>
  </model>

  Show

  <!-- XA Datasource Configuration --> <beans> <bean id="jotm" class="org.springframework.transaction.jta.JotmFactoryBean"/> <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"> <property name="userTransaction" ref="jotm"/> <property name="transactionManager" ref="jotm"/> </bean> <bean id="MAFXADataSource" class="org.mule.providers.jdbc.xa.DataSourceWrapper"> <constructor-arg ref="xaDataSource"/> <constructor-arg ref="jotm"/> </bean> <bean id="xaDataSource" class="oracle.jdbc.xa.client.OracleXADataSource" destroy-method="shutdown"> <property name="URL" value="jdbc:oracle:thin:@localhost:1521:Xe" /> <property name="user" value="USERNAME"/> <property name="password" value="PASSWORD"/> </bean> </beans> <!-- Connector Configuration --> <!-- Configure the JDBC connector --> <connector name="jdbcConnector" className="org.mule.providers.jdbc.JdbcConnector"> <properties> <container-property name="dataSource" reference="MAFXADataSource"/> <property name="pollingFrequency" value="10000"/> <map name="queries"> <property name="getConsumerDemoRecs" value="SELECT CURRENCY FROM consumerdemo where MSGID='1'"/> </map> </properties> </connector> <!-- Endpoint Configuration --> <endpoint name="JDBC_GetConsumerDemoRecs" address="jdbc://getConsumerDemoRecs" transformers="MessageWrapper"> <transaction action="ALWAYS_BEGIN" factory="org.mule.transaction.XaTransactionFactory"/> </endpoint> <!-- Transaction Manager Configuration --> <transaction-manager factory="org.mule.extras.jotm.JotmTransactionManagerFactory"/> <!-- Mule model Configuration --> <model name="Mule-app"> <mule-descriptor name="XADB_Test_Component" implementation="xaDBTest"> <inbound-router> <global-endpoint name="JDBC_GetConsumerDemoRecs"/> </inbound-router> </mule-descriptor> </model>
• Log Output:

  Hide

  2008-06-25 11:09:09,232 (MuleManager.java:900) INFO org.mule.MuleManager -
  **********************************************************************
  * Mule ESB and Integration Platform *
  * Version: 1.4.4 Build: 11748 *
  * MuleSource, Inc. *
  * For more information go to http://mule.mulesource.org *
  * *
  * Server started: 25/06/08 11:09 *
  * Server ID: MAF-config *
  * JDK: 1.6.0_04 (mixed mode, sharing) *
  * OS: Windows XP - Service Pack 2 (5.1, x86) *
  * Host: LGLAIB8HBBJ2J (169.24.29.131) *
  * *
  * Agents Running: *
  * JMX Agent *
  * Wrapper Manager: Mule PID #3920, Wrapper PID #3940 *
  **********************************************************************
  2008-06-25 11:09:09,232 (MuleServer.java:300) INFO org.mule.MuleServer - Mule Server initialized.
  2008-06-25 11:09:10,420 (AbstractExceptionListener.java:310) ERROR org.mule.impl.DefaultExceptionStrategy -
  ********************************************************************************
  Message : Mule transaction is null, but enlist method is called
  Type : org.mule.transaction.IllegalTransactionStateException
  Code : MULE_ERROR-91530
  JavaDoc : http://mule.mulesource.org/docs/apidocs/org/mule/transaction/IllegalTransactionStateException.html
  ********************************************************************************
  Exception stack is:
  1. Mule transaction is null, but enlist method is called (org.mule.transaction.IllegalTransactionStateException)
    org.mule.providers.jdbc.xa.ConnectionWrapper:463 (http://mule.mulesource.org/docs/apidocs/org/mule/transaction/IllegalTransactionStateException.html)
  ********************************************************************************
  Root Exception stack trace:
  org.mule.transaction.IllegalTransactionStateException: Mule transaction is null, but enlist method is called
          at org.mule.providers.jdbc.xa.ConnectionWrapper.enlist(ConnectionWrapper.java:463)
          at org.mule.providers.jdbc.xa.StatementInvocationHandler.invoke(StatementInvocationHandler.java:40)
          at $Proxy0.executeQuery(Unknown Source)
          at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:236)
          at org.mule.providers.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:154)
          at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:136)
          at org.mule.providers.PollingReceiverWorker.run(PollingReceiverWorker.java:47)
          at org.mule.impl.work.WorkerContext.run(WorkerContext.java:310)
          at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
          at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
          at java.lang.Thread.run(Thread.java:619)
  
  ********************************************************************************

  Show

  2008-06-25 11:09:09,232 (MuleManager.java:900) INFO org.mule.MuleManager - ********************************************************************** * Mule ESB and Integration Platform * * Version: 1.4.4 Build: 11748 * * MuleSource, Inc. * * For more information go to http://mule.mulesource.org * * * * Server started: 25/06/08 11:09 * * Server ID: MAF-config * * JDK: 1.6.0_04 (mixed mode, sharing) * * OS: Windows XP - Service Pack 2 (5.1, x86) * * Host: LGLAIB8HBBJ2J (169.24.29.131) * * * * Agents Running: * * JMX Agent * * Wrapper Manager: Mule PID #3920, Wrapper PID #3940 * ********************************************************************** 2008-06-25 11:09:09,232 (MuleServer.java:300) INFO org.mule.MuleServer - Mule Server initialized. 2008-06-25 11:09:10,420 (AbstractExceptionListener.java:310) ERROR org.mule.impl.DefaultExceptionStrategy - ******************************************************************************** Message : Mule transaction is null, but enlist method is called Type : org.mule.transaction.IllegalTransactionStateException Code : MULE_ERROR-91530 JavaDoc : http://mule.mulesource.org/docs/apidocs/org/mule/transaction/IllegalTransactionStateException.html ******************************************************************************** Exception stack is: 1. Mule transaction is null, but enlist method is called (org.mule.transaction.IllegalTransactionStateException)   org.mule.providers.jdbc.xa.ConnectionWrapper:463 (http://mule.mulesource.org/docs/apidocs/org/mule/transaction/IllegalTransactionStateException.html) ******************************************************************************** Root Exception stack trace: org.mule.transaction.IllegalTransactionStateException: Mule transaction is null, but enlist method is called         at org.mule.providers.jdbc.xa.ConnectionWrapper.enlist(ConnectionWrapper.java:463)         at org.mule.providers.jdbc.xa.StatementInvocationHandler.invoke(StatementInvocationHandler.java:40)         at $Proxy0.executeQuery(Unknown Source)         at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:236)         at org.mule.providers.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:154)         at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:136)         at org.mule.providers.PollingReceiverWorker.run(PollingReceiverWorker.java:47)         at org.mule.impl.work.WorkerContext.run(WorkerContext.java:310)         at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)         at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)         at java.lang.Thread.run(Thread.java:619) ********************************************************************************
• Similar Issues:

  None

As part of my application (running on Mule 1.4.4) I am trying to use the JDBC connector to read some information from the database and then continue to process that information all inside of an XA Transaction. Any time I try to use the JDBC Connector under an XA Transaction I get the "Mule transaction is null, but enlist method is called" error.

I created the example configuration above to try and isolate the error. The example configuration works on Mule 1.4.3 but fails with the "Mule transaction is null, but enlist method is called" error on 1.4.4.

Also, when I run the above on Mule 1.4.4 without transactions it works successfully.