首页 > 代码库 > spring+springMVC+Mybatis架构下采用AbstractRoutingDataSource、atomikos、JTA实现多数据源灵活切换以及分布式事务管理
spring+springMVC+Mybatis架构下采用AbstractRoutingDataSource、atomikos、JTA实现多数据源灵活切换以及分布式事务管理
背景:
1、系统采用SSM架构、需要在10多个MYSQL数据库之间进行切换并对数据进行操作,上篇博文《springMVC+Mybatis(使用AbstractRoutingDataSource实现多数据源切换时)事务管理未生效的解决办法》
2、第一步先通过AbstractRoutingDataSource实现了多数据源的灵活切换,但是后来发现事务不起作用;
3、发现问题是因为重复扫描service包导致第二次扫入容器的BEAN没有纳入事务管理,因此在springMVC的配置文件中排除了对Service注解的扫描,防止重复扫描,事务生效了,测试又发现数据源不能成功切换了;
4、查阅资料发现是由于spring默认提供的事务管理DataSourceTransactionManager只能管理一个数据源的事务,因此考虑使用atomikos+JTA进行分布式事务管理
配置文件:
1、jdbc.properties
配置你需要连接的数据库资源
jdbc_zhs.driverClassName=com.mysql.jdbc.Driver jdbc_zhs.url.spider=jdbc:mysql://127.0.0.1:3306/fms?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_zhs.username=root jdbc_zhs.password=root jdbc_jcs.driverClassName=com.mysql.jdbc.Driver jdbc_jcs.url.spider=jdbc:mysql://127.0.0.1:3306/fms-jcs?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_jcs.username=root jdbc_jcs.password=root jdbc_hks.driverClassName=com.mysql.jdbc.Driver jdbc_hks.url.spider=jdbc:mysql://127.0.0.1:3306/fms-hks?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_hks.username=root jdbc_hks.password=root jdbc_xts.driverClassName=com.mysql.jdbc.Driver jdbc_xts.url.spider=jdbc:mysql://127.0.0.1:3306/fms-xts?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_xts.username=root jdbc_xts.password=root jdbc_xxgcs.driverClassName=com.mysql.jdbc.Driver jdbc_xxgcs.url.spider=jdbc:mysql://127.0.0.1:3306/fms-xxgcs?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_xxgcs.username=root jdbc_xxgcs.password=root jdbc_zdhs.driverClassName=com.mysql.jdbc.Driver jdbc_zdhs.url.spider=jdbc:mysql://127.0.0.1:3306/fms-zdhs?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_zdhs.username=root jdbc_zdhs.password=root jdbc_gfs.driverClassName=com.mysql.jdbc.Driver jdbc_gfs.url.spider=jdbc:mysql://127.0.0.1:3306/fms-gfs?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_gfs.username=root jdbc_gfs.password=root jdbc_kxs.driverClassName=com.mysql.jdbc.Driver jdbc_kxs.url.spider=jdbc:mysql://127.0.0.1:3306/fms-kxs?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_kxs.username=root jdbc_kxs.password=root jdbc_fyd.driverClassName=com.mysql.jdbc.Driver jdbc_fyd.url.spider=jdbc:mysql://127.0.0.1:3306/fms-fyd?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_fyd.username=root jdbc_fyd.password=root jdbc_ybj.driverClassName=com.mysql.jdbc.Driver jdbc_ybj.url.spider=jdbc:mysql://127.0.0.1:3306/fms-ybj?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_ybj.username=root jdbc_ybj.password=root jdbc_yzh.driverClassName=com.mysql.jdbc.Driver jdbc_yzh.url.spider=jdbc:mysql://127.0.0.1:3306/fms-yzh?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull jdbc_yzh.username=root jdbc_yzh.password=root
2、applicationContext-common.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/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"> <!-- 启动扫描 --> <context:component-scan base-package="com.fms;com.job;com.jmda;"> <!-- <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" /> --> </context:component-scan> <!-- 文件上传 --> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <property name="maxUploadSize" value="http://www.mamicode.com/10240000"/> <property name="maxInMemorySize" value="http://www.mamicode.com/10240000" /> </bean> <bean id="freemarkerConfig" class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer"> <property name="templateLoaderPaths"> <list> <value>/WEB-INF/pages/</value> <value>/WEB-INF/template/</value> <value>classpath:/jmda-ftl/</value> </list> </property> <property name="freemarkerSettings"> <props> <prop key="template_update_delay">0</prop> <prop key="default_encoding">UTF-8</prop> <prop key="number_format">0.##########</prop> <prop key="datetime_format">yyyy-MM-dd HH:mm:ss</prop> <prop key="classic_compatible">true</prop> <prop key="template_exception_handler">ignore</prop> </props> </property> </bean> <!-- 启用CGliB --> <aop:aspectj-autoproxy /> <!-- 配置c3p0数据源,项目中有代码需要C3P0数据源支持时额外配置,不需要可以不配置 --> <bean id="c3p0DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="jdbcUrl"> <value><![CDATA[jdbc:mysql://localhost:3306/fms-zhs?useUnicode=yes&characterEncoding=UTF8]]></value> </property> <property name="driverClass" value="http://www.mamicode.com/com.mysql.jdbc.Driver" /> <property name="user" value="http://www.mamicode.com/root" /> <property name="password" value="http://www.mamicode.com/root" /> <property name="maxPoolSize" value="http://www.mamicode.com/200" /> <property name="minPoolSize" value="http://www.mamicode.com/1" /> <property name="initialPoolSize" value="http://www.mamicode.com/1" /> <property name="maxIdleTime" value="http://www.mamicode.com/30" /> <property name="acquireIncrement" value="http://www.mamicode.com/5" /> <property name="maxStatements" value="http://www.mamicode.com/0" /> <property name="idleConnectionTestPeriod" value="http://www.mamicode.com/60" /> <property name="acquireRetryAttempts" value="http://www.mamicode.com/30" /> <property name="breakAfterAcquireFailure" value="http://www.mamicode.com/true" /> <property name="testConnectionOnCheckout" value="http://www.mamicode.com/false" /> </bean> <!-- 注入数据源连接配置文件 --> <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath*:/spring/jdbc.properties</value> </list> </property> </bean> <!-- 多个数据源的公用配置,方便下面直接引用 --> <bean id="abstractXADataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean" init-method="init" destroy-method="close" abstract="true"> <property name="xaDataSourceClassName" value="http://www.mamicode.com/com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"/> <property name="poolSize" value="http://www.mamicode.com/10" /> <property name="minPoolSize" value="http://www.mamicode.com/10"/> <property name="maxPoolSize" value="http://www.mamicode.com/30"/> <property name="borrowConnectionTimeout" value="http://www.mamicode.com/60"/> <property name="reapTimeout" value="http://www.mamicode.com/20"/> <!-- 最大空闲时间 --> <property name="maxIdleTime" value="http://www.mamicode.com/60"/> <property name="maintenanceInterval" value="http://www.mamicode.com/60" /> <property name="loginTimeout" value="http://www.mamicode.com/60"/> <property name="logWriter" value="http://www.mamicode.com/60"/> <property name="testQuery"> <value>select 1</value> </property> </bean> <!-- 下面是所有需要切换的数据源 --> <!-- 综合所数据源 --> <bean id="ds_zhs" parent="abstractXADataSource"> <!-- value只要多个XA数据源之间不重复就行,随便取名 --> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/zhs" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_zhs.url.spider}</prop> <prop key="user">${jdbc_zhs.username}</prop> <prop key="password">${jdbc_zhs.password}</prop> </props> </property> </bean> <!-- 舰船所数据源--> <bean id="ds_jcs" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/jcs" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_jcs.url.spider}</prop> <prop key="user">${jdbc_jcs.username}</prop> <prop key="password">${jdbc_jcs.password}</prop> </props> </property> </bean> <!-- 航空所数据源--> <bean id="ds_hks" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/hks" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_hks.url.spider}</prop> <prop key="user">${jdbc_hks.username}</prop> <prop key="password">${jdbc_hks.password}</prop> </props> </property> </bean> <!-- 系统所数据源--> <bean id="ds_xts" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/xts" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_xts.url.spider}</prop> <prop key="user">${jdbc_xts.username}</prop> <prop key="password">${jdbc_xts.password}</prop> </props> </property> </bean> <!-- 信息工程所数据源--> <bean id="ds_xxgcs" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/xxgcs" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_xxgcs.url.spider}</prop> <prop key="user">${jdbc_xxgcs.username}</prop> <prop key="password">${jdbc_xxgcs.password}</prop> </props> </property> </bean> <!-- 自动化所数据源--> <bean id="ds_zdhs" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/zdhs" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_zdhs.url.spider}</prop> <prop key="user">${jdbc_zdhs.username}</prop> <prop key="password">${jdbc_zdhs.password}</prop> </props> </property> </bean> <!-- 规范所数据源--> <bean id="ds_gfs" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/gfs" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_gfs.url.spider}</prop> <prop key="user">${jdbc_gfs.username}</prop> <prop key="password">${jdbc_gfs.password}</prop> </props> </property> </bean> <!-- 科信所数据源--> <bean id="ds_kxs" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/kxs" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_kxs.url.spider}</prop> <prop key="user">${jdbc_kxs.username}</prop> <prop key="password">${jdbc_kxs.password}</prop> </props> </property> </bean> <!-- 翻译队数据源--> <bean id="ds_fyd" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/fyd" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_fyd.url.spider}</prop> <prop key="user">${jdbc_fyd.username}</prop> <prop key="password">${jdbc_fyd.password}</prop> </props> </property> </bean> <!-- 院本级数据源--> <bean id="ds_ybj" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/ybj" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_ybj.url.spider}</prop> <prop key="user">${jdbc_ybj.username}</prop> <prop key="password">${jdbc_ybj.password}</prop> </props> </property> </bean> <!-- 院综合系统数据源--> <bean id="ds_yzh" parent="abstractXADataSource"> <property name="uniqueResourceName" value="http://www.mamicode.com/mysql/yzh" /> <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" /> <property name="xaProperties"> <props> <prop key="URL">${jdbc_yzh.url.spider}</prop> <prop key="user">${jdbc_yzh.username}</prop> <prop key="password">${jdbc_yzh.password}</prop> </props> </property> </bean> <!-- 配置多数据源 MultipleDataSource--> <bean name="dynamicDatasource" class="com.fms.common.datasource.MultipleDataSource"> <property name="targetDataSources"> <map> <!-- key和value-ref尽量保持一致,我在测试的时候因为名称不一致一致报错, 找了好久都没找到原因,最后统一了名称终于成功启动了 --> <entry key="ds_zhs" value-ref="ds_zhs"/> <entry key="ds_jcs" value-ref="ds_jcs"/> <entry key="ds_hks" value-ref="ds_hks"/> <entry key="ds_xts" value-ref="ds_xts"/> <entry key="ds_xxgcs" value-ref="ds_xxgcs"/> <entry key="ds_zdhs" value-ref="ds_zdhs"/> <entry key="ds_gfs" value-ref="ds_gfs"/> <entry key="ds_kxs" value-ref="ds_kxs"/> <entry key="ds_fyd" value-ref="ds_fyd"/> <entry key="ds_ybj" value-ref="ds_ybj"/> <entry key="ds_yzh" value-ref="ds_yzh"/> </map> </property> <!-- 指定一个默认的数据源,即在不需要切换数据源时,本地系统默认使用的数据源 --> <property name="defaultTargetDataSource" ref="ds_zhs" /> </bean> <!-- 下面开始配置SqlSessionFactoryBean,有多少个数据源需要支持就陪多少个 --> <bean id="sqlSessionFactory_zhs" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- dataSource的ref对应数据源的id --> <property name="dataSource" ref="ds_zhs"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_jcs" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_jcs"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_hks" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_hks"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_xts" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_xts"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_xxgcs" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_xxgcs"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_zdhs" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_zdhs"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_gfs" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_gfs"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_kxs" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_kxs"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_fyd" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_fyd"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_ybj" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_ybj"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <bean id="sqlSessionFactory_yzh" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="ds_yzh"/> <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis.xml" /> <property name="mapperLocations"> <list> <value>classpath*:/com/fms/**/dao/*Mapper.xml</value> <value>classpath*:/com/fms/**/dao/*DAO.xml</value> </list> </property> </bean> <!-- 配置自定义的SqlSessionTemplate模板,注入相关配置 --> <bean id="sqlSessionTemplate" class="com.fms.common.datasource.CustomSqlSessionTemplate" scope="prototype"> <!-- 构造注入参数指定本地默认数据源对应的SqlSessionFactoryBean --> <constructor-arg ref="sqlSessionFactory_zhs" /> <property name="targetSqlSessionFactorys"> <map> <!-- key和上文配置的数据源的id值尽量保持一致,我在测试的时候因为名称不一致一致报错, 找了好久都没找到原因,最后统一了名称终于成功启动了 --> <entry value-ref="sqlSessionFactory_zhs" key="ds_zhs"/> <entry value-ref="sqlSessionFactory_jcs" key="ds_jcs"/> <entry value-ref="sqlSessionFactory_hks" key="ds_hks"/> <entry value-ref="sqlSessionFactory_xts" key="ds_xts"/> <entry value-ref="sqlSessionFactory_xxgcs" key="ds_xxgcs"/> <entry value-ref="sqlSessionFactory_zdhs" key="ds_zdhs"/> <entry value-ref="sqlSessionFactory_gfs" key="ds_gfs"/> <entry value-ref="sqlSessionFactory_kxs" key="ds_kxs"/> <entry value-ref="sqlSessionFactory_fyd" key="ds_fyd"/> <entry value-ref="sqlSessionFactory_ybj" key="ds_ybj"/> <entry value-ref="sqlSessionFactory_yzh" key="ds_yzh"/> </map> </property> </bean> <!-- 配置mybatis接口扫描 --> <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="http://www.mamicode.com/com.fms.**.dao" /> <property name="sqlSessionTemplateBeanName" value="http://www.mamicode.com/sqlSessionTemplate"/> </bean> <!-- jta配置,直接复用,不需要修改 --> <!-- jta配置开始 --> <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="http://www.mamicode.com/300" /> </bean> <bean id="springTransactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"> <property name="transactionManager"> <ref bean="atomikosTransactionManager" /> </property> <property name="userTransaction"> <ref bean="atomikosUserTransaction" /> </property> </bean> <!-- jta配置结束 --> <!-- 配置事务管理 --> <tx:annotation-driven transaction-manager="springTransactionManager" proxy-target-class="true" /> </beans>
3、springmvc-servlet.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:aop="http://www.springframework.org/schema/aop" xmlns:cache="http://www.springframework.org/schema/cache" xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:jms="http://www.springframework.org/schema/jms" xmlns:lang="http://www.springframework.org/schema/lang" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:oxm="http://www.springframework.org/schema/oxm" xmlns:p="http://www.springframework.org/schema/p" xmlns:task="http://www.springframework.org/schema/task" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mongo="http://www.springframework.org/schema/data/mongo" xmlns:util="http://www.springframework.org/schema/util" xmlns:ehcache="http://ehcache-spring-annotations.googlecode.com/svn/schema/ehcache-spring" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-4.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.1.xsd http://www.springframework.org/schema/jms http://www.springframework.org/schema/jms/spring-jms-4.1.xsd http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-4.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd http://www.springframework.org/schema/oxm http://www.springframework.org/schema/oxm/spring-oxm-4.1.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.1.xsd"> <context:component-scan base-package="com.fms;com.jmda;com.job;" > <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service" /> </context:component-scan> <!-- <context:annotation-config/> --> <!-- message-converters --> <mvc:annotation-driven> <mvc:message-converters> <bean class="org.springframework.http.converter.StringHttpMessageConverter"> <property name="supportedMediaTypes"> <list> <value>text/plain;charset=UTF-8</value> <value>text/html;charset=UTF-8</value> </list> </property> </bean> </mvc:message-converters> </mvc:annotation-driven> <!-- 视图解析器 --> <bean id="viewResolver" class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver"> <property name="cache" value="http://www.mamicode.com/true" /> <property name="suffix" value="http://www.mamicode.com/.ftl" /> <property name="contentType" value="http://www.mamicode.com/text/html;charset=UTF-8"></property> <property name="requestContextAttribute" value="http://www.mamicode.com/request" /> <property name="exposeSpringMacroHelpers" value="http://www.mamicode.com/true" /> <property name="exposeRequestAttributes" value="http://www.mamicode.com/true" /> <property name="exposeSessionAttributes" value="http://www.mamicode.com/true" /> </bean> <!-- 静态资源 --> <mvc:resources mapping="/static/**" location="/static/" /> <mvc:resources mapping="/jmda-static/**" location="/jmda-static/" /> <mvc:resources mapping="/assets/**" location="/assets/" /> <!-- 拦截器 --> <mvc:interceptors> <bean class="com.fms.common.listener.SecurityInterceptor"/> </mvc:interceptors> </beans>
4、web.xml:
<?xml version="1.0" encoding="UTF-8"?> <web-app metadata-complete="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"> <context-param> <param-name>contextConfigLocation</param-name> <param-value> classpath*:/spring/applicationContext*.xml </param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <listener> <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class> </listener> <filter> <filter-name>CharacterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <servlet> <servlet-name>spring4mvc</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath*:/spring/springmvc-servlet.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>spring4mvc</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!--文件下载 --> <servlet> <servlet-name>ServletDownload</servlet-name> <servlet-class>com.fms.business.sjtb.service.ServletDownload</servlet-class> </servlet> <servlet-mapping> <servlet-name>ServletDownload</servlet-name> <url-pattern>/servlet/download</url-pattern> </servlet-mapping> <context-param> <param-name>log4jConfigLocation</param-name> <param-value>/WEB-INF/classes/log4j.properties</param-value> </context-param> <listener> <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> </listener> <listener> <listener-class>com.fms.common.listener.CommListener</listener-class> </listener> <!-- 400错误 --> <error-page> <error-code>400</error-code> <location>/error</location> </error-page> <!-- 404 页面不存在错误 --> <error-page> <error-code>404</error-code> <location>/error</location> </error-page> <!-- 403 服务器拒绝请求 --> <error-page> <error-code>403</error-code> <location>/error</location> </error-page> <!-- 500 服务器内部错误 --> <error-page> <error-code>500</error-code> <location>/error</location> </error-page> <!-- 503 服务不可用 --> <error-page> <error-code>503</error-code> <location>/error</location> </error-page> <!-- java.lang.Exception --> <error-page> <exception-type>java.lang.Exception</exception-type> <location>/error</location> </error-page> <!-- java.lang.NullPointerException --> <error-page> <exception-type>java.lang.NullPointerException</exception-type> <location>/error</location> </error-page> <error-page> <exception-type>javax.servlet.ServletException</exception-type> <location>/error</location> </error-page> <welcome-file-list> <welcome-file></welcome-file> </welcome-file-list> </web-app>
5、在resources文件夹下增加jta.properties文件:
com.atomikos.icatch.service=com.atomikos.icatch.standalone.UserTransactionServiceFactory com.atomikos.icatch.console_file_name = tm.out com.atomikos.icatch.log_base_name = tmlog com.atomikos.icatch.tm_unique_name = com.atomikos.spring.jdbc.tm com.atomikos.icatch.console_log_level=WARN
JAVA代码:
1.MultipleDataSource:
package com.fms.common.datasource; import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource; public class MultipleDataSource extends AbstractRoutingDataSource { private static final ThreadLocal<String> dataSourceKey = new InheritableThreadLocal<String>(); //将数据源重置为默认数据源 public static void changeTodefaultDataSource() { dataSourceKey.remove(); } // //院 // public static void setDataSourceY(){ // dataSourceKey.remove(); // dataSourceKey.set("yzhDataSource"); // } //将数据源设置为配置文件中key值为dataSource参数对应的值的数据源 public static void setDataSource(String dataSource){ dataSourceKey.remove(); dataSourceKey.set(dataSource); } //获取当前数据源的key值 public static String getKey(){ return dataSourceKey.get(); } //重写AbstractRoutingDataSource的方法,提供当前的数据源用于连接 @Override protected Object determineCurrentLookupKey() { return dataSourceKey.get(); } }
2、自定义的SqlSessionTemlate类:
CustomSqlSessionTemplate
package com.fms.common.datasource; import static java.lang.reflect.Proxy.newProxyInstance; import static org.apache.ibatis.reflection.ExceptionUtil.unwrapThrowable; import static org.mybatis.spring.SqlSessionUtils.closeSqlSession; import static org.mybatis.spring.SqlSessionUtils.getSqlSession; import static org.mybatis.spring.SqlSessionUtils.isSqlSessionTransactional; import java.lang.reflect.InvocationHandler; import java.lang.reflect.Method; import java.sql.Connection; import java.util.List; import java.util.Map; import org.apache.ibatis.exceptions.PersistenceException; import org.apache.ibatis.executor.BatchResult; import org.apache.ibatis.session.Configuration; import org.apache.ibatis.session.ExecutorType; import org.apache.ibatis.session.ResultHandler; import org.apache.ibatis.session.RowBounds; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.MyBatisExceptionTranslator; import org.mybatis.spring.SqlSessionTemplate; import org.springframework.dao.support.PersistenceExceptionTranslator; import org.springframework.util.Assert; public class CustomSqlSessionTemplate extends SqlSessionTemplate { private final SqlSessionFactory sqlSessionFactory; private final ExecutorType executorType; private final SqlSession sqlSessionProxy; private final PersistenceExceptionTranslator exceptionTranslator; private Map<Object, SqlSessionFactory> targetSqlSessionFactorys; private SqlSessionFactory defaultTargetSqlSessionFactory; public void setTargetSqlSessionFactorys(Map<Object, SqlSessionFactory> targetSqlSessionFactorys) { this.targetSqlSessionFactorys = targetSqlSessionFactorys; } public void setDefaultTargetSqlSessionFactory(SqlSessionFactory defaultTargetSqlSessionFactory) { this.defaultTargetSqlSessionFactory = defaultTargetSqlSessionFactory; } public CustomSqlSessionTemplate(SqlSessionFactory sqlSessionFactory) { this(sqlSessionFactory, sqlSessionFactory.getConfiguration().getDefaultExecutorType()); } public CustomSqlSessionTemplate(SqlSessionFactory sqlSessionFactory, ExecutorType executorType) { this(sqlSessionFactory, executorType, new MyBatisExceptionTranslator(sqlSessionFactory.getConfiguration() .getEnvironment().getDataSource(), true)); } public CustomSqlSessionTemplate(SqlSessionFactory sqlSessionFactory, ExecutorType executorType, PersistenceExceptionTranslator exceptionTranslator) { super(sqlSessionFactory, executorType, exceptionTranslator); this.sqlSessionFactory = sqlSessionFactory; this.executorType = executorType; this.exceptionTranslator = exceptionTranslator; this.sqlSessionProxy = (SqlSession) newProxyInstance( SqlSessionFactory.class.getClassLoader(), new Class[] { SqlSession.class }, new SqlSessionInterceptor()); this.defaultTargetSqlSessionFactory = sqlSessionFactory; } @Override public SqlSessionFactory getSqlSessionFactory() { SqlSessionFactory targetSqlSessionFactory = targetSqlSessionFactorys.get(MultipleDataSource.getKey()); if (targetSqlSessionFactory != null) { return targetSqlSessionFactory; } else if (defaultTargetSqlSessionFactory != null) { return defaultTargetSqlSessionFactory; } else { Assert.notNull(targetSqlSessionFactorys, "Property ‘targetSqlSessionFactorys‘ or ‘defaultTargetSqlSessionFactory‘ are required"); Assert.notNull(defaultTargetSqlSessionFactory, "Property ‘defaultTargetSqlSessionFactory‘ or ‘targetSqlSessionFactorys‘ are required"); } return this.sqlSessionFactory; } @Override public Configuration getConfiguration() { return this.getSqlSessionFactory().getConfiguration(); } public ExecutorType getExecutorType() { return this.executorType; } public PersistenceExceptionTranslator getPersistenceExceptionTranslator() { return this.exceptionTranslator; } /** * {@inheritDoc} */ public <T> T selectOne(String statement) { return this.sqlSessionProxy.<T> selectOne(statement); } /** * {@inheritDoc} */ public <T> T selectOne(String statement, Object parameter) { return this.sqlSessionProxy.<T> selectOne(statement, parameter); } /** * {@inheritDoc} */ public <K, V> Map<K, V> selectMap(String statement, String mapKey) { return this.sqlSessionProxy.<K, V> selectMap(statement, mapKey); } /** * {@inheritDoc} */ public <K, V> Map<K, V> selectMap(String statement, Object parameter, String mapKey) { return this.sqlSessionProxy.<K, V> selectMap(statement, parameter, mapKey); } /** * {@inheritDoc} */ public <K, V> Map<K, V> selectMap(String statement, Object parameter, String mapKey, RowBounds rowBounds) { return this.sqlSessionProxy.<K, V> selectMap(statement, parameter, mapKey, rowBounds); } /** * {@inheritDoc} */ public <E> List<E> selectList(String statement) { return this.sqlSessionProxy.<E> selectList(statement); } /** * {@inheritDoc} */ public <E> List<E> selectList(String statement, Object parameter) { return this.sqlSessionProxy.<E> selectList(statement, parameter); } /** * {@inheritDoc} */ public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) { return this.sqlSessionProxy.<E> selectList(statement, parameter, rowBounds); } /** * {@inheritDoc} */ public void select(String statement, ResultHandler handler) { this.sqlSessionProxy.select(statement, handler); } /** * {@inheritDoc} */ public void select(String statement, Object parameter, ResultHandler handler) { this.sqlSessionProxy.select(statement, parameter, handler); } /** * {@inheritDoc} */ public void select(String statement, Object parameter, RowBounds rowBounds, ResultHandler handler) { this.sqlSessionProxy.select(statement, parameter, rowBounds, handler); } /** * {@inheritDoc} */ public int insert(String statement) { return this.sqlSessionProxy.insert(statement); } /** * {@inheritDoc} */ public int insert(String statement, Object parameter) { return this.sqlSessionProxy.insert(statement, parameter); } /** * {@inheritDoc} */ public int update(String statement) { return this.sqlSessionProxy.update(statement); } /** * {@inheritDoc} */ public int update(String statement, Object parameter) { return this.sqlSessionProxy.update(statement, parameter); } /** * {@inheritDoc} */ public int delete(String statement) { return this.sqlSessionProxy.delete(statement); } /** * {@inheritDoc} */ public int delete(String statement, Object parameter) { return this.sqlSessionProxy.delete(statement, parameter); } /** * {@inheritDoc} */ public <T> T getMapper(Class<T> type) { return getConfiguration().getMapper(type, this); } /** * {@inheritDoc} */ public void commit() { throw new UnsupportedOperationException("Manual commit is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void commit(boolean force) { throw new UnsupportedOperationException("Manual commit is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void rollback() { throw new UnsupportedOperationException("Manual rollback is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void rollback(boolean force) { throw new UnsupportedOperationException("Manual rollback is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void close() { throw new UnsupportedOperationException("Manual close is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void clearCache() { this.sqlSessionProxy.clearCache(); } /** * {@inheritDoc} */ public Connection getConnection() { return this.sqlSessionProxy.getConnection(); } /** * {@inheritDoc} * @since 1.0.2 */ public List<BatchResult> flushStatements() { return this.sqlSessionProxy.flushStatements(); } /** * Proxy needed to route MyBatis method calls to the proper SqlSession got from Spring‘s Transaction Manager It also * unwraps exceptions thrown by {@code Method#invoke(Object, Object...)} to pass a {@code PersistenceException} to * the {@code PersistenceExceptionTranslator}. */ private class SqlSessionInterceptor implements InvocationHandler { public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { final SqlSession sqlSession = getSqlSession( CustomSqlSessionTemplate.this.getSqlSessionFactory(), CustomSqlSessionTemplate.this.executorType, CustomSqlSessionTemplate.this.exceptionTranslator); try { Object result = method.invoke(sqlSession, args); if (!isSqlSessionTransactional(sqlSession, CustomSqlSessionTemplate.this.getSqlSessionFactory())) { // force commit even on non-dirty sessions because some databases require // a commit/rollback before calling close() sqlSession.commit(true); } return result; } catch (Throwable t) { Throwable unwrapped = unwrapThrowable(t); if (CustomSqlSessionTemplate.this.exceptionTranslator != null && unwrapped instanceof PersistenceException) { Throwable translated = CustomSqlSessionTemplate.this.exceptionTranslator .translateExceptionIfPossible((PersistenceException) unwrapped); if (translated != null) { unwrapped = translated; } } throw unwrapped; } finally { closeSqlSession(sqlSession, CustomSqlSessionTemplate.this.getSqlSessionFactory()); } } } }
3、数据源切换切面ChooseDataSourceAspect:
package com.fms.common.aop; import java.lang.reflect.Method; import org.aspectj.lang.JoinPoint; import org.aspectj.lang.annotation.After; import org.aspectj.lang.annotation.Aspect; import org.aspectj.lang.annotation.Before; import org.aspectj.lang.annotation.Pointcut; import com.fms.common.annotation.ChooseDataSource; import com.fms.common.datasource.MultipleDataSource; import com.fms.common.utils.reflect.ReflectUtil; /** * 类描述:完成数据源的切换,抽类切面,具体项目继承一下,不需要重写即可使用 */ @Aspect public class ChooseDataSourceAspect { protected static final ThreadLocal<String> preDatasourceHolder = new ThreadLocal<String>(); @Pointcut("@annotation(com.amos.spring.annotation.ChooseDataSource)") public void methodWithChooseAnnotation() { } /** * 根据@ChooseDataSource的属性值设置不同的dataSourceKey,以供DynamicDataSource */ @Before("methodWithChooseAnnotation()") public void changeDataSourceBeforeMethodExecution(JoinPoint jp) { //拿到anotation中配置的数据源 String resultDS = determineDatasource(jp); //没有配置实用默认数据源 if (resultDS == null) { MultipleDataSource.changeTodefaultDataSource(); return; } preDatasourceHolder.set(MultipleDataSource.getKey()); //将数据源设置到数据源持有者 MultipleDataSource.setDataSource(resultDS); } /** * 如果需要修改获取数据源的逻辑,请重写此方法 * * @param jp * @return */ @SuppressWarnings("rawtypes") protected String determineDatasource(JoinPoint jp) { String methodName = jp.getSignature().getName(); Class targetClass = jp.getSignature().getDeclaringType(); String dataSourceForTargetClass = resolveDataSourceFromClass(targetClass); String dataSourceForTargetMethod = resolveDataSourceFromMethod(targetClass, methodName); String resultDS = determinateDataSource(dataSourceForTargetClass, dataSourceForTargetMethod); return resultDS; } /** * 方法执行完毕以后,数据源切换回之前的数据源。 * 比如foo()方法里面调用bar(),但是bar()另外一个数据源, * bar()执行时,切换到自己数据源,执行完以后,要切换到foo()所需要的数据源,以供 * foo()继续执行。 */ @After("methodWithChooseAnnotation()") public void restoreDataSourceAfterMethodExecution() { MultipleDataSource.setDataSource(preDatasourceHolder.get()); preDatasourceHolder.remove(); } /** * @param targetClass * @param methodName * @return */ @SuppressWarnings("rawtypes") private String resolveDataSourceFromMethod(Class targetClass, String methodName) { Method m = ReflectUtil.findUniqueMethod(targetClass, methodName); if (m != null) { ChooseDataSource choDs = m.getAnnotation(ChooseDataSource.class); return resolveDataSourcename(choDs); } return null; } /** * 方法描述 : * 确定最终数据源,如果方法上设置有数据源,则以方法上的为准,如果方法上没有设置,则以类上的为准,如果类上没有设置,则使用默认数据源 * * @param classDS * @param methodDS * @return */ private String determinateDataSource(String classDS, String methodDS) { // if (null == classDS && null == methodDS) { // return null; // } // 两者必有一个不为null,如果两者都为Null,也会返回Null return methodDS == null ? classDS : methodDS; } /** * 方法描述 : 类级别的 @ChooseDataSource的解析 * * @param targetClass * @return */ @SuppressWarnings({"unchecked", "rawtypes"}) private String resolveDataSourceFromClass(Class targetClass) { ChooseDataSource classAnnotation = (ChooseDataSource) targetClass .getAnnotation(ChooseDataSource.class); // 直接为整个类进行设置 return null != classAnnotation ? resolveDataSourcename(classAnnotation) : null; } /** * 方法描述 : * 组装DataSource的名字 * * @param ds * @return */ private String resolveDataSourcename(ChooseDataSource ds) { return ds == null ? null : ds.value(); } }
4、数据源切换注解ChooseDataSource:
package com.fms.common.annotation; import java.lang.annotation.*; /** * 注解式数据源,用来进行数据源切换 */ @Target({ElementType.METHOD, ElementType.TYPE}) @Retention(RetentionPolicy.RUNTIME) @Documented public @interface ChooseDataSource { String value() default ""; }
5、使用方式:
TestService:
package com.fms.business; import java.util.Map; import org.mybatis.spring.SqlSessionTemplate; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.fms.common.dao.table.mapper.WfWorkflowPOMapper; import com.fms.common.datasource.MultipleDataSource; import com.fms.common.model.po.WfWorkflowPO; import com.google.common.collect.Maps; @Service(value="testService") public class TestService { //注入SqlSessionTemplate,执行自定义的Mapper.xml文件 @Autowired SqlSessionTemplate sqlSessionTemplate; String nameSpace = "com.fms.business.dao.TestServiceMapper"; @Transactional public void test() throws Exception{ Map<String, Object> param = Maps.newHashMap(); param.put("id", "123"); param.put("name", "zhangsan"); //默认数据源ds_zhs sqlSessionTemplate.insert(nameSpace+".testInsert", param); //切换至ds_jcs MultipleDataSource.setDataSource("ds_jcs"); sqlSessionTemplate.insert(nameSpace+".testInsert", param); } @Transactional public void test1() throws Exception{ Map<String, Object> param = Maps.newHashMap(); param.put("id", "124"); param.put("name", "lisi"); //默认数据源ds_zhs sqlSessionTemplate.insert(nameSpace+".testInsert", param); //切换至ds_jcs MultipleDataSource.setDataSource("ds_jcs"); sqlSessionTemplate.insert(nameSpace+".testInsert", param); //编写抛出异常的代码测试事务回滚 String str = null; str.trim(); } //使用MyBatis自动生成的Mapper接口 @Autowired WfWorkflowPOMapper wfWorkflowPOMapper; @Transactional public void test2() throws Exception{ WfWorkflowPO record = new WfWorkflowPO(); record.setWorkflowId("12345"); record.setName("xxxx"); wfWorkflowPOMapper.insert(record); //切换至ds_jcs MultipleDataSource.setDataSource("ds_jcs"); wfWorkflowPOMapper.insert(record); //切换至ds_yzh MultipleDataSource.setDataSource("ds_yzh"); wfWorkflowPOMapper.insert(record); } }
TestController:
package com.fms.business; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; @Controller public class TestController { @Autowired TestService testService; @RequestMapping("/test") @ResponseBody public String test(){ try { testService.test(); return "ok"; } catch (Exception e) { e.printStackTrace(); return "fail"; } } @RequestMapping("/test1") @ResponseBody public String test1(){ try { testService.test1(); return "ok"; } catch (Exception e) { e.printStackTrace(); return "fail"; } } @RequestMapping("/test2") @ResponseBody public String test2(){ try { testService.test2(); return "ok"; } catch (Exception e) { e.printStackTrace(); return "fail"; } } }
原例中还有使用@ChooseDataSource注解切换数据源的用法,需要AspectJ编译,捣鼓了一下没成功,有兴趣可以自己试试。
参考博文:http://www.blogjava.net/zuxiong/archive/2015/09/24/427471.html
package com.fms.common.datasource;
import static java.lang.reflect.Proxy.newProxyInstance;import static org.apache.ibatis.reflection.ExceptionUtil.unwrapThrowable;import static org.mybatis.spring.SqlSessionUtils.closeSqlSession;import static org.mybatis.spring.SqlSessionUtils.getSqlSession;import static org.mybatis.spring.SqlSessionUtils.isSqlSessionTransactional;
import java.lang.reflect.InvocationHandler;import java.lang.reflect.Method;import java.sql.Connection;import java.util.List;import java.util.Map;
import org.apache.ibatis.exceptions.PersistenceException;import org.apache.ibatis.executor.BatchResult;import org.apache.ibatis.session.Configuration;import org.apache.ibatis.session.ExecutorType;import org.apache.ibatis.session.ResultHandler;import org.apache.ibatis.session.RowBounds;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.MyBatisExceptionTranslator;import org.mybatis.spring.SqlSessionTemplate;import org.springframework.dao.support.PersistenceExceptionTranslator;import org.springframework.util.Assert;
public class CustomSqlSessionTemplate extends SqlSessionTemplate { private final SqlSessionFactory sqlSessionFactory; private final ExecutorType executorType; private final SqlSession sqlSessionProxy; private final PersistenceExceptionTranslator exceptionTranslator; private Map<Object, SqlSessionFactory> targetSqlSessionFactorys; private SqlSessionFactory defaultTargetSqlSessionFactory; public void setTargetSqlSessionFactorys(Map<Object, SqlSessionFactory> targetSqlSessionFactorys) { this.targetSqlSessionFactorys = targetSqlSessionFactorys; } public void setDefaultTargetSqlSessionFactory(SqlSessionFactory defaultTargetSqlSessionFactory) { this.defaultTargetSqlSessionFactory = defaultTargetSqlSessionFactory; } public CustomSqlSessionTemplate(SqlSessionFactory sqlSessionFactory) { this(sqlSessionFactory, sqlSessionFactory.getConfiguration().getDefaultExecutorType()); } public CustomSqlSessionTemplate(SqlSessionFactory sqlSessionFactory, ExecutorType executorType) { this(sqlSessionFactory, executorType, new MyBatisExceptionTranslator(sqlSessionFactory.getConfiguration() .getEnvironment().getDataSource(), true)); } public CustomSqlSessionTemplate(SqlSessionFactory sqlSessionFactory, ExecutorType executorType, PersistenceExceptionTranslator exceptionTranslator) { super(sqlSessionFactory, executorType, exceptionTranslator); this.sqlSessionFactory = sqlSessionFactory; this.executorType = executorType; this.exceptionTranslator = exceptionTranslator; this.sqlSessionProxy = (SqlSession) newProxyInstance( SqlSessionFactory.class.getClassLoader(), new Class[] { SqlSession.class }, new SqlSessionInterceptor()); this.defaultTargetSqlSessionFactory = sqlSessionFactory; } @Override public SqlSessionFactory getSqlSessionFactory() { SqlSessionFactory targetSqlSessionFactory = targetSqlSessionFactorys.get(MultipleDataSource.getKey()); if (targetSqlSessionFactory != null) { return targetSqlSessionFactory; } else if (defaultTargetSqlSessionFactory != null) { return defaultTargetSqlSessionFactory; } else { Assert.notNull(targetSqlSessionFactorys, "Property ‘targetSqlSessionFactorys‘ or ‘defaultTargetSqlSessionFactory‘ are required"); Assert.notNull(defaultTargetSqlSessionFactory, "Property ‘defaultTargetSqlSessionFactory‘ or ‘targetSqlSessionFactorys‘ are required"); } return this.sqlSessionFactory; } @Override public Configuration getConfiguration() { return this.getSqlSessionFactory().getConfiguration(); } public ExecutorType getExecutorType() { return this.executorType; } public PersistenceExceptionTranslator getPersistenceExceptionTranslator() { return this.exceptionTranslator; } /** * {@inheritDoc} */ public <T> T selectOne(String statement) { return this.sqlSessionProxy.<T> selectOne(statement); } /** * {@inheritDoc} */ public <T> T selectOne(String statement, Object parameter) { return this.sqlSessionProxy.<T> selectOne(statement, parameter); } /** * {@inheritDoc} */ public <K, V> Map<K, V> selectMap(String statement, String mapKey) { return this.sqlSessionProxy.<K, V> selectMap(statement, mapKey); } /** * {@inheritDoc} */ public <K, V> Map<K, V> selectMap(String statement, Object parameter, String mapKey) { return this.sqlSessionProxy.<K, V> selectMap(statement, parameter, mapKey); } /** * {@inheritDoc} */ public <K, V> Map<K, V> selectMap(String statement, Object parameter, String mapKey, RowBounds rowBounds) { return this.sqlSessionProxy.<K, V> selectMap(statement, parameter, mapKey, rowBounds); } /** * {@inheritDoc} */ public <E> List<E> selectList(String statement) { return this.sqlSessionProxy.<E> selectList(statement); } /** * {@inheritDoc} */ public <E> List<E> selectList(String statement, Object parameter) { return this.sqlSessionProxy.<E> selectList(statement, parameter); } /** * {@inheritDoc} */ public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) { return this.sqlSessionProxy.<E> selectList(statement, parameter, rowBounds); } /** * {@inheritDoc} */ public void select(String statement, ResultHandler handler) { this.sqlSessionProxy.select(statement, handler); } /** * {@inheritDoc} */ public void select(String statement, Object parameter, ResultHandler handler) { this.sqlSessionProxy.select(statement, parameter, handler); } /** * {@inheritDoc} */ public void select(String statement, Object parameter, RowBounds rowBounds, ResultHandler handler) { this.sqlSessionProxy.select(statement, parameter, rowBounds, handler); } /** * {@inheritDoc} */ public int insert(String statement) { return this.sqlSessionProxy.insert(statement); } /** * {@inheritDoc} */ public int insert(String statement, Object parameter) { return this.sqlSessionProxy.insert(statement, parameter); } /** * {@inheritDoc} */ public int update(String statement) { return this.sqlSessionProxy.update(statement); } /** * {@inheritDoc} */ public int update(String statement, Object parameter) { return this.sqlSessionProxy.update(statement, parameter); } /** * {@inheritDoc} */ public int delete(String statement) { return this.sqlSessionProxy.delete(statement); } /** * {@inheritDoc} */ public int delete(String statement, Object parameter) { return this.sqlSessionProxy.delete(statement, parameter); } /** * {@inheritDoc} */ public <T> T getMapper(Class<T> type) { return getConfiguration().getMapper(type, this); } /** * {@inheritDoc} */ public void commit() { throw new UnsupportedOperationException("Manual commit is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void commit(boolean force) { throw new UnsupportedOperationException("Manual commit is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void rollback() { throw new UnsupportedOperationException("Manual rollback is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void rollback(boolean force) { throw new UnsupportedOperationException("Manual rollback is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void close() { throw new UnsupportedOperationException("Manual close is not allowed over a Spring managed SqlSession"); } /** * {@inheritDoc} */ public void clearCache() { this.sqlSessionProxy.clearCache(); } /** * {@inheritDoc} */ public Connection getConnection() { return this.sqlSessionProxy.getConnection(); } /** * {@inheritDoc} * @since 1.0.2 */ public List<BatchResult> flushStatements() { return this.sqlSessionProxy.flushStatements(); } /** * Proxy needed to route MyBatis method calls to the proper SqlSession got from Spring‘s Transaction Manager It also * unwraps exceptions thrown by {@code Method#invoke(Object, Object...)} to pass a {@code PersistenceException} to * the {@code PersistenceExceptionTranslator}. */ private class SqlSessionInterceptor implements InvocationHandler { public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { final SqlSession sqlSession = getSqlSession( CustomSqlSessionTemplate.this.getSqlSessionFactory(), CustomSqlSessionTemplate.this.executorType, CustomSqlSessionTemplate.this.exceptionTranslator); try { Object result = method.invoke(sqlSession, args); if (!isSqlSessionTransactional(sqlSession, CustomSqlSessionTemplate.this.getSqlSessionFactory())) { // force commit even on non-dirty sessions because some databases require // a commit/rollback before calling close() sqlSession.commit(true); } return result; } catch (Throwable t) { Throwable unwrapped = unwrapThrowable(t); if (CustomSqlSessionTemplate.this.exceptionTranslator != null && unwrapped instanceof PersistenceException) { Throwable translated = CustomSqlSessionTemplate.this.exceptionTranslator .translateExceptionIfPossible((PersistenceException) unwrapped); if (translated != null) { unwrapped = translated; } } throw unwrapped; } finally { closeSqlSession(sqlSession, CustomSqlSessionTemplate.this.getSqlSessionFactory()); } } } }
spring+springMVC+Mybatis架构下采用AbstractRoutingDataSource、atomikos、JTA实现多数据源灵活切换以及分布式事务管理