|
AnyDAC
|
   |
   |
TADTxOptions.Isolation Property
|
AnyDAC
|
|
|
Specifies the transaction isolation level for the transactions managed by AnyDAC.
Use Isolation property to specify transaction isolation level for next transactions in current session. Changing of an isolation level does not affect a currently active transaction. The default value is xiReadCommitted.
The Isolation property value is DBMS independent and is translated into most close by meaning native DBMS isolation level.
|
Level |
Description |
|
xiUnspecified |
Use default DBMS isolation level. |
|
xiDirtyRead |
Permits reading of uncommitted changes made to the database by other simultaneous transactions. Uncommitted changes are not permanent, and might be rolled back (undone) at any time. At this level a transaction is least isolated from the effects of other transactions. |
|
xiReadCommitted |
Permits reading of committed (permanent) changes made to the database by other simultaneous transactions. This is the default Isolation property value. |
|
xiRepeatableRead |
Permits a single, one-time reading of the database. The transaction cannot see any subsequent changes made by other simultaneous transactions. This isolation level guarantees that once a transaction reads a record, its view of that record does not change unless it makes a modification to the record itself. At this level, a transaction is most isolated from other transactions. |
|
xiSnapshot |
|
|
xiSerializible |
|
property Isolation: TADTxIsolation;
|
What do you think about this topic? Send feedback!
|