|
|
|
|
|
|
|
PROPERTY: |
|
|
|
|
isolationLevel |
|
|
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
Determines the isolation level of a transaction. |
||
|
|
|
|
|
|
|
PROPERTY OF: |
|
|
|
|
|
||
|
|
|
||
|
|
VALUE: |
EFFECT: |
|
|
|
0 |
Read Uncommitted (Uncommitted changes in other transactions are visible) |
|
|
|
1 |
Read Committed (Changes from other transactions only visible after being committed) (Default) |
|
|
|
2 |
Repeatable Read (Changes made in other transactions not visible, but requerying can retrieve new data) |
|
|
|
3 |
Serializable (Transactions conducted in isolation from other transactions) |
|
|
|
|
||
|
|
DESCRIPTION: |
|
|
|
|
The isolationLevel property is an enumerated property that determines the isolation level of a transaction. |
||
|
|
|
||
|
|
The setting does not take effect until the next time you call the beginTrans() method. |
||
|
|
|
||
|
|
If the level of isolation you request is unavailable, the provider may return the next greater level of isolation without updating the isolationLevel property. |
||
|
|
|
||
|
|
Use isolationLevel property to specify the transaction isolation level for a connection. |
||
|
|
The transaction isolation level determines how a transaction interacts with other simultaneous transactions when they work with the same tables, |
||
|
|
and how much a transaction sees of the work performed by other transactions. |
||
|
|
|
||
|
|
Read isolationLevel property after the transaction has been activated to determine the actual transaction isolation level used. |
||
|
|
|
||
|
|
It is possible that a server will force an isolation level other than that requested if the level requested is not supported. |
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|