Creating table...
done creating table and inserting data.
testHoldability with HOLD_CURSORS_OVER_COMMIT
testStatements()
checkResultSet before commit
11, testtable1-one
checkResultSet after commit
12, testtable1-two
checkResultSet before commit
21, testtable2-one
checkResultSet after commit
EXPECTED EXCEPTION:ResultSet not open.  Verify that autocommit is OFF.
testStatementsInProcedure()
checkResultSet before commit
11, testtable1-one
checkResultSet before commit
21, testtable2-one
checkResultSet after commit
11, testtable1-one
checkResultSet after commit
EXPECTED:ResultSet is null
testHoldability with CLOSE_CURSORS_AT_COMMIT
testStatements()
checkResultSet before commit
11, testtable1-one
checkResultSet after commit
12, testtable1-two
checkResultSet before commit
21, testtable2-one
checkResultSet after commit
EXPECTED EXCEPTION:ResultSet not open.  Verify that autocommit is OFF.
testStatementsInProcedure()
checkResultSet before commit
11, testtable1-one
checkResultSet before commit
21, testtable2-one
checkResultSet after commit
11, testtable1-one
checkResultSet after commit
EXPECTED:ResultSet is null
Start multi table query with holdability true test
value of t2.c22 is 1
value of t2.c22 is 2
Multi table query with holdability true test over
Start isolation level change test
Switch isolation while there are open cursors
Should see exceptions
ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
PASS: Can't change isolation if they are open cursor
Isolation level change test over
testCloseCursor()