Cloudscape Properties
Page 19 of 47

cloudscape.language.defaultIsolationLevel

Function

Sets the default isolation level for the system.

  • READ_COMMITTED corresponds to java.sql.Connection.TRANSACTION_READ_COMMITTED and to ANSI level 1 and is the default isolation level for a Cloudscape system.
  • REPEATABLE_READ corresponds to java.sql.Connection.TRANSCTION_REPEATABLE_READ (ANSI level 2).
  • SERIALIZABLE corresponds to java.sql.Connection.TRANSACTION_SERIALIZABLE (ANSI level 3).

NEW: Support for TRANSACTION_REPEATABLE_READ is new in Version 3.6.

The values are case-insensitive.

Syntax

cloudscape.language.defaultIsolationLevel =
{
    SERIALIZABLE |
    READ_COMMITTED |
    REPEATABLE_READ
}

Default

READ_COMMITTED.

Example

-- system-wide property
cloudscape.language.defaultIsolationLevel=SERIALIZABLE

-- database-wide property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.language.defaultIsolationLevel',
    'SERIALIZABLE')

-- publishing a database-wide property
ALTER PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.language.defaultIsolationLevel=
    'SERIALIZABLE'

Scope

system-wide

database-wide (publishable)

Dynamic or Static

This property is static; if you change it while Cloudscape is running, the change does not take effect until you reboot.