📄 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 Statement 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 -----------A -----------2001 2002 2003 2005 2007 Correct XAException on starting a global transaction with an active local transaction (autocommit false)EXPECTED SQLSTATE(XJ059): Cannot close a connection while a global transaction is still active.A -----------A -----------2001 2002 2003 2005 2007 derby966Local Connection holdable HOLD_CURSORS_OVER_COMMIT 1Local(held) default Statement holdable HOLD_CURSORS_OVER_COMMIT 1ResultSet 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 1ResultSet 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 1ResultSet 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 1ResultSet 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 2ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(held) close PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) default Statement holdable CLOSE_CURSORS_AT_COMMIT 2ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) default PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) held Statement holdable HOLD_CURSORS_OVER_COMMIT 1ResultSet 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 1ResultSet 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 2ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0Non-held ResultSet correctly closed after commitLocal(close) close PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2ResultSet 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 :SQL Warning: ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.Global prepareStatement(hold)Statement holdable CLOSE_CURSORS_AT_COMMIT 201J07 :SQL Warning: ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.Global xact Statement sdh Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement shh Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement sch Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement psdh Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement pshh Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global 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 CLOSE_CURSORS_AT_COMMIT 2Global xact Statement scc Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement psdh_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement pshh_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2Global xact Statement psch_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2After 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 + -