spring 多数据源 JTA 事务

spring 多数据源 JTA 事务

注：此文引自http://www.javaeye.com/problems/15556

<jee:jndi-lookup id="dataSource" jndi-name="jdbc/DbPoolA"></jee:jndi-lookup> <jee:jndi-lookup id="dataSourceB" jndi-name="jdbc/DbPoolB"></jee:jndi-lookup> <bean id="localLogAdministrator" class="com.atomikos.icatch.admin.imp.LocalLogAdministrator"/> <bean id="userTransactionService" class="com.atomikos.icatch.config.UserTransactionServiceImp" init-method="init" destroy-method="shutdownForce"> <constructor-arg> <!-- IMPORTANT: specify all Atomikos properties here --> <props> <prop key="com.atomikos.icatch.service"> com.atomikos.icatch.standalone.UserTransactionServiceFactory </prop> </props> </constructor-arg> <property name="initialLogAdministrators"> <list> <ref bean="localLogAdministrator"/> </list> </property> </bean> <!-- Construct Atomikos UserTransactionManager, needed to configure Spring --> <bean id="AtomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager" init-method="init" destroy-method="close" depends-on="userTransactionService"> <!-- when close is called, should we force transactions to terminate or not? --> <property name="forceShutdown" value="false" /> </bean> <!-- Also use Atomikos UserTransactionImp, needed to configure Spring --> <bean id="AtomikosUserTransaction" class="com.atomikos.icatch.jta.UserTransactionImp" depends-on="userTransactionService"> <property name="transactionTimeout" value="300" /> </bean> <!-- Configure the Spring framework to use JTA transactions from Atomikos --> <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager" depends-on="userTransactionService"> <property name="transactionManager" ref="AtomikosTransactionManager" /> <property name="userTransaction" ref="AtomikosUserTransaction" /> </bean> <tx:annotation-driven transaction-manager="transactionManager" /> <!-- configure Hibernate to use the Atomikos JTA and datasource for transaction control --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="mappingResources"> <list> <value>com/starit/hibernate/dojo/User.hbm.xml</value> </list> </property> <!-- IMPORTANT: make sure to refer to an ATOMIKOS JTA/XA datasource for the sessionFactory! --> <property name="dataSource"><ref bean="dataSource"/></property> <!-- IMPORTANT: make sure to tell Hibernate to use JTA --> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="hibernate.connection.isolation">3</prop> <prop key="show_sql">true</prop> <prop key="format_sql">true</prop> <prop key="hibernate.current_session_context_class">jta</prop> <prop key="hibernate.transaction.factory_class"> org.hibernate.transaction.JTATransactionFactory </prop> <prop key="hibernate.transaction.manager_lookup_class"> com.atomikos.icatch.jta.hibernate3.TransactionManagerLookup </prop> </props> </property> </bean> <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory"><ref bean="sessionFactory"/></property> </bean> <bean id="sessionFactoryB" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="mappingResources"> <list> <value>com/starit/hibernate/dojo/User.hbm.xml</value> </list> </property> <!-- IMPORTANT: make sure to refer to an ATOMIKOS JTA/XA datasource for the sessionFactory! --> <property name="dataSource"><ref bean="dataSourceB"/></property> <!-- IMPORTANT: make sure to tell Hibernate to use JTA --> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="show_sql">true</prop> <prop key="format_sql">true</prop> <prop key="hibernate.connection.isolation">3</prop> <prop key="hibernate.current_session_context_class">jta</prop> <prop key="hibernate.transaction.factory_class"> org.hibernate.transaction.JTATransactionFactory </prop> <prop key="hibernate.transaction.manager_lookup_class"> com.atomikos.icatch.jta.hibernate3.TransactionManagerLookup </prop> </props> </property> </bean> <bean id="hibernateTemplateB" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory"><ref bean="sessionFactoryB"/></property> </bean> <bean id="UserDAOTarget" class="com.starit.hibernate.test.UserDAOImpl"> <property name="hibernateTemplate"> <ref bean="hibernateTemplate" /> </property> </bean> <bean id="UserDAOTargetB" class="com.starit.hibernate.test.UserDAOImpl"> <property name="hibernateTemplate"> <ref bean="hibernateTemplateB" /> </property> </bean> <bean id="UserDAO" class="com.starit.hibernate.test.UserBusinessServiceImpl" p:userDAO-ref="UserDAOTarget" p:userDAOB-ref="UserDAOTargetB"> </bean>

项目中要用到多个数据库，试验jta来保证事务。

事务是声明的

@Transactional(propagation=Propagation.REQUIRED,readOnly=false) public void insertUser(User user) { userDAO.addUser(user); user.setName("1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111" + "11111111111111111111111111111111111111111" + "1111111111111111111111111111111" + "111111111111111111111111111111111111"); //userDAO.addUser(user); //user.setName("1111"); userDAOB.addUser(user); } 

不知道为什么mysql不可以，Oracle可以。同样的代码不同的数据源。