GBase 8s
运维管理
文章

sysdbopen

GBase社区管理员
发表于2023-05-16 10:20:2835次浏览0个评论

create procedure "public".sysdbopen()

set isolation to dirty read;

set lock mode to wait 30;

end procedure ;

 

可以设置的几种隔离级:

set isolation to dirty read;

set isolation committed read;

set isolation to cursor stability;

set isolation to committed read last committed;

set isolation to repeatable read;

 

JDBC连接字符串:

IFX_ISOLATION_LEVEL=2;IFX_LOCK_MODE_WAIT=10;

评论已关闭