| 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 |