作者:殷天文
链接:https://www.jianshu.com/p/f9bac5822d30
之前的 《spring 动态切换、添加数据源实现以及源码浅析》 (https://www.jianshu.com/p/0a485c965b8b)中介绍了如何使用 spring 提供的 AbstractRoutingDataSource 配置多数据源,有了多数据源自然要管理事务的一致性。
上篇文章中提到过配置多数据源的两种方式
使用AbstractRoutingDataSource
配置多个 SqlSessionFactory
前言
阅读了一下spring的源码,由于 spring 事务的机制,在开启事务之前spring 会去创建当前数据源的 事务object,直到事务提交,spring 都不会在乎你是否切换了数据源。这就导致了,使用 AbstractRouting DataSource 方式开启事务时,切换数据源不生效。
关于如何解决这个问题,感兴趣的朋友可以去阅读一下:https://www.jianshu.com/p/61e8961c6154
本文只讨论上述第二种方式结合 atomikos 管理多数据源事务。
Atomikos
来自:http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-jta.html
Atomikos is a popular open source transaction manager which can be embedded into your Spring Boot application. You can use the
spring-boot-starter-jta-atomikos
Starter to pull in the appropriate Atomikos libraries. Spring Boot auto-configures Atomikos and ensures that appropriatedepends-on
settings are applied to your Spring beans for correct startup and shutdown ordering.By default, Atomikos transaction logs are written to a
transaction-logs
directory in your application's home directory (the directory in which your application jar file resides). You can customize the location of this directory by setting aspring.jta.log-dir
property in yourapplication.properties
file. Properties starting withspring.jta.atomikos.properties
can also be used to customize the AtomikosUserTransactionServiceImp
. See theAtomikosProperties
Javadoc for complete details.
引入spring-boot-starter-jta-atomikos,spring boot 为我们自动配置
Atomikos,我们可以通过 spring.jta.xxx
修改默认配置。
Talk is cheap. Show me the code
demo源码:https://gitee.com/yintianwen7/taven-springboot-learning/tree/master/spring-atomikos
添加 maven 依赖
org.springframework.boot
spring-boot-starter-jta-atomikos
com.alibaba
druid-spring-boot-starter