📄 xatest.out
字号:
initial Connection holdable HOLD_CURSORS_OVER_COMMIT 1singleConnectionOnePhaseCommitXA Connection holdable CLOSE_CURSORS_AT_COMMIT 2XA Statement holdable CLOSE_CURSORS_AT_COMMIT 2A -----0 GXID |STATUS |READONLY |USERNAME |TYPE -----(0 |ACTIVE |false |APP |UserTransaction interleavingTransactionsGXID |STATUS |READONLY |USERNAME |TYPE -----(1 |ACTIVE |false |SKU |UserTransaction (2 |ACTIVE |false |SKU |UserTransaction GXID |STATUS |READONLY |USERNAME |TYPE -----(1 |ACTIVE |false |SKU |UserTransaction (2 |ACTIVE |false |SKU |UserTransaction GXID |STATUS |READONLY |USERNAME |TYPE -----(1 |PREPARED |false |SKU |UserTransaction (2 |PREPARED |false |SKU |UserTransaction recovered start 2recovered 0recovered end 0GXID |STATUS |READONLY |USERNAME |TYPE -----(3 |IDLE |NULL |SKU |UserTransaction A -----0 1 3 noTransactionmorphGXID |STATUS |READONLY |USERNAME |TYPE -----GXID |STATUS |READONLY |USERNAME |TYPE -----GXID |STATUS |READONLY |USERNAME |TYPE -----(1 |IDLE |NULL |APP |UserTransaction OK: query with holdable statementStatement created in global has holdabilty: falseA -----2001 2002 2003 GXID |STATUS |READONLY |USERNAME |TYPE -----(1 |PREPARED |false |APP |UserTransaction (1 |IDLE |NULL |APP |UserTransaction GXID |STATUS |READONLY |USERNAME |TYPE -----A -----2001 2002 2003 2005 2007 A -----DERBY-1004 Call conn.rollback to avoid exception with clientA -----2001 2002 2003 2005 2007 Correct XAException on starting a global transaction with an active local transaction (autocommit false)DERBY-341 - Client skipping XAConnection with active local transactionA -----A -----2001 2002 2003 2005 2007 derby966Local Connection holdable HOLD_CURSORS_OVER_COMMIT 1Local(held) default Statement holdable HOLD_CURSORS_OVER_COMMIT 1FAIL - mismatched statement & ConnectionResultSet HOLD_CURSORS_OVER_COMMIT 1 BC A=0 AC A=1 AC A=3 AC A=2001 AC A=2002 AC A=2003 AC A=2005 AC A=2007Local(held) default PreparedStatement holdable HOLD_CURSORS_OVER_COMMIT 1FAIL - mismatched statement & ConnectionResultSet HOLD_CURSORS_OVER_COMMIT 1 BC A=0 AC A=1 AC A=3 AC A=2001 AC A=2002 AC A=2003 AC A=2005 AC A=2007Local(held) held Statement holdable HOLD_CURSORS_OVER_COMMIT 1FAIL - mismatched statement & ConnectionResultSet HOLD_CURSORS_OVER_COMMIT 1 BC A=0 AC A=1 AC A=3 AC A=2001 AC A=2002 AC A=2003 AC A=2005 AC A=2007Local(held) held PreparedStatement holdable HOLD_CURSORS_OVER_COMMIT 1FAIL - mismatched statement & ConnectionResultSet HOLD_CURSORS_OVER_COMMIT 1 BC A=0 AC A=1 AC A=3 AC A=2001 AC A=2002 AC A=2003 AC A=2005 AC A=2007Local(held) close Statement holdable CLOSE_CURSORS_AT_COMMIT 2FAIL - mismatched statement & ConnectionResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(held) close PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2FAIL - mismatched statement & ConnectionResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) default Statement holdable CLOSE_CURSORS_AT_COMMIT 2FAIL - mismatched statement & ConnectionResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) default PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2FAIL - mismatched statement & ConnectionResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) held Statement holdable HOLD_CURSORS_OVER_COMMIT 1FAIL - mismatched statement & ConnectionResultSet HOLD_CURSORS_OVER_COMMIT 1 BC A=0 AC A=1 AC A=3 AC A=2001 AC A=2002 AC A=2003 AC A=2005 AC A=2007Local(close) held PreparedStatement holdable HOLD_CURSORS_OVER_COMMIT 1FAIL - mismatched statement & ConnectionResultSet HOLD_CURSORS_OVER_COMMIT 1 BC A=0 AC A=1 AC A=3 AC A=2001 AC A=2002 AC A=2003 AC A=2005 AC A=2007Local(close) close Statement holdable CLOSE_CURSORS_AT_COMMIT 2FAIL - mismatched statement & ConnectionResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) close PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2FAIL - mismatched statement & ConnectionResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitBGBC 0BGAC 1START GLOBAL TRANSACTIONGlobal transaction open ResultSets 12EXPECTED SQLSTATE(XJ05C): Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.Global createStatement(hold)Statement holdable CLOSE_CURSORS_AT_COMMIT 201J07 :org.apache.derby.client.am.SqlWarning: ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.Global prepareStatement(hold)Statement holdable HOLD_CURSORS_OVER_COMMIT 1After global transaction closed ResultSets 12Global xact Statement sdh Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement shh Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement sch Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement psdh Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement pshh Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement psch Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement sdc Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement shc Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement scc Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement psdh_d Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement pshh_d Statement holdable HOLD_CURSORS_OVER_COMMIT 1Global xact Statement psch_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2derby966 completeXATest complete⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -