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