Join the Customer Advisory Board

 View Only

 Error code is: XAER_NOTA (-4)

A Radha Krishna Reddy Reddy's profile image
A Radha Krishna Reddy Reddy posted Tue March 31, 2026 02:27 AM

we are using 25.0.0.11-Liberty. JDK 17, Spring 6x, mssql-jdbc-12.10.2.jre11.jar jdbc driver

E DSRA0302E: XAException occurred. Error code is: XAER_NOTA (-4). Exception is: The function COMMIT: failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_commit, state=1, StatusCode:-4 (0xFFFFFFFC) ***"

We already enabled the datasource type as type="javax.sql.XADataSource" in server.xml but observing the above exception.

Is it MANDATORY to enable "Enable XA Transactions" in Windows
Component Services (MSDTC properties) on the SQL Server machine?
Does this apply to:

  • Development/QA?
  • Production?
    Or any other reason?Image
LEON FORET's profile image
LEON FORET posted Wed April 01, 2026 11:30 AM

Based on my cursory research, the short answer is yes. However, it would be prudent to open a case with product support as there is likely some nuance. 

https://learn.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions?view=sql-server-ver17

Related Content