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同上