skip to main content
OpenAccess SDK Service Attributes : Defining Service Attributes : DataSourceTransactionIsolation
 

DataSourceTransactionIsolation

Specifies the transaction isolation level used for the connection.

Valid values

Committed | Uncommitted | RepeatableRead | Serializable | Not supported
*Committed: Dirty reads are not possible. Phantoms and reads that cannot be repeated are possible.
*Uncommitted: Phantoms, dirty reads, and reads that cannot be repeated are possible.
*RepeatableRead: Dirty reads and reads that cannot be repeated are not possible. Phantoms are possible.
*Serializable: Transactions can be serialized. Phantoms, dirty reads, and reads that cannot be repeated are not possible.
*Not supported: OpenAccess SDK cannot set the transaction isolation level. The DBMS default transaction isolation level will be used.
Refer to your database documentation for a definition of each isolation level.

Default

Not supported

Type

Dynamic