checkdatasource.out

derby database source code.good for you.

Switch to local XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
Running connection checks on Switch to local XADataSource
  isolation level 2
  auto commit     true
  read only       false
  has warnings    false
setTypeMap(EMPTY_MAP) - ok
setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap'
setTypeMap(map) - ok 0A000 - Feature not implemented: no details.
EVENT(5):connectionClosed
method calls on a closed connection
Switch to local XADataSource <closedconn>.close() no error
Switch to local XADataSource <closedconn>.createStatement() 08003 - No current connection.
Switch to local XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
Running connection checks on Switch to global XADataSource
  isolation level 2
  auto commit     false
  read only       false
  has warnings    false
setTypeMap(EMPTY_MAP) - ok
setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap'
setTypeMap(map) - ok 0A000 - Feature not implemented: no details.
EVENT(5):connectionClosed
method calls on a closed connection
Switch to global XADataSource <closedconn>.close() no error
Switch to global XADataSource <closedconn>.createStatement() 08003 - No current connection.
Switch to global XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
Running connection checks on Switch to global XADataSource
  isolation level 2
  auto commit     false
  read only       false
  has warnings    false
setTypeMap(EMPTY_MAP) - ok
setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap'
setTypeMap(map) - ok 0A000 - Feature not implemented: no details.
EVENT(5):connectionClosed
method calls on a closed connection
Switch to global XADataSource <closedconn>.close() no error
Switch to global XADataSource <closedconn>.createStatement() 08003 - No current connection.
Switch to global XADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
initial local
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
initial  X1
  isolation level READ_COMMITTED
  auto commit     false
  read only       false
modified X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       true
modified local
  isolation level READ_UNCOMMITTED
  auto commit     true
  read only       true
reset local
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
re-join X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       true
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       true
local after suspend
  isolation level READ_COMMITTED
  auto commit     true
  read only       false
resume X1
  isolation level READ_UNCOMMITTED
  auto commit     false
  read only       true
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       true
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       true
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: ru(SN1) contents {1} {2} {3}
Expecting downgrade because global transaction sru1-global-2 is using a statement with holdability true
sru1-global-2: ru(SN1) contents {1} {2} {3}
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: ru(SN1) 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