Home How To Online Documentation Support Download Order

 

 

 

SACommand
SAConnection
SAException
SAField
SAParam

SAString
SADateTime
SANumeric
SAInterval

Enums and Typedefs

  

Usage

Class Members

Examples

SAConnection::setIsolationLevel

void setIsolationLevel(SAIsolationLevel_t eIsolationLevel );
throw (SAException);

Sets the transaction isolation level.

Parameters

eIsolationLevel.    One of the following values from SAIsolationLevel_t enum:

  • SA_ReadUncommitted    Read uncommitted.
  • SA_ReadCommitted    Read committed.
  • SA_RepeatableRead    Repeatable read.
  • SA_Serializable    Serializable.

Remarks

Sets the transaction isolation level.

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)

See Server Specific Guide section for information about how SQLAPI++ maps different isolation levels on a specified DBMS.

Note that if you change isolation level it causes implicit commit for this connection.

See also

IsolationLevel 

Error handling

Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.