spring atomikos 多数据源 分布式事务配置

spring-jdbc.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"
       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/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd">

    <context:annotation-config/>
    <context:component-scan base-package="com.deng" />

    <!-- 配置config的数据库 -->
    <bean id="dataSourceOne" class="com.deng.mmedia.jdbc.DataSourceFactory"
          destroy-method="close" scope="singleton" factory-method="getMysqlDataSource"/>

    <!-- spring和MyBatis完美整合-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >
        <property name="dataSource" ref="dataSourceOne" />
        <property name="configLocation"
                  value="classpath:META-INF/mybatis/sql-map-config.xml" />
        <property name="mapperLocations" value="classpath*:META-INF/mybatis/mapper/*Dao.xml" />
    </bean>

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" id="mapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <property name="annotationClass" value="org.springframework.stereotype.Repository"/>
        <property name="basePackage" value="com.deng.*.dao"/>
    </bean>

   <!-- <bean id="transactionManager"
          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSourceOne" />
    </bean>-->


    <!--数据源2-->
    <!-- 配置config的数据库 -->
    <bean id="dataSourceTwo" class="com.deng.mmedia.jdbc.DataSourceFactory2"
          destroy-method="close" scope="singleton" factory-method="getMysqlDataSource"/>
     <!--spring和MyBatis完美整合-->
    <bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean" >
        <property name="dataSource" ref="dataSourceTwo" />
        <property name="configLocation"
                  value="classpath:META-INF/mybatis/sql-map-config.xml" />
        <property name="mapperLocations" value="classpath*:META-INF/mybatis/mapper2/*Dao.xml" />
    </bean>

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" id="mapperScannerConfigurer2">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"/>
        <property name="annotationClass" value="org.springframework.stereotype.Repository"/>
        <property name="basePackage" value="com.deng.*.dao2"/>
    </bean>

    <!-- 分布式事务 -->
    <bean id="atomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager" init-method="init" destroy-method="close">
        <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>

    <tx:advice id="txAdvice">
        <tx:attributes>
            <tx:method name="*"  propagation="REQUIRED" rollback-for="java.lang.Throwable"/>
        </tx:attributes>
    </tx:advice>

    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* *..*ServiceImpl*.*(..))"/>
        <!--<aop:aspect id="aspect" ref="multipleDataSourceAspectAdvice">
            <aop:pointcut id="pointUserMgr" expression="execution(* com.deng.mmedia.dao.*(..))"/>
            <aop:around method="invoke"  pointcut-ref="pointUserMgr"/>
        </aop:aspect>-->
    </aop:config>
</beans>
DataSourceFactory
public class DataSourceFactory {
    /**
     * mysql 数据源
     */
    private static AtomikosDataSourceBean mysqlDataSource;

    public synchronized static AtomikosDataSourceBean getMysqlDataSource(){
        if (mysqlDataSource == null){
            mysqlDataSource = new AtomikosDataSourceBean();
            Properties xaProps = new Properties();
            xaProps.put("url", MYSQL_URL.getStringValue());
            xaProps.put("user", MYSQL_USERNAME.getStringValue());
            xaProps.put("password", MYSQL_PASSWORD.getStringValue());
            mysqlDataSource.setXaProperties(xaProps);
            mysqlDataSource.setUniqueResourceName("test1");
            mysqlDataSource.setXaDataSourceClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource");
            mysqlDataSource.setMinPoolSize(10);
            mysqlDataSource.setMaxPoolSize(100);
            mysqlDataSource.setBorrowConnectionTimeout(30);
            mysqlDataSource.setTestQuery("select 1");
            mysqlDataSource.setMaintenanceInterval(60);
        }
        return mysqlDataSource;
    }
}

DataSourceFactory2同上

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值