Transaction processing is a mandatory requirement of all applications that must guarantee consistency of their persistent data. With the Microsoft SQL Server 2005 JDBC Driver, transaction processing can either be performed locally or distributed. Transactions are atomic, consistent, isolated, and durable (ACID) modules of execution.

The topics in this section describe how the JDBC driver supports transactions including isolation levels, transaction savepoints, and result set holdability.

In This Section

Topic 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.

See Also