Isolation levels define the degree to which the operations in one transaction are visible to the operations in other concurrent transactions. UltraLite uses the default isolation level, read_committed, for connections. The default UltraLite isolation level aids data consistency by isolating uncommitted rows.
|This isolation level...||Has these characteristics...|
You can change the isolation level from read_committed to read_uncommitted using one of following approaches:
Use the SET OPTION SQL statement and the isolation_level database option.
For example, the following statement sets the isolation level to read uncommitted:
SET OPTION isolation_level = 'READ_UNCOMMITTED'
For the UltraLite C++ API, use the ULConnection.SetDatabaseOption method to change the isolation level.
For the UltraLite.NET API, use the ULConnection.BeginTransaction or ULDatabaseSchema.SetDatabaseOption methods to create a transaction with the read_committed isolation level.
For the UltraLiteJ API, use the Connection.setOption method.
UltraLite Java edition databases only support the read_uncommitted isolation level. See Data synchronization on a BlackBerry smartphone.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|