Setting Isolation Levels

SourcePro : DB Access Module for Sybase User’s Guide : Technical Information : Transaction Processing : Setting Isolation Levels

You can use the isolation() method of RWDBConnection to set the isolation level of the connection. Table 5 shows the mapping between the RWDBConnection::IsolationType argument you pass and the isolation level set on the connection.

Table 5 – Setting the isolation level
RWDBConnection::IsolationType	Sybase Isolation Level
Unknown	Level 1 - READ COMMITTED
ANSILevel1	Level 1 - READ COMMITTED
ANSILevel2	Level 2 - REPEATABLE READ
ANSILevel3	Level 3 - SERIALIZABLE

The current isolation level can be determined by calling the function RWDBConnection::isolation() without an argument.