atomikos分布式事务的几个坑

时间:2023-01-06 09:07:02

atomikos几个坑:
1.jta.properties:
com.atomikos.icatch.output_dir=/datayes/atomikos
com.atomikos.icatch.log_base_dir=/datayes/atomikos
若一个tomcat上有两个atomikos应用,则两个应用不要公用同一位置

2.datasource的用户名密码url不对,应用启动会失败,而且什么错误日志也没有,日志打到中间就没有新的日志输出了。

3.MySQL XA bug
Some users have reported problems with MySQL XA (related to this MySQL bug: http://bugs.mysql.com/bug.php?id=27832external). This problem only happens if you access the same MySQL database more than once in the same transaction. A workaround can be setting the following property in jta.properties:

com.atomikos.icatch.serial_jta_transactions=false
Also, make sure to set the following property on the MySQL datasource:

pinGlobalTxToPhysicalConnection="true"
MariaDB's java driver also supports this workaround since v.1.1.8