6 Replies Latest reply on Jun 6, 2012 11:37 AM by Jonathan Halliday

    StandAlone usecase - Jboss TM with tomcat Jdbc pool + Mysql - XA

    Sudheer Krishna Novice

      I have usecase to use the follwing


      MySQL XA

      JBOSS Transaction manager

      StandAlone Mode

      Tomcat jdbc pooling

      Spring transactions



      I have the transaction manager defined as explained in the examples


      <bean id="jbossTransactionManager"





      <bean id="jbossUserTransaction"

      class="com.arjuna.ats.internal.jta.transaction.arjunacore.UserTransactionImple" />





      <bean id="transactionManager"


      <property name="transactionManager">

      <ref bean="jbossTransactionManager"></ref>


      <property name="userTransaction">

      <ref bean="jbossUserTransaction" />







      My datasource definitions are as follows


          <bean id="mysqlXADataSource" class="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource">

                                    <property name="user" value="${user}" />

                                    <property name="password" value="${password}"/>

                                    <property name="url" value="${url}"/>



          <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.XADataSource">

                    <property name="dataSource" ref="mysqlXADataSource"/>

                    <property name="validationQuery" value="SELECT 1"/>

                    <property name="jmxEnabled" value="true"/>

                    <property name="maxActive" value="1000"/>

                    <property name="initialSize" value="250"/>

                    <property name="minIdle" value="10"/>




      Now database operatiosn do not seem to be part of transaction ?


      How do i connect between teh transtcion manager and datsource ?


      I have a stanalone application ...