【java】hibernate利用Atomikos实现多数据源事务管理

1、引入jar包

  <!--多数据源-->
	  <dependency>
		  <groupId>com.alibaba</groupId>
		  <artifactId>druid</artifactId>
		  <version>1.1.11</version>
	  </dependency>
	  <dependency>
		  <groupId>com.atomikos</groupId>
		  <artifactId>atomikos-util</artifactId>
		  <version>3.9.3</version>
	  </dependency>
	  <dependency>
		  <groupId>com.atomikos</groupId>
		  <artifactId>transactions-jdbc</artifactId>
		  <version>3.9.3</version>
	  </dependency>
	  <dependency>
		  <groupId>com.atomikos</groupId>
		  <artifactId>transactions-jta</artifactId>
		  <version>3.9.3</version>
	  </dependency>
	  <dependency>
		  <groupId>com.atomikos</groupId>
		  <artifactId>transactions</artifactId>
		  <version>3.9.3</version>
	  </dependency>
	  <dependency>
		  <groupId>com.atomikos</groupId>
		  <artifactId>transactions-api</artifactId>
		  <version>3.9.3</version>
	  </dependency>
	  <dependency>
		  <groupId>javax.transaction</groupId>
		  <artifactId>jta</artifactId>
		  <version>1.1</version>
	  </dependency>

2、spring配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

    <!--数据源-->
	<bean id="abstractXADataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean" init-method="init" destroy-method="close" abstract="true">
	         <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"/>
	         <property name="poolSize" value="10" />
	         <property name="minPoolSize" value="10"/>
	         <property name="maxPoolSize" value="30"/>
	         <property name="borrowConnectionTimeout" value="60"/>
	         <property name="reapTimeout" value="20"/>
	         <!-- 最大空闲时间 -->
	         <property name="maxIdleTime" value="60"/>
	         <property name="maintenanceInterval" value="60"/>
	        <property name="loginTimeout" value="60"/>
	         <property name="testQuery">
	             <value>select 1</value>
	         </property>
	     </bean>

	     <!--主库，用于查询数据-->
	     <bean id="qadataSource" parent="abstractXADataSource">
         <property name="uniqueResourceName" value="mysql/sitestone" />
         <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" />
         <property name="xaProperties">
	             <props>
	                 <prop key="URL">${safeWebData.url}</prop>
	                 <prop key="user">${safeWebData.username}</prop>
	                 <prop key="password">${safeWebData.password}</prop>
	                 <prop key="pinGlobalTxToPhysicalConnection">true</prop>
	            </props>
		 </property>
    	 </bean>
     	<!--备份库，用于备份数据-->
	     <bean id="devdataSource" parent="abstractXADataSource">

	         <property name="uniqueResourceName" value="mysql/sitestone1" />
	         <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" />
	         <property name="xaProperties">
	             <props>
	                 <prop key="URL">${safeWebClearData.url}</prop>
	                 <prop key="user">${safeWebClearData.username}</prop>
	                 <prop key="password">${safeWebClearData.password}</prop>
	                 <prop key="pinGlobalTxToPhysicalConnection">true</prop>
	             </props>
	         </property>
	     </bean>
	<!--Hibernate SessionFatory-->
	<bean id="safeWebClearData2.packages" class="java.util.ArrayList">
		<constructor-arg>
			<list>
				<value>com.safeweb.safewebdata</value>
			</list>
		</constructor-arg>
	</bean>
	<bean id="safeWebClearData2-sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource" ref="devdataSource"/>
		<property name="configurationClass">
			<value>org.hibernate.cfg.AnnotationConfiguration</value>
		</property>
		<property name="packagesToScan" ref="safeWebClearData2.packages" />
		<property name="schemaUpdate" value="true"/>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">${safeWebClearData.hibernate.dialect}</prop>
				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
				<prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
				<prop key="hibernate.connection.autocommit">true</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
	</bean>

	<bean id="safeWebData2.packages" class="java.util.ArrayList">
		<constructor-arg>
			<list>
				<value>com.safeweb.safewebdata</value>
			</list>
		</constructor-arg>
	</bean>
		<bean id="safeWebData2-sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource" ref="qadataSource"/>
		<property name="configurationClass">
			<value>org.hibernate.cfg.AnnotationConfiguration</value>
		</property>
		<property name="packagesToScan" ref="safeWebData2.packages" />
		<property name="schemaUpdate" value="true"/>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">${safeWebData.hibernate.dialect}</prop>
				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
				<prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
	</bean>
	<!--   =========end  =============================================================== -->

	<!--多数据源配置-->
	<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="300" />
   	</bean>

    <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
		<property name="transactionManager">
            <ref bean="atomikosTransactionManager"/>
		</property>
		<property name="userTransaction">
           <ref bean="atomikosUserTransaction"/>
        </property>
        <!-- 必须设置，否则程序出现异常 JtaTransactionManager does not support custom isolation levels by default -->
         <property name="allowCustomIsolationLevels" value="true"/>
     </bean>
	<!--多数据源配置结束-->
</beans>

3、项目中设置相应的数据源

	 @Override
	  @Autowired
	 @Qualifier("safeWebClearData2-sessionFactory")
	  public void setSessionFactory(SessionFactory sessionFactory) {
	      super.setSessionFactory(sessionFactory);
	  }