Adapter for JDBC supports the setting of transaction isolation levels on a database. These settings prevent dirty read, repeatable read, and phantom read of the database. The type of isolation levels supported by the adapter depends on the database that you are connecting to. The commonly used isolation levels are TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, and TRANSACTION_SERIALIZABLE.

Adapter for JDBC supports all the isolation level settings supported by your database, for example, the isolation level SNAPSHOT for MS SQL Server 2005.

The isolation level settings can be specified in the Other Properties field of the Connection Configuration screen, while configuring a connection. For more information about specifying these levels, see Configuring Adapter for JDBC Connections.