checkdatasource.out

derby database source code.good for you.

  read only       false
modified local
  isolation level READ_UNCOMMITTED
  auto commit     true
  read only       false
reset local
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
re-join X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       false
back to local (same as reset)
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
re-join X1 second time
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       false
local after suspend
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
resume X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       false
back to local (second time)
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
EVENT(6):connectionClosed
new handle - local 
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
EVENT(6):connectionClosed
re-join with new handle X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       false
EVENT(6):connectionClosed
pre-X1 commit - local
  isolation level REPEATABLE_READ
  auto commit     true
  read only       false
pre-X1 commit - X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       false
post-X1 end - local
  isolation level REPEATABLE_READ
  auto commit     true
  read only       false
post-X1 commit - local
  isolation level REPEATABLE_READ
  auto commit     true
  read only       false
EVENT(6):connectionClosed
Some more isolation testing using SQL and JDBC api
initial local
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
Issue setTransactionIsolation in local transaction
setTransactionIsolation in local
  isolation level READ_UNCOMMITTED
  auto commit     true
  read only       false
Issue SQL to change isolation in local transaction
SQL to change isolation in local
  isolation level SERIALIZABLE
  auto commit     true
  read only       false
1st global(new)
  isolation level SERIALIZABLE
  auto commit     false
  read only       false
local
  isolation level SERIALIZABLE
  auto commit     true
  read only       false
Issue SQL to change isolation in local transaction
SQL to change isolation in local
  isolation level REPEATABLE_READ
  auto commit     true
  read only       false
1st global(existing)
  isolation level SERIALIZABLE
  auto commit     false
  read only       false
local
  isolation level REPEATABLE_READ
  auto commit     true
  read only       false
2nd global(new)
  isolation level REPEATABLE_READ
  auto commit     false
  read only       false
1st global(existing)
  isolation level SERIALIZABLE
  auto commit     false
  read only       false
local
  isolation level REPEATABLE_READ
  auto commit     true
  read only       false
1st global(existing)
  isolation level SERIALIZABLE
  auto commit     false
  read only       false
Issue SQL to change isolation in 1st global transaction
change isolation of existing 1st global transaction
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       false
local
  isolation level READ_UNCOMMITTED
  auto commit     true
  read only       false
2nd global(existing)
  isolation level REPEATABLE_READ
  auto commit     false
  read only       false
(After 2nd global rollback) local
  isolation level READ_UNCOMMITTED
  auto commit     true
  read only       false
(After 1st global rollback) local
  isolation level READ_UNCOMMITTED
  auto commit     true
  read only       false
TESTING RE_USE OF STATEMENT OBJECTS
LOCK TABLE
END LOCK TABLE
Statement State @ Create 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 444
  getMaxFieldSize() 713
  getMaxRows() 19
Statement State @ PS Create 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
Statement State @ CS Create 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
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
Statement State @ PS GLOBAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
Statement State @ CS GLOBAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
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
Statement State @ PS LOCAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
Statement State @ CS LOCAL 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
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
Statement State @ PS LOCAL 2 
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 888
  getMaxFieldSize() 317
  getMaxRows() 91
Statement State @ CS LOCAL 2
  getResultSetType() SCROLL_INSENSITIVE
  getResultSetConcurrency() READ_ONLY
  getFetchDirection() REVERSE
  getFetchSize() 999
  getMaxFieldSize() 137
  getMaxRows() 85
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.
XAResource.end : XAException - XAER_RMFAIL : Connection is Closed.
XAResource.commit : XAException - XAER_RMFAIL : Connection is Closed.
XAResource.prepare : XAException - XAER_RMFAIL : Connection is Closed.
XAResource.recover : XAException - XAER_RMFAIL : Connection is Closed.
XAResource.prepare : XAException - XAER_RMFAIL : Connection is Closed.
XAResource.isSameRM : XAException - XAER_RMFAIL : 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
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
Completed checkDataSource