XA实现多数据源事务

宇1990

已于 2022-04-15 15:29:34 修改

阅读量406

点赞数

分类专栏： JavaBase mybatis 文章标签： java

于 2022-04-15 15:25:21 首次发布

本文链接：https://blog.csdn.net/wenzhenyu1990/article/details/124195854

版权

JavaBase 同时被 2 个专栏收录

38 篇文章 0 订阅

订阅专栏

mybatis

1 篇文章 0 订阅

订阅专栏

多数据源事务

boolean logXaCommand = true;
        Connection localConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8","root","123456");
        XAConnection xaLocal = new MysqlXAConnection((com.mysql.cj.jdbc.JdbcConnection)localConn,logXaCommand);
        XAResource localResource = xaLocal.getXAResource();

        Connection onlineConn = DriverManager.getConnection("jdbc:mysql://ip:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8","username","password");

        XAConnection xaOnline = new MysqlXAConnection((JdbcConnection)onlineConn,logXaCommand);
        XAResource onlineResource = xaOnline.getXAResource();

        byte[] globalTransactionId = "global_123456".getBytes();
        int formatId = 1;
        try{
            byte[] branchTransactionId = "branch_123456".getBytes();
            Xid xid1 = new MysqlXid(globalTransactionId,branchTransactionId,formatId);
            localResource.start(xid1,XAResource.TMNOFLAGS);
            PreparedStatement statement = localConn.prepareStatement("insert into market(market_name) values('"+System.currentTimeMillis()+"')");
            statement.execute();
            localResource.end(xid1,XAResource.TMSUCCESS);

            byte[] branchTransactionIdTwo = "branch_888888".getBytes();
            Xid xid2 = new MysqlXid(globalTransactionId,branchTransactionIdTwo,formatId);
            onlineResource.start(xid2,XAResource.TMNOFLAGS);
            PreparedStatement preparedStatement = onlineConn.prepareStatement("insert into student(username) values('admin_username')");
            preparedStatement.execute();
            onlineResource.end(xid2,XAResource.TMSUCCESS);

            int localPrepare = localResource.prepare(xid1);
            int onlinePrepare = onlineResource.prepare(xid2);
            boolean oneParse = false;
            if(localPrepare == XAResource.XA_OK && onlinePrepare == XAResource.XA_OK){
                localResource.commit(xid1,oneParse);
                onlineResource.commit(xid2,oneParse);
            }else{
                localResource.rollback(xid1);
                onlineResource.rollback(xid2);
            }

        }catch (XAException e){
            e.printStackTrace();
        }