By default, the isolation level in the solidDB server is ‘Read Committed’ (SQL.IsolationLevel=1). You can also set the isolation level at a transaction level or a session level by using SQL commands.
To set the server-wide isolation level, use the SQL.IsolationLevel parameter. The parameter accepts the following values:
▪ 1 (Read Committed)
▪ 2 (Repeatable Read)
▪ 3 (Serializable) - supported only with disk-based tables
To override the server-wide isolation level for a specific session, use the SET ISOLATION LEVEL SQL statement, see SET ISOLATION LEVEL. For example:
SET ISOLATION LEVEL REPEATABLE READ
To override the server-wide isolation level for a specific transaction, use the SET TRANSACTION ISOLATION LEVEL SQL statement, see SET TRANSACTION ISOLATION LEVEL. For example: