Spring3.X 分布式事务

最新推荐文章于 2025-05-17 11:22:21 发布

原创最新推荐文章于 2025-05-17 11:22:21 发布 · 344 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#spring #分布式事务

技术贴专栏收录该内容

133 篇文章

订阅专栏

博客围绕Spring和分布式事务展开，但具体内容缺失。Spring是后端开发常用框架，分布式事务在复杂系统数据一致性保障中至关重要。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.为什么要组建多数据源?

一个系统中存在多个数据库读写操作,如Oralce+MySql......等

2.为什么要组建分布式事务?

在同一个系统,同一个事务中对不同数据库进行写操作时,如若一个失败,那么应该对多个数据库进行回滚操作,否则应该全部提交.

3.分布式事务有哪些?

在Spring 2.5中可以采用jta,在Spring3.X中则已经不对其提供支持,但可以使用atomikos.

4.需要提供哪些jar包支持?

6个必须的jar包,可以通过maven下载
atomikos-util-3.9.3.jar
jta-1.1.jar
transactions-3.9.3.jar
transactions-api-3.9.3.jar
transactions-jdbc-3.9.3.jar
transactions-jta-3.9.3.jar

5.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" xmlns:aop= "http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"

xmlns:mvc="http://www.springframework.org/schema/mvc"

xsi:schemaLocation="

http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">

<context:annotation-config />

<context:component-scan base-package ="com.cn" />

<description >oracle xa datasource </description >

<value >oracle_ds </value >

</property >

<value> oracle.jdbc.xa.client.OracleXADataSource</value >

</property >

<prop key ="user">dongruan</ prop>

<prop key ="password">dongruan</ prop>

<prop key= "URL">jdbc:oracle:thin:@100.100.100.30:1521: orcl</ prop>

</props >

</property >

<value >select 1 from dual </value >

</property >

</bean >

<description >mysql xa datasource</ description>

<value >mysql_ds </value >

</property >

<value> com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</value >

</property >

<prop key ="user">datapre</ prop>

<prop key= "URL">jdbc:mysql://100.100.100.48:3306/ dataprepare</ prop>

</props >

</property >

<value >select 1 </value >

</property >

</bean >

</bean >

</bean >

</bean >

</bean >

<description >UserTransactionImp </description >

</bean >

<description >UserTransactionManager </description >

</property >

</bean >

<description >JtaTransactionManager </description >

</property >

</property >

</bean >

</property >

<prop key= "*">PROPAGATION_REQUIRED,-Exception </prop >

</props >

</property >

</bean >

<tx:annotation-driven transaction-manager="springTransactionManager" />

</beans>

6.测试代码如下:

package com.cn.main;

import java.io.UnsupportedEncodingException;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.cn.testService;

public class main {

public static void main(String[] args) throws UnsupportedEncodingException {

ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("DataSource.xml" );

testService service = context.getBean(testService.class );

service.test();

}

7.Service类:

package com.cn;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

import com.cn.mapper.SendPreMapper;

import com.cn.oraclemapper.AirwayPointFlowMapper;

import com.cn.oraclepo.AirwayPointFlow;

import com.cn.po.SendPreWithBLOBs;

@Service

public class testService {

@Autowired

public SendPreMapper mysqlMapper;

@Autowired

public AirwayPointFlowMapper oracleMapper;

@Transactional

public void test() {

SendPreWithBLOBs pre = new SendPreWithBLOBs();

pre.setId(123457);

mysqlMapper.insert(pre);

AirwayPointFlow air = new AirwayPointFlow();

air.setId( "11111111112");

oracleMapper.insert(air);

}