I get two methods below: I would run both methods concurrently.
However, the "testRead" would always read the uncommitted results from "testInsert".
Anyway to avoid that? Thanks.
ClassMethod testInsert() { &sql(START TRANSACTION ISOLATION LEVEL READ COMMITTED, READ WRITE) &sql(insert into Test.Table(AttrA,AttrB,AttrC,AttrD) values(1,2,3,4)) hang 15 &sql(ROLLBACK) } ClassMethod testRead() { &sql(START TRANSACTION ISOLATION LEVEL READ COMMITTED) &sql(select count(*) into :ans from Test.Table) &sql(COMMIT) w !,ans }