多数据源，全局事务无效，是否需要其他配置

[momolela]

多数据源，全局事务无效，是否需要其他配置

数据源配置

程序启动的时候，还有这样的打印

程序测试事务，在controller类中调用下面方法

当/0报错没有回滚

@louislivi 请问是否需要其他配置？

[momolela]

启动时候的打印
2020-10-13 10:06:52.408 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.408 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.410 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.412 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.412 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.412 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.414 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.417 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?
2020-10-13 10:06:52.418 WARN 16008 --- [ main] c.atomikos.jdbc.AtomikosConnectionProxy : atomikos connection proxy for oracle.jdbc.driver.T4CConnection@148fca83: WARNING: transaction manager not running?

[momolela]

测试方法
@transactional
public void transactionTest(String num) {
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
Map<String, Object> insertParam1 = new HashMap<>();
insertParam1.put("INMSG", "10000");
insertParam1.put("OUTMSG", "10000");
insertParam1.put("SUCMSG", "10000");
insertParam1.put("ERRMSG", "10000");
insertParam1.put("DATETIME", LocalDate.parse("2020-10-12", formatter).format(formatter));
haiLogMapper.insertMsgCount(insertParam1);
int haha = 1 / Integer.parseInt(num);
Map<String, Object> insertParam2 = new HashMap<>();
insertParam2.put("INMSG", "20000");
insertParam2.put("OUTMSG", "20000");
insertParam2.put("SUCMSG", "20000");
insertParam2.put("ERRMSG", "20000");
insertParam2.put("DATETIME", LocalDate.parse("2020-10-12", formatter).format(formatter));
haiLogMapper.insertMsgCount(insertParam2);
}

[momolela]

`# fastdep 支持多数据源
fastdep:
datasource:
base:
mapper: hai.mcentre.mapper.base
driver-class-name: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@127.0.0:1521/orcl
username: xxx
password: xxx
initialSize: 10
minIdle: 5
maxActive: 100
maxWait: 10000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
removeAbandoned: true
removeAbandonedTimeout: 180
keepAlive: true
log:
mapper: hai.mcentre.mapper.log
driver-class-name: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@127.0.0.1:1521/orcl
username: xxx
password: xxx
initialSize: 10
minIdle: 5
maxActive: 100
maxWait: 10000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
removeAbandoned: true
removeAbandonedTimeout: 180
keepAlive: true

mybatis

mybatis:
mapper-locations: classpath:mybatis/mapper/*.xml
config-location: classpath:mybatis/mybatis-config.xml`

[louislivi]

你可以将fastdep-test基础的改为你的数据源信息进行测试，先排查是否是你设置了事物bean或者注入了一些额外的事物数据源相关bean，导致全局事物失效。