isolate()

Read(2450) Label: set, transaction, isolation level,

Here’s how to use isolate() function.

db.is olate()

Description:

Define transaction isolation level for the connection according to the option and return the original level.

Syntax:

db.isolate()

Note:

The function sets transaction isolation level for the connection according to the option and returns the original level, i.e. its corresponding character of the option. Establish the connection via JDBC by default if no option is used.

Option:

@ncurs

Correspond to NONE,READ_COMMITTED,READ_UNCOMMITTED,REPEATABLE_READ,SERIALIZABLE respectively

Parameter:

db

Database connection

Return value:

The original level of the database connection

Example:

 

A

 

1

=connect("demo")

 

2

=A1.isolate@r()

Set transaction isolation level as REPEATABLE_READ and return the original level " c".

Related functions:

connect()