initial Connection holdable HOLD_CURSORS_OVER_COMMIT 1 singleConnectionOnePhaseCommit XA Connection holdable CLOSE_CURSORS_AT_COMMIT 2 XA Statement holdable CLOSE_CURSORS_AT_COMMIT 2 A ----------- 0 GXID|STATUS |READONLY|USERNAME |TYPE ---------------------------------------------------------------- (0 |ACTIVE |false |APP |UserTransaction interleavingTransactions GXID|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 2 recovered 0 recovered end 0 GXID|STATUS |READONLY|USERNAME |TYPE ---------------------------------------------------------------- (3 |IDLE |NULL |SKU |UserTransaction A ----------- 0 1 3 noTransaction morph GXID|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: false A ----------- 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 derby966 Local Connection holdable HOLD_CURSORS_OVER_COMMIT 1 Local(held) default Statement holdable HOLD_CURSORS_OVER_COMMIT 1 ResultSet 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=2007 Local(held) default PreparedStatement holdable HOLD_CURSORS_OVER_COMMIT 1 ResultSet 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=2007 Local(held) held Statement holdable HOLD_CURSORS_OVER_COMMIT 1 ResultSet 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=2007 Local(held) held PreparedStatement holdable HOLD_CURSORS_OVER_COMMIT 1 ResultSet 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=2007 Local(held) close Statement holdable CLOSE_CURSORS_AT_COMMIT 2 ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0 Non-held ResultSet correctly closed after commit Local(held) close PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2 ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0 Non-held ResultSet correctly closed after commit Local(close) default Statement holdable CLOSE_CURSORS_AT_COMMIT 2 ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0 Non-held ResultSet correctly closed after commit Local(close) default PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2 ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0 Non-held ResultSet correctly closed after commit Local(close) held Statement holdable HOLD_CURSORS_OVER_COMMIT 1 ResultSet 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=2007 Local(close) held PreparedStatement holdable HOLD_CURSORS_OVER_COMMIT 1 ResultSet 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=2007 Local(close) close Statement holdable CLOSE_CURSORS_AT_COMMIT 2 ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0 Non-held ResultSet correctly closed after commit Local(close) close PreparedStatement holdable CLOSE_CURSORS_AT_COMMIT 2 ResultSet CLOSE_CURSORS_AT_COMMIT 2 BC A=0 Non-held ResultSet correctly closed after commit BGBC 0 BGAC 1 START GLOBAL TRANSACTION Global transaction open ResultSets 12 EXPECTED SQLSTATE(XJ05C): Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction. Global createStatement(hold)Statement holdable CLOSE_CURSORS_AT_COMMIT 2 01J07 :SQL Warning: ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction. Global prepareStatement(hold)Statement holdable CLOSE_CURSORS_AT_COMMIT 2 01J07 :SQL Warning: ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction. Global xact Statement sdh Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement shh Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement sch Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement psdh Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement pshh Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement psch Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement sdc Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement shc Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement scc Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement psdh_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement pshh_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement psch_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2 After global transaction closed ResultSets 12 Global xact Statement sdh Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement shh Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement sch Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement psdh Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement pshh Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement psch Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement sdc Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement shc Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement scc Statement holdable CLOSE_CURSORS_AT_COMMIT 2 Global xact Statement psdh_d Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement pshh_d Statement holdable HOLD_CURSORS_OVER_COMMIT 1 Global xact Statement psch_d Statement holdable CLOSE_CURSORS_AT_COMMIT 2 derby966 complete derby4310PreparedStatement derby4310CallableStatement XATest complete