| title | setTransactionIsolation Method (SQLServerConnection) |
|---|---|
| description | setTransactionIsolation Method (SQLServerConnection) |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 01/19/2017 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | reference |
| apilocation | sqljdbc.jar |
| apiname | SQLServerConnection.setTransactionIsolation |
| apitype | Assembly |
[!INCLUDEDriver_JDBC_Download]
Tries to change the transaction isolation level for this SQLServerConnection object to the one given.
public void setTransactionIsolation(int level)
level
An int value that contains one of the following isolation levels:
TRANSACTION_READ_UNCOMMITTED
TRANSACTION_READ_COMMITTED
TRANSACTION_REPEATABLE_READ
TRANSACTION_SERIALIZABLE
TRANSACTION_SNAPSHOT = 0x1000
This setTransactionIsolation method is specified by the setTransactionIsolation method in the java.sql.Connection interface.
Transactions are not committed if this method is called in the middle of a transaction.