spring 事物控制---多数据源与 atomikos 分布式事务配置(接之前未完成的部分)

最新推荐文章于 2021-09-26 09:24:44 发布

云水天堂

最新推荐文章于 2021-09-26 09:24:44 发布

阅读量2.8k

点赞数

分类专栏： java 文章标签：分布式事务

本文链接：https://blog.csdn.net/u013561386/article/details/51821699

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

接上一篇
说明：解决了多个数据源的数据同步问题（例如：在一个事物里add操作A库的a表,同时add操作B库b表，如果B库连接中断或者因为别的异常造成b表写入失败，希望a表回滚）需要引入相关jar包。

1.pom.xml(需要新的jar包，就不一一列举了)

<!-- https://mvnrepository.com/artifact/com.atomikos/transactions-jdbc -->
    <dependency>
        <groupId>com.atomikos</groupId>
        <artifactId>transactions-jdbc</artifactId>
        <version>4.0.2</version>
    </dependency>
        <!-- https://mvnrepository.com/artifact/com.atomikos/transactions-jta -->
    <dependency>
        <groupId>com.atomikos</groupId>
        <artifactId>transactions-jta</artifactId>
        <version>4.0.2</version>
    </dependency>
        <!-- https://mvnrepository.com/artifact/com.atomikos/transactions-api -->
    <dependency>
        <groupId>com.atomikos</groupId>
        <artifactId>transactions-api</artifactId>
        <version>4.0.2</version>
    </dependency>
        <!-- https://mvnrepository.com/artifact/com.atomikos/transactions -->
    <dependency>
        <groupId>com.atomikos</groupId>
        <artifactId>transactions</artifactId>
        <version>4.0.2</version>
    </dependency>
        <!-- https://mvnrepository.com/artifact/com.atomikos/atomikos-util -->
    <dependency>
        <groupId>com.atomikos</groupId>
        <artifactId>atomikos-util</artifactId>
        <version>4.0.2</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/javax.transaction/jta -->
    <dependency>
        <groupId>javax.transaction</groupId>
        <artifactId>jta</artifactId>
        <version>1.1</version>
    </dependency>

2.spring-mybatis.xml改动（主要是数据源和事物部分的改动）
mysql
name=”xaDataSourceClassName” value=”com.mysql.jdbc.jdbc2.optional.MysqlXADataSource”
oracle数据库
name=”xaDataSourceClassName” value=”com.sybase.jdbc3.jdbc.SybXADataSource”

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/beans  
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd  
                        http://www.springframework.org/schema/tx 
                        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
                        http://www.springframework.org/schema/context  
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd  
                        http://www.springframework.org/schema/mvc  
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
                        http://www.springframework.org/schema/aop 
                        http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
    <!-- 自动扫描 -->
    <context:component-scan base-package="com" />
    <!-- 引入配置文件 -->
    <bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties" />
    </bean>

    <!-- test -->
    <!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${driver}" />
        <property name="url" value="${url}" />
        <property name="username" value="${username}" />
        <property name="password" value="${password}" />
        初始化连接大小
        <property name="initialSize" value="${initialSize}"></property>
        连接池最大数量
        <property name="maxActive" value="${maxActive}"></property>
        连接池最大空闲
        <property name="maxIdle" value="${maxIdle}"></property>
        连接池最小空闲
        <property name="minIdle" value="${minIdle}"></property>
        获取连接最大等待时间
        <property name="maxWait" value="${maxWait}"></property>
    </bean> -->

    <!-- XA方式 test-->
<bean id="dataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean">
    <property name="uniqueResourceName" value="test"/>
    <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"/>
    <property name="xaProperties">
        <props>
            <prop key="url">${url}</prop>
            <prop key="user">${username}</prop>
            <prop key="password">${password}</prop>
        </props>
    </property>
    <property name="minPoolSize" value="10" />
    <property name="maxPoolSize" value="100" />
    <property name="borrowConnectionTimeout" value="30" />
    <property name="testQuery" value="select 1" />
    <property name="maintenanceInterval" value="60" />
</bean>
    <!-- soringmvc -->
    <!-- <bean id="dataSource2" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${driver}" />
        <property name="url" value="${url2}" />
        <property name="username" value="${username2}" />
        <property name="password" value="${password2}" />
        初始化连接大小
        <property name="initialSize" value="${initialSize}"></property>
        连接池最大数量
        <property name="maxActive" value="${maxActive}"></property>
        连接池最大空闲
        <property name="maxIdle" value="${maxIdle}"></property>
        连接池最小空闲
        <property name="minIdle" value="${minIdle}"></property>
        获取连接最大等待时间
        <property name="maxWait" value="${maxWait}"></property>
    </bean> -->
    <!-- XA方式 soringmvc-->
    <bean id="dataSource2" class="com.atomikos.jdbc.AtomikosDataSourceBean">
        <property name="uniqueResourceName" value="soringmvc"/>
        <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"/>
        <property name="xaProperties">
            <props>
                <prop key="url">${url2}</prop>
                <prop key="user">${username2}</prop>
                <prop key="password">${password2}</prop>
            </props>
        </property>
        <property name="minPoolSize" value="10" />
        <property name="maxPoolSize" value="100" />
        <property name="borrowConnectionTimeout" value="30" />
        <property name="testQuery" value="select 1" />
        <property name="maintenanceInterval" value="60" />
    </bean>

    <!--============== test 数据源1(ok)============== -->
    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:jdbcyw1-mybatis-config.xml"></property>
        <!-- 自动扫描mapping.xml文件 -->
        <!-- <property name="mapperLocations" value="classpath:com/jdbcyw1/*/*.xml"></property> -->
    </bean>

    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.jdbcyw1.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

    <!--==============  srpingmvc 数据源2(ok)============== -->
    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource2" />
        <!-- 自动扫描mapping.xml文件 -->
        <property name="mapperLocations" value="classpath:com/jdbcbase/*/*.xml"></property>
    </bean>
    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.jdbcbase.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"></property>
    </bean>

    <!--======事务(ok)====== -->
    <!-- 申明式食物配置 -->
    <!-- test库(事务管理)transaction manager, use JtaTransactionManager for global tx -->
    <!-- <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>
    srpingmvc 库
    <bean id="transactionManager2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource2" />
    </bean>
    注解方式配置事物
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" />
    注解方式配置事物
    <tx:annotation-driven transaction-manager="transactionManager2" proxy-target-class="true" /> -->


    <!-- 分布式事务 -->
    <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="transactionManager" ref="atomikosTransactionManager"/>
        <property name="userTransaction" ref="atomikosUserTransaction"/>
    </bean>
<!-- <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">  
    <property name="transactionManager">  
        <bean class="com.atomikos.icatch.jta.UserTransactionManager" init-method="init" destroy-method="close">  
            <property name="forceShutdown" value="true"/>  
        </bean>  
    </property>  
    <property name="userTransaction">  
        <bean class="com.atomikos.icatch.jta.UserTransactionImp"/>  
    </property>  
</bean> -->
    <tx:annotation-driven transaction-manager="transactionManager"/>



    <!-- =====AOP方式3human(存在问题测试中)===== -->
    <!-- 定义了bean被初始化之前和之后要执行的方法 -->
    <bean class="com.InitBean" />
    <!--避免IE执行AJAX时，返回JSON出现下载文件 -->
    <bean id="mappingJacksonHttpMessageConverter"
        class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
        <property name="supportedMediaTypes">
            <list>
                <value>text/html;charset=UTF-8</value>
            </list>
        </property>
    </bean>
    <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->
    <bean
        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
        <property name="messageConverters">
            <list>
                <ref bean="mappingJacksonHttpMessageConverter" />   <!-- JSON转换器 -->
            </list>
        </property>
    </bean>

     <!--配置拦截器, 多个拦截器,顺序执行 -->  
    <mvc:interceptors>    
        <mvc:interceptor>    
            <!-- 匹配的是url路径， 如果不配置或/**,将拦截所有的Controller -->  
            <mvc:mapping path="/" />  
            <mvc:mapping path="/user/**" />  
            <mvc:mapping path="/menu/getMenuList*" />
            <bean class="com.cn.interceptor.CommonInterceptor"></bean>    
        </mvc:interceptor>  
        <!-- 当设置多个拦截器时，先按顺序调用preHandle方法，然后逆序调用每个拦截器的postHandle和afterCompletion方法 -->  
    </mvc:interceptors>  
        <!-- 添加异常默认跳转页 -->
    <bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
        <property name="exceptionMappings">
            <props>
                <prop key="com.exception.SpringException">
                ExceptionPage
                </prop>
            </props>
        </property>
        <property name="defaultErrorView" value="error"/>
    </bean>

</beans>

3.新添加一个jta.propertis配置文件，与log4j配置文件同路径
com.atomikos.icatch.service=com.atomikos.icatch.standalone.UserTransactionServiceFactory
com.atomikos.icatch.log_base_name = jdbc
com.atomikos.icatch.tm_unique_name = com.atomikos.spring.jdbc.tm
com.atomikos.icatch.serializable_logging=false

改造完成，测试

1.在MenuController.java添加一个方法,完成多数据源数据add

@RequestMapping("/addUserAndMenu")
    @ResponseBody
    public int addUserAndMenu(){
        User user = new User();
        user.setName("test");
        user.setPwd("pwd的都");

        Menu menu = new Menu();
        menu.setMenuId("11111111111");
        menu.setMenuName("tests是");
        return menuService.addUserAndMenu(user,menu);
    }

2.对应MenuServiceImpl.java（注入另一个数据源的dao）

    @Resource
    private MenuDao menuDao;
    @Resource
    private UserDao userDao;

    @Override
    @Transactional
    public int addUserAndMenu(User user,Menu menu){
        //ApplicationContext ack2 = new ClassPathXmlApplicationContext("spring-mybatis.xml");
        //SqlSessionFactory sqlSessionFactory= (SqlSessionFactory) ack2.getBean("sqlSessionFactory");
        //SqlSession ss = sqlSessionFactory.openSession();
        //List<User> list = ss.selectList("queryUser");
        //ss.insert("addUser", user);
        //ss.commit();
        //ss.rollback();
        //上面代码可以把数据add到数据库，但是无法回滚，楼主也不明白，求大神解释
        System.out.println("atttttttttt");
        int flag = 0;
        flag += this.userDao.addUser(user);
        flag += this.menuDao.addMenu(menu);

        System.out.println(1/0);//模拟异常使数据回滚
        return flag;
    }

3.测试(成功，数据库无脏数据，控制台也看到了回滚记录)
这里写图片描述

云水天堂

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
spring 事物控制---多数据源与 atomikos 分布式事务配置(接之前未完成的部分)

解决在多个不同数据源中同时操作各自表时保证数据的完整性，用automikos分布式事务，例如操作A库表a,B库表b,如果b表操作失败，a,b 同时回滚
复制链接

扫一扫