spring+mybatis+atomikos实现分布式事物管理

spring版本4.3.10,mybatis版本3.2.0,atomikos版本4.0.4,整合atomikos,需要额外引入以下两个jar包

<dependency><groupId>com.atomikos</groupId><artifactId>transactions-jdbc</artifactId><version>4.0.4</version></dependency><dependency><groupId>javax.transaction</groupId><artifactId>jta</artifactId><version>1.1</version></dependency>

配置文件定义:

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jee="http://www.springframework.org/schema/jee"xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p"xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/aop                      http://www.springframework.org/schema/aop/spring-aop.xsd "default-lazy-init="true"><context:component-scan base-package="com.zhitengda"><context:exclude-filter type="annotation"expression="org.springframework.stereotype.Controller" /></context:component-scan><bean id="abstractXADataSource" class="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean"init-method="init" destroy-method="close" abstract="true"><property name="xaDataSourceClassName" value="oracle.jdbc.OracleDriver" /><property name="minPoolSize" value="10" /><property name="maxPoolSize" value="30" /><property name="borrowConnectionTimeout" value="60" /><property name="reapTimeout" value="20" /><!-- 最大空闲时间 --><property name="maxIdleTime" value="60" /><property name="maintenanceInterval" value="60" /><property name="loginTimeout" value="60" /><property name="testQuery"><value>select 1</value></property></bean><bean id="qadataSource" class="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean"><!-- value只要两个数据源不同就行，随便取名 --><property name="poolSize" value="10" /><property name="uniqueResourceName" value="qa" /><property name="driverClassName"><value>oracle.jdbc.OracleDriver</value></property><property name="url"><value>jdbc:oracle:thin:@127.0.0.1:1521:orcl</value></property><property name="user"><value>root</value></property><property name="password"><value>root</value></property></bean><bean id="devdataSource" class="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean"><!-- value只要两个数据源不同就行，随便取名 --><property name="uniqueResourceName" value="dev" /><property name="poolSize" value="10" /><property name="driverClassName"><value>oracle.jdbc.OracleDriver</value></property>
<property name="url"><value>jdbc:oracle:thin:@127.0.0.1:1521:orcl</value></property><property name="user"><value>root</value></property><property name="password"><value>root</value></property>

</bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="qadataSource" /><property name="mapperLocations"value="classpath:com/zhitengda/*/eneity/sqlmap/*.xml" /><property name="configLocation" value="classpath:mybatis/mapper-config2.xml" /></bean><!-- 采用spring与mybatis整合的第一种方法 --><bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate"><constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg></bean><bean id="mainSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="configLocation" value="classpath:/mybatis/mapper-config.xml"></property><property name="dataSource" ref="devdataSource" /><property name="mapperLocations"value="classpath:com/zhitengda/*/eneity/sqlmap/*.xml" /></bean><!-- 采用spring与mybatis整合的第一种方法 --><bean id="mainSqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate"><constructor-arg index="0" ref="mainSqlSessionFactory" /></bean><bean id="atomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager"init-method="init" destroy-method="close"><property name="forceShutdown"><value>true</value></property></bean><bean id="atomikosUserTransaction" class="com.atomikos.icatch.jta.UserTransactionImp"><property name="transactionTimeout" value="300" /></bean><bean id="transactionManager"class="org.springframework.transaction.jta.JtaTransactionManager"><property name="transactionManager"><ref bean="atomikosTransactionManager" /></property><property name="userTransaction"><ref bean="atomikosUserTransaction" /></property><!-- 必须设置，否则程序出现异常 JtaTransactionManager does not support custom isolation levels by default --><property name="allowCustomIsolationLevels" value="true" /></bean><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><!-- REQUIRED: 第一种事务声明方式，需要事务 SUPPORTS：第四种声明方式，不需要事务 Service层方法必须严格按照下面的规范命名 --><tx:method name="save*" propagation="REQUIRED" /><tx:method name="add*" propagation="REQUIRED" /><tx:method name="create*" propagation="REQUIRED" /><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="merge*" propagation="REQUIRED" /><tx:method name="del*" propagation="REQUIRED" /><tx:method name="remove*" propagation="REQUIRED" /><tx:method name="put*" propagation="REQUIRED" /><tx:method name="get*" propagation="SUPPORTS" read-only="true" /><tx:method name="count*" propagation="SUPPORTS" read-only="true" /><tx:method name="find*" propagation="SUPPORTS" read-only="true" /><tx:method name="list*" propagation="SUPPORTS" read-only="true" /><tx:method name="*" propagation="SUPPORTS" read-only="true" /></tx:attributes></tx:advice><aop:config><aop:pointcut id="txPointcut"expression="execution(* com.zhitengda.*.service.impl..*.*(..))" /><aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut" /></aop:config><!-- 事务管理结束 --></beans>
对比之前使用的配置单数据源的配置方式,只是改变了数据源和管理事物的实例.