Fetching result sets with getMoreResults()  PASS 1 got result set true     RS (1) val 2  PASS 2 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (2) val 3  PASS 3 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (3) val 4  PASS 4 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (4) val 5  PASS 5 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (5) val 6     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.Fetching result sets with getMoreResults(Statement.CLOSE_CURRENT_RESULT)  PASS 1 got result set true     RS (1) val 2  PASS 2 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (2) val 3  PASS 3 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (3) val 4  PASS 4 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (4) val 5  PASS 5 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (5) val 6     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.Fetching result sets with getMoreResults(Statement.CLOSE_ALL_RESULTS)  PASS 1 got result set true     RS (1) val 2  PASS 2 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (2) val 3  PASS 3 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (3) val 4  PASS 4 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (4) val 5  PASS 5 got result set true     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (5) val 6     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT)  PASS 1 got result set true     RS (1) val 2  PASS 2 got result set true     RS (1) val 3     RS (2) val 3  PASS 3 got result set true     RS (1) val 4     RS (2) val 4     RS (3) val 4  PASS 4 got result set true     RS (1) val 5     RS (2) val 5     RS (3) val 5     RS (4) val 5  PASS 5 got result set true     RS (1) val 6     RS (2) val 6     RS (3) val 6     RS (4) val 6     RS (5) val 6     RS (1) val 7     RS (2) val 7     RS (3) val 7     RS (4) val 7     RS (5) val 7Fetching result sets with getMoreResults(<mixture>) first two with KEEP_CURRENT_RESULT     RS (1) val 2     RS (2) val 3 third with CLOSE_CURRENT_RESULT     RS (1) val 3     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (3) val 4 fourth with KEEP_CURRENT_RESULT     RS (1) val 4     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (3) val 5     RS (4) val 5 fifth with CLOSE_ALL_RESULTS     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (5) val 6 no more results with with KEEP_CURRENT_RESULT     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     RS (5) val 7Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT) and checking that cs.execute() closes them  PASS 1 got result set true     RS (1) val 2  PASS 2 got result set true     RS (1) val 3     RS (2) val 3  PASS 3 got result set true     RS (1) val 4     RS (2) val 4     RS (3) val 4  PASS 4 got result set true     RS (1) val 5     RS (2) val 5     RS (3) val 5     RS (4) val 5  PASS 5 got result set true     RS (1) val 6     RS (2) val 6     RS (3) val 6     RS (4) val 6     RS (5) val 6 fetched all results     RS (1) val 7     RS (2) val 7     RS (3) val 7     RS (4) val 7     RS (5) val 7 executing statement     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT) and checking that cs.close() closes them  PASS 1 got result set true     RS (1) val 2  PASS 2 got result set true     RS (1) val 3     RS (2) val 3  PASS 3 got result set true     RS (1) val 4     RS (2) val 4     RS (3) val 4  PASS 4 got result set true     RS (1) val 5     RS (2) val 5     RS (3) val 5     RS (4) val 5  PASS 5 got result set true     RS (1) val 6     RS (2) val 6     RS (3) val 6     RS (4) val 6     RS (5) val 6 fetched all results     RS (1) val 7     RS (2) val 7     RS (3) val 7     RS (4) val 7     RS (5) val 7 closing statement     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.