Transaction isolation refers to the degree of interaction between multiple concurrent transactions. SQL-92 defines four isolation levels, all of which are supported by SQLAPI++:
Read uncommitted (the lowest level where transactions are isolated just enough to ensure that physically corrupt data is not read)
Read committed
Repeatable read
Serializable (the highest level, where transactions are completely isolated from one another)
SQLAPI++ maps different isolation levels on underlying DBMS. You can set transaction isolation level explicitly by calling SAConnection::setIsolationLevel .
If you didn't set transaction isolation level explicitly then the Library uses the default DBMS transaction settings. See DBMS documentation to get information concerning the default transaction isolation level
.
No comments:
Post a Comment