checkdatasource30.out

derby database source code.good for you.

Statement State @ Create 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 444
  getMaxFieldSize() 713
  getMaxRows() 19
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
Statement State @ PS Create 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 1
    1 type 4
Statement State @ CS Create 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 2
    1 type 12
    2 type 12
Params-local-1: ru(params) contents {3}
sru1-local-1: mismatched Statement connection
sru1-local-1: ru(SN1) contents {1} {2} {3}
Expecting downgrade because global transaction sru1-global-2 is using a statement with holdability true
sru1-global-2: mismatched Statement connection
sru1-global-2: ru(SQL_CURLH000C) contents {1} {2} {3}
sru2-global-3: mismatched Statement connection
sru2-global-3: ru(OAK2) contents {1} {2} {3}
Expecting downgrade because global transaction sru1-global-4 is using a statement with holdability true
sru1-global-4: mismatched Statement connection
sru1-global-4: ru(SQL_CURLH000C) contents {1} {2} {3}
Statement State @ GLOBAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 444
  getMaxFieldSize() 713
  getMaxRows() 19
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
Statement State @ PS GLOBAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 1
    1 type 4
Statement State @ CS GLOBAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 2
    1 type 12
    2 type 12
Params-global-1: ru(SQL_CURLH000C) contents {3}
sru1-local-5: mismatched Statement connection
sru1-local-5: ru(SQL_CURLH000C) contents {1} {2} {3}
sru2-local-6: mismatched Statement connection
sru2-local-6: ru(SQL_CURLN000C) contents {1} {2} {3}
sru3-local-7: mismatched Statement connection
sru3-local-7: ru(SF3) contents {1} {2} {3}
Statement State @ LOCAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 444
  getMaxFieldSize() 713
  getMaxRows() 19
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
Statement State @ PS LOCAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 1
    1 type 4
Statement State @ CS LOCAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 2
    1 type 12
    2 type 12
Params-local-2: ru(SQL_CURLH000C) contents {3}
LOCK TABLE
  xid row 0 lock count 14
  xid row 1 lock count 14
END LOCK TABLE
sru1-local-8: mismatched Statement connection
sru1-local-8: ru(SQL_CURLH000C) contents {1} {2} {3}
sru2-local-9: mismatched Statement connection
sru2-local-9: ru(SQL_CURLN000C) contents {1} {2} {3}
sru3-local-10: mismatched Statement connection
sru3-local-10: ru(SQL_CURLH000C) contents {1} {2} {3}
Statement State @ LOCAL 2 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 444
  getMaxFieldSize() 713
  getMaxRows() 19
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
Statement State @ PS LOCAL 2 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 1
    1 type 4
Statement State @ CS LOCAL 2
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
  getResultSetHoldability() HOLD_CURSORS_OVER_COMMIT 
  Parameter Count 2
    1 type 12
    2 type 12
LOCK TABLE
  xid row 0 lock count 14
  xid row 1 lock count 12
END LOCK TABLE
sruBatch update counts : 1  1  2  1 :
sruBatch: mismatched Statement connection
sruBatch: ru(SQL_CURLH000C) contents {1} {2} {3} {4} {5} {6} {7} {8}
XAConnection.getConnection : getConnection() is not valid on a closed PooledConnection.
XAResource.start : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
XAResource.end : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
XAResource.commit : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
XAResource.prepare : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
XAResource.recover : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
XAResource.prepare : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
XAResource.isSameRM : XAException - XAER_RMFAIL : Connection is Closed.
ERROR (no SQLState): Connection is Closed.
Patricio update count 1
conn4 autcommit true
acxs 1
acxs 2
autocommitxastart expected Invalid operation: result set closed
acxs 1
acxs 2
autocommitxastart expected  : XAException - XAER_OUTSIDE : Error executing a XAResource.start(), Server returned XAER_OUTSIDE
ERROR (no SQLState): Error executing a XAResource.start(), Server returned XAER_OUTSIDE
Expected XA error code: -9
acxs 3
testing jira 95 for DataSource; ok - expected exception: XCY00
testing jira 95 for XADataSource; ok - expected exception: XCY00
START XA HOLDABILITY TEST
By default, autocommit is true for a connection
Default holdability for a connection is HOLD_CURSORS_OVER_COMMIT
CONNECTION(not in xa transaction yet) HOLDABILITY true
Notice that autocommit now is false for connection because it is part of the global transaction
Notice that connection's holdability at this point is CLOSE_CURSORS_AT_COMMIT because it is part of the global transaction
CONNECTION(in xa transaction) HOLDABILITY false
CONNECTION(in xa transaction) HOLDABILITY false
Autocommit on Connection inside global transaction has been set correctly to false
CONNECTION(non-xa) HOLDABILITY false
STATEMENT HOLDABILITY false
STATEMENT HOLDABILITY false
STATEMENT HOLDABILITY true
PREPARED STATEMENT HOLDABILITY true
CALLABLE STATEMENT HOLDABILITY true
H@1 id 1
H@2 id 2
H@3 id 3
CONNECTION(xa) HOLDABILITY false
STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false
STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY true
STATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false
PREPAREDSTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false
CALLABLESTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false
X@1 id 1
X@2 id 2
Expected SQLException No current connection. : 
Expected SQLException Invalid operation: result set closed
resume XA transaction and keep using rs
Check holdability of various jdbc objects after resuming XA transaction
CONNECTION(xa) HOLDABILITY false
STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false
STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY true
STATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false
PREPAREDSTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false
CALLABLESTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false
STATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false
PREPAREDSTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false
CALLABLESTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false
Expected SQLException Invalid operation: result set closed
Expected SQLException Invalid operation: result set closed
Set connection to hold 
CONNECTION(held) HOLDABILITY true
CONNECTION(xa) HOLDABILITY false
Expected SQLException(setHoldability) Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
HOLDABLE Statement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.
HOLDABLE PreparedStatement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.
HOLDABLE CallableStatement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction.
CONNECTION(held) HOLDABILITY true
PASS XA HOLDABILITY TEST
**Test holdability state for: PooledConnection **
PASS: Holdability matches expected holdability:HOLD_CURSORS_OVER_COMMIT
** Test autoCommit state for: PooledConnection**
PASS: autoCommit reset on getConnection
done creating  table
*** Test isolation level reset on PooledConnection.getConnection()***
setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED
PASS: No lock timeout occurs for READ_UNCOMMITTED
Get a new connection with PooledConnection.getConnection()
Isolation level should be reset to READ_COMMITTED
PASS: Expected lock timeout for READ_COMMITTED
done creating  table
*** Test isolation level reset on XAConnection.getConnection()***
setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED
PASS: No lock timeout occurs for READ_UNCOMMITTED
Get a new connection with XAConnection.getConnection()
Isolation level should be reset to READ_COMMITTED
PASS: Expected lock timeout for READ_COMMITTED
Completed checkDataSource30