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