主页 / dba / 问题 / 275164
Accepted
Joe Hayes
Asked: 2020-09-09 09:14:39 +0800 CST

SQL Server 分布式事务：xp_sqljdbc_xa_commit 与 xp_sqljdbc_xa_end

  • 772

在 SQL Server 2019 中，谁能明确告诉我 xp_sqljdbc_xa_commit 和 xp_sqljdbc_xa_end 之间的功能区别？

我的猜测是 commit 正在尝试提交事务（谢谢 Obvious 先生 ;-)）并且 end 告诉 DTC “嘿，这里都完成了。请清理。”

但是，代码似乎存在于 SQLJDBC_XA.dll（作为扩展 sp）中，所以我无法查看它，也找不到一个好的参考来确认我的假设。

谢谢！

sql-server stored-procedures

1 个回答

  1. Best Answer

    GitHub 上的 SQL Server JDBC 驱动程序的源代码是追踪这一点的好地方。

    @Override
public void end(Xid xid, int flags) throws XAException {
    // Called by the transaction mgr after the app closes the connection it was given from this physical
    // connection
    /*
     * Ends the work performed on behalf of a transaction branch. The resource manager disassociates the XA resource
     * from the transaction branch specified and let the transaction be completed. If TMSUSPEND is specified in
     * flags, the transaction branch is temporarily suspended in incomplete state. The transaction context is in
     * suspened state and must be resumed via start with TMRESUME specified. If TMFAIL is specified, the portion of
     * work has failed. The resource manager may mark the transaction as rollback-only. If TMSUCCESS is specified,
     * the portion of work has completed successfully.
     */
    DTC_XA_Interface(XA_END, xid, flags | tightlyCoupled);
}

    src/main/java/com/microsoft/sqlserver/jdbc/SQLServerXAResource.java

    所以它被 SQL Server 的XAResource接口的实现所使用。

    有关背景，请参阅它的工作原理：SQL Server DTC（MSDTC 和 XA 事务）

    • 1

相关问题