Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Transaction processing is a mandatory requirement of all applications that must guarantee consistency of their persistent data. With the Microsoft JDBC Driver for SQL Server, transaction processing can either be performed locally or distributed. Transactions are atomic, consistent, isolated, and durable (ACID) modules of execution.
The articles in this section describe how the JDBC driver supports transactions including isolation levels, transaction savepoints, and result set holdability.
Article | Description |
---|---|
Understanding transactions | Provides an overview of how transactions are used with the JDBC driver. |
Understanding XA transactions | Provides an overview of how XA transactions are used with the JDBC driver. |
Understanding isolation levels | Describes the various isolation levels that are supported by the JDBC driver. |
Using savepoints | Describes how to use the JDBC driver with transaction savepoints. |
Using holdability | Describes how to use the JDBC driver with result set holdability. |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Documentation
Understanding transactions - JDBC Driver for SQL Server
Learn about transactions and how to group logical units of work that need to maintain consistent data across multiple database operations.
setResponseBuffering Method (SQLServerStatement) - JDBC Driver for SQL Server
setResponseBuffering Method (SQLServerStatement)
Using statements with SQL - JDBC Driver for SQL Server
Learn an overview of using different types of SQL statements with the Microsoft JDBC Driver for SQL Server.