maven引入相应的Atomikos依赖类库,除此之外还需要mysql和oracle的jdbc驱动类
com.atomikos transactions-jdbc4.0.6 javax.transaction jta1.1 .... org.springframework spring-tx${spring-version}
增加spring配置文件(这里数据库用户密码留空)
true 10 Oracle数据源 oracle_sources_ds oracle.jdbc.xa.client.OracleXADataSource flow jdbc:oracle:thin:@//192.168.0.101/orcl select sysdate from dual jdbc:mysql://localhost:3306/car root true
发起分布式事务示例代码,这样你可以测试以下两个update语句符合ACID的特性,测试的方法可以将第二条Oracle执行的update SQL字符加长,最终结果发现Mysql的update语句没有被提交
public class TestAtomikos {
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext("base_jta.xml");
PlatformTransactionManager transactionManager = context.getBean(PlatformTransactionManager.class);
DefaultTransactionDefinition definition = new DefaultTransactionDefinition();
TransactionStatus transaction = transactionManager.getTransaction(definition);
DataSource orcl = context.getBean("firstDb", DataSource.class);
DataSource mysql = context.getBean("secondDb", DataSource.class);
try (Connection mysqlConn = mysql.getConnection(); Connection orclConn = orcl.getConnection();) {
Statement mysqlStat = mysqlConn.createStatement();
String usql = "UPDATE LOGIN_LOG w SET w.USERNAME ='Mysql Name' WHERe w.ID ='a1'";
mysqlStat.executeUpdate(usql);
Statement orclStat = orclConn.createStatement();
String updateSql = "UPDATE LOGIN_LOG w SET w.USERNAME ='Oracle Name' WHERe w.ID ='a2'";
orclStat.executeUpdate(updateSql);
transactionManager.commit(transaction);
} catch (Exception e) {
e.printStackTrace();
transactionManager.rollback(transaction);
}
}
}



