isolate()

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

Here’s how to use isolate() function.

db.isolate()

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

Parameters:

db

Database connection

Return value:

The orignal 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()