test1: 
start tx
acquire connection
insert data into db

acquire non transactional connection
query database -> ensure that data inserted above
is not read since the tx is yet to commit and this
connection is not part of that tx

commit tx


test2:
start tx

acquire connection
ensure that the autoCommit value is false

for i = 1 to 20
    acquire non-tx connection
    ensure that the autoCommit value is true


acquire connection
ensure that the autoCommit value is false

commit tx