多数据源解决分布式事务问题【SpringBoot+JTA+Atomikos】

最新推荐文章于 2024-08-15 21:36:29 发布

SanQiangXiong

最新推荐文章于 2024-08-15 21:36:29 发布

阅读量900

点赞数

分类专栏： SpringBoot

本文链接：https://blog.csdn.net/a917922724/article/details/104372131

版权

本文介绍了如何借助SpringBoot、JTA和Atomikos来解决多数据源的分布式事务问题。从引入相关依赖，到配置启动类和数据源，详细阐述了解决方案的步骤。

摘要由CSDN通过智能技术生成

1：引入依赖

<!--java 事务api 阶段 是xa协议的java实现-->
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jta-atomikos -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jta-atomikos</artifactId>
</dependency>

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.0</version>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-configuration-processor</artifactId>
    <optional>true</optional>
</dependency>

2：

spring:
  datasource:
    test:
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT&allowMultiQueries=true
      username: root
      password: fenghao230.
      driver-class-name: com.mysql.cj.jdbc.Driver
      sql-script-encoding: UTF-8
      type: com.zaxxer.hikari.HikariDataSource
      initialization-mode: always
      continue-on-error: true
      hikari:
        minimum-idle: 5
        connection-test-query: SELECT 1 FROM DUAL
        maximum-pool-size: 20
        auto-commit: true
        idle-timeout: 30000
        pool-name: SpringBootDemoHikariCP
        max-lifetime: 60000
        connection-timeout: 30000
      logging:
        level:
          com.qjc.dao.Test: TARCE
      borr