如何在SpringMVC中配置Atomikos分布式事务
在SpringBoot中实现Atomikos,其中的配置全都是自动化配置。故此,想通过手动配置的方式运行相同的代码测试,经过测试,贴出成功通过的重要配置
maven依赖
<!-- mybatis核心包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${mybatis-spring.version}</version>
</dependency>
<!-- Atomikos 分布式事务 -->
<dependency>
<groupId>javax.transaction</groupId>
<artifactId>javax.transaction-api</artifactId>
<version>${javax.transaction.version}</version>
</dependency>
<dependency>
<groupId>com.atomikos</groupId>
<artifactId>transactions-jdbc</artifactId>
<version>${atomikos.version}</version>
</dependency>
<dependency>
<groupId>com.atomikos</groupId>
<artifactId>transactions-jta</artifactId>
<version>${atomikos.version}</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!-- tx + aop -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.2</version>
</dependency>
application.properties
## jta相关参数配置
# 必须配置唯一的资源名
spring.jta.atomikos.datasource.one.unique-resource-name=jta-personal
# 配置Druid的属性 https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
spring.jta.atomikos.datasource.one.xa-data-source-class-name=com.alibaba.druid.pool.xa.DruidXADataSource
spring.jta.atomikos.datasource.one.xa-properties.url=jdbc:mysql://localhost:3306/personal?characterEncoding=utf-8&useSSL=false&allowMultiQueries=true
spring.jta.atomikos.datasource.one.xa-properties.username=root
spring.jta.atomikos.datasource.one.xa-properties.password=123456
spring.jta.atomikos.datasource.one.xa-properties.filters=slf4j,stat,wall,config
#spring.jta.atomikos.datasource.one.xa-properties.connectionProperties=config.decrypt=true;config.decrypt.key=${druid.publickey}
spring.jta.atomikos.datasource.two.unique-resource-name=jta-book
spring.jta.atomikos.datasource.two.max-pool-size=8
spring.jta.atomikos.datasource.two.xa-data-source-class-name=com.alibaba.druid.pool.xa.DruidXADataSource
spring.jta.atomikos.datasource.two.xa-properties.url=jdbc:mysql://localhost:3306/secondary?characterEncoding=utf-8&useSSL=false&&allowMultiQueries=true
spring.jta.atomikos.datasource.two.xa-properties.username=root
spring.jta.atomikos.datasource.two.xa-properties.password=123456
spring.jta.atomikos.datasource.two.xa-properties.filters=slf4j,stat,wall,config
#spring.jta.atomikos.datasource.two.xa-properties.connectionProperties=config.decrypt=true;config.decrypt.key=${druid.publickey}
spring-context.xml
<?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:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<context:annotation-config/>
<context:component-scan base-package="com.example.atomikos.service"/>
<context:component-scan base-package="com.example.atomikos.dao"/>
<context:property-placeholder location="classpath:application.properties"/>
<!-- 配置Atomikos数据源与Druid的XA实现 -->
<bean id="oneDataSource" primary="true" class="com.atomikos.jdbc.AtomikosDataSourceBean" init-method="init" destroy-method="close">
<property name="uniqueResourceName" value="${spring.jta.atomikos.datasource.one.unique-resource-name}"/>
<property name="xaDataSourceClassName" value="${spring.jta.atomikos.datasource.one.xa-data-source-class-name}"/>
<property name="xaProperties">
<props>
<prop key="url">${spring.jta.atomikos.datasource.one.xa-properties.url}</prop>
<prop key="username">${spring.jta.atomikos.datasource.one.xa-properties.username}</prop>
<prop key="password">${spring.jta.atomikos.datasource.one.xa-properties.password}</prop>
<prop key="filters">${spring.jta.atomikos.datasource.one.xa-properties.filters}</prop>
<!--<prop key="connectionProperties">${spring.jta.atomikos.datasource.one.xa-properties.connectionProperties}</prop>-->
</props>
</property>
</bean>
<!-- 配置Mybatis的会话工厂 -->
<bean id="oneSqlSessionFactory" primary="true" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="oneDataSource" />
</bean>
<!-- 配置Mybatis(oneSqlSessionFactory)的包扫描 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.example.atomikos.dao.one" />
<property name="sqlSessionFactoryBeanName" value="oneSqlSessionFactory" />
</bean>
<bean id="twoDataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean" init-method="init" destroy-method="close">
<property name="uniqueResourceName" value="${spring.jta.atomikos.datasource.two.unique-resource-name}"/>
<property name="xaDataSourceClassName" value="${spring.jta.atomikos.datasource.two.xa-data-source-class-name}"/>
<property name="xaProperties">
<props>
<prop key="url">${spring.jta.atomikos.datasource.two.xa-properties.url}</prop>
<prop key="username">${spring.jta.atomikos.datasource.two.xa-properties.username}</prop>
<prop key="password">${spring.jta.atomikos.datasource.two.xa-properties.password}</prop>
<prop key="filters">${spring.jta.atomikos.datasource.two.xa-properties.filters}</prop>
<!--<prop key="connectionProperties">${spring.jta.atomikos.datasource.two.xa-properties.connectionProperties}</prop>-->
</props>
</property>
</bean>
<bean id="twoSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="twoDataSource" />
</bean>
<!-- 配置Mybatis(oneSqlSessionFactory)的包扫描 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.example.atomikos.dao.two" />
<property name="sqlSessionFactoryBeanName" value="twoSqlSessionFactory" />
</bean>
<import resource="spring-tx.xml"/>
<!--<import resource="spring-mvc.xml"/>-->
</beans>
spring-tx.xml
<?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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- -->
<bean id="atomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager">
<property name="forceShutdown" value="true"/>
</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="userTransaction" ref="atomikosUserTransaction"/>
<property name="transactionManager" ref="atomikosTransactionManager"/>
<property name="allowCustomIsolationLevels" value="true"/>
</bean>
<!-- 注解式事务 -->
<tx:annotation-driven/>
<!-- 配置事务传播特性 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<!--
name :绑定事务的方法名,可以使用通配符,可以配置多个。
propagation :传播行为
isolation :隔离级别
read-only :是否只读
timeout :超时信息
rollback-for:发生哪些异常回滚.
no-rollback-for:发生哪些异常不回滚.
-->
<!-- 哪些方法加事务 -->
<tx:method name="query*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="list*" propagation="SUPPORTS" read-only="true"/>
<tx:method name="save*" propagation="REQUIRED" rollback-for="Exception"/>
<tx:method name="update*" propagation="REQUIRED" rollback-for="Exception"/>
<tx:method name="delete*" propagation="REQUIRED" rollback-for="Exception"/>
<tx:method name="add*" propagation="REQUIRED" rollback-for="Exception"/>
</tx:attributes>
</tx:advice>
<!-- 声明式事务 -->
<aop:config proxy-target-class="true">
<!-- 注意:如果是自己编写的切面,使用<aop:aspect>标签,如果是系统制作的,使用<aop:advisor>标签。 -->
<aop:advisor advice-ref="txAdvice" pointcut="execution (* com.example.atomikos.service.*.*(..))" order="0"/>
<aop:advisor advice-ref="druid-stat-interceptor" pointcut-ref="druid-stat-pointcut" />
</aop:config>
<!-- 设置Druid监控切点 -->
<bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut"
scope="prototype">
<property name="patterns">
<list>
<value>com.example.atomikos.service.*</value>
</list>
</property>
</bean>
<bean id="druid-stat-interceptor" class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor" />
</beans>