?? holdcursorjava.out
字號:
Creating table...done creating table and inserting data.testHoldability with HOLD_CURSORS_OVER_COMMITtestStatements()checkResultSet before commit11, testtable1-onecheckResultSet after commit12, testtable1-twocheckResultSet before commit21, testtable2-onecheckResultSet after commitEXPECTED EXCEPTION:Invalid operation: result set closedtestStatementsInProcedure()checkResultSet before commit11, testtable1-onecheckResultSet before commit21, testtable2-onecheckResultSet after commit11, testtable1-onecheckResultSet after commitEXPECTED:ResultSet is nulltestHoldability with CLOSE_CURSORS_AT_COMMITtestStatements()checkResultSet before commit11, testtable1-onecheckResultSet after commit12, testtable1-twocheckResultSet before commit21, testtable2-onecheckResultSet after commitEXPECTED EXCEPTION:Invalid operation: result set closedtestStatementsInProcedure()checkResultSet before commit11, testtable1-onecheckResultSet before commit21, testtable2-onecheckResultSet after commit11, testtable1-onecheckResultSet after commitEXPECTED:ResultSet is nullStart multi table query with holdability true testvalue of t2.c22 is 1value of t2.c22 is 2Multi table query with holdability true test overStart isolation level change testSwitch isolation while there are open cursorsShould see exceptionsERROR X0X03: Invalid transaction state - held cursor requires same isolation levelPASS: Can't change isolation if they are open cursorIsolation level change test over
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -