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

    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"


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

      </bean>

       

       


      <bean id="jbossUserTransaction"


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

       

       

       

       


      <bean id="transactionManager"


      class="org.springframework.transaction.jta.JtaTransactionManager">


      <property name="transactionManager">



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


      </property>


      <property name="userTransaction">



      <ref bean="jbossUserTransaction" />


      </property>

      </bean>

       

       

       

       

      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>

         

          <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"/>

          </bean>

       

       

      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 ...