This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
Hi,
I can see on this page how to enable XA :-
https://learn.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions?view=sql-server-ver16
However I am curious about how to manage transaction timeouts with SQL Server on Linux. On Windows you can set the XA timeout by configuring MS DTC and the timeout (which defaults to 60 seconds) via component services. Is there a default XA timeout with SQL Server on Linux and if so what is it and can it be increased please?
Thanks
Rod
Hi，Rod-4091，We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Hi，Rod-4091
SQL Server does not directly provide control over transaction timeouts. Transaction timeouts are generally considered at the application level. The MS DTC you mentioned is also invoked through .NET System.Transactions.Configuration.
MachineSettingsSection.MaxTimeout Property
How to configure the Microsoft Distributed Transaction Coordinator (MSDTC) on Linux
Here are some additional links for implementing a transaction timeout mechanism.
SqlCommand.CommandTimeout Property
Understanding timeout properties in the JDBC driver
TransactionManager.DefaultTimeout Property
Regards
Mikey Qiao
If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.