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



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