spring 多数据源事务_spring3 多数据事务-优快云博客

本文链接：https://blog.youkuaiyun.com/Maya2000/article/details/78722662

spring 3对多数据源的事务管理可以不依赖JTA。配置如下：

spring-config-dao.xml：

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:task="http://www.springframework.org/schema/task"  
	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-4.3.xsd
						http://www.springframework.org/schema/context
						http://www.springframework.org/schema/context/spring-context-4.3.xsd
						http://www.springframework.org/schema/aop 
						http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
						http://www.springframework.org/schema/tx 
						http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
						http://www.springframework.org/schema/task 
						http://www.springframework.org/schema/task/spring-task-4.3.xsd
						
	default-autowire="byName">
	


	<!-- BoneCP configuration -->
	<bean id="abstractDataSource" abstract="true" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">
		<property name="driverClass" value="com.mysql.jdbc.Driver" />
		<property name="idleConnectionTestPeriodInMinutes" value="6" />
		<property name="idleMaxAgeInMinutes" value="10" />
		<property name="maxConnectionsPerPartition" value="10" />
		<property name="minConnectionsPerPartition" value="1" />
		<property name="partitionCount" value="3" />
		<property name="acquireIncrement" value="3" />
		<property name="statementsCacheSize" value="20" />
		<property name="releaseHelperThreads" value="3" />
        <property name="acquireRetryAttempts" value="3"/>
        <property name="connectionTestStatement" value="select 1" />
        <property name="logStatementsEnabled" value="true"/>
        <property name="connectionTimeoutInMs" value="10000"/>
        <property name="queryExecuteTimeLimitInMs" value="5000"/>
        <property name="defaultReadOnly" value="false"/>
	</bean>
	<bean id="masterDataSource" parent="abstractDataSource">
	*****
	</bean>
    
    <bean id="slaveDataSource" parent="abstractDataSource">
        ****
    </bean>
    

	<!-- 配置事务管理器 -->
	<bean id="masterTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="masterDataSource" />
	</bean>
	
	<!-- 配置事务管理器 -->
	<bean id="slaveTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="slaveDataSource" />
	</bean>
	

	<!-- 数据导出jdbc template -->
	<bean id = "slaveJdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="slaveDataSource" />
	</bean>
	
	<!-- 数据导出jdbc template -->
	<bean id = "masterJdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="masterDataSource" />
	</bean>
	
	<context:component-scan base-package="multpleDb"/>
	<!-- 启用对事务的注解支持 -->
	<tx:annotation-driven transaction-manager="masterTransactionManager" />
    <tx:annotation-driven transaction-manager="slaveTransactionManager" />
</beans>

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>multpleDb</groupId>
	<artifactId>multpleDb</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<dependencies>
		<!-- MyBatis&JDBC -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.1</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.0</version>
		</dependency>
		
		<dependency>
			<groupId>com.jolbox</groupId>
			<artifactId>bonecp</artifactId>
			<version>0.7.1.RELEASE</version>
		</dependency>
		
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.25</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>3.1.4.RELEASE</version>
		</dependency>	
		
		  <!-- 单元测试 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.5</version>
            <scope>test</scope>
        </dependency>
         <dependency>
			<groupId>org.testng</groupId>
			<artifactId>testng</artifactId>
			<version>6.1.1</version>
			<scope>test</scope>
		</dependency>
		 <dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>3.1.4.RELEASE</version>
		</dependency>
		
		<!-- LOG4J日志记录 -->
			<dependency>
				<groupId>org.slf4j</groupId>
				<artifactId>slf4j-api</artifactId>
				<version>1.6.4</version>
			</dependency>
			<dependency>
				<groupId>org.slf4j</groupId>
				<artifactId>slf4j-log4j12</artifactId>
				<version>1.6.4</version>
			</dependency>
			<dependency>
				<groupId>log4j</groupId>
				<artifactId>log4j</artifactId>
				<version>1.2.17</version>
			</dependency>
			<dependency>
				<groupId>commons-logging</groupId>
				<artifactId>commons-logging</artifactId>
				<version>1.1.1</version>
			</dependency>
		
			<dependency>
			    <groupId>cglib</groupId>
			    <artifactId>cglib-nodep</artifactId>
			    <version>2.1_3</version>
			</dependency>
	</dependencies>
</project>

log4j.xml

<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="[%5p] [%d{yyyy-MM-dd HH:mm:ss SSS}] [%t] [%M] (%F:%L) %m%n"/>
        </layout>
    </appender>

    <root>
        <priority value="debug"/>
        <appender-ref ref="CONSOLE"/>
    </root>
</log4j:configuration>

dbserver.java

package multpleDb;

import javax.annotation.Resource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service("dbServer")
public class DbServer {
	@Resource
	private JdbcTemplate slaveJdbcTemplate;
	@Resource
	private JdbcTemplate masterJdbcTemplate;
	
	@Transactional(value = "masterTransactionManager")
	public void testDb() {
		// 正式库插入
		String inserSql = "insert into ** (**,**) VALUES('aa','aa')";
		masterJdbcTemplate.update(inserSql);
		db2();
		// 沙箱库插入
	}
	
	@Transactional(value = "slaveTransactionManager")
	public void db2() {
		String inserSql = "insert into ** (**,**) VALUES('aa','aa')";
		slaveJdbcTemplate.update(inserSql);
	}
}

DBTest.java

package multpleDb;

import javax.annotation.Resource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:spring-config-dao.xml"})
public class DbTest {
	@Resource
	DbServer dbServer;
	
	@Test
	public void test(){
		dbServer.testDb();
	}
	
}