After updating my client with the change for DERBY-1158 I see the
following diff in the client checkDataSource test.
I think this diff is ok but wanted to check before updating the master
because I wasn't sure about the lock output.
It is different than embedded. I was wondering if someone could confirm
that these changes are ok for updating the client checkDataSource.out
master.
Note: checkDataSource is not yet in the client suite because of DERBY-1173.
< sru1-global-2: java.sql.SQLException: Cannot set holdability
ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
---
> sru1-global-2: ru(SQL_CURLH000C4) contents {1} {2} {3}
361c361
< sru1-global-4: java.sql.SQLException: Cannot set holdability
ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
---
> sru1-global-4: ru(SQL_CURLH000C7) contents {1} {2} {3}
413c413
< xid row 0 lock count 4
---
> xid row 0 lock count 12
444c444
< xid row 0 lock count 4
---
> xid row 0 lock count 12
458a459
>
460a462
Running connection checks on DriverManager
isolation level 2
auto commit true
read only false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DriverManager <closedconn>.close() no error
DriverManager <closedconn>.createStatement() 08003 - No current connection.
DriverManager <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on DataSource
isolation level 2
auto commit true
read only false
has warnings false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DataSource <closedconn>.close() no error
DataSource <closedconn>.createStatement() 08003 - No current connection.
DataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(1):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(1):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Changes rolled back OK in auto closed pooled connection
EVENT(1):connectionClosed
expected java.sql.SQLException: Invalid operation: result set closed
expected java.sql.SQLException: Invalid operation: statement closed
Start testPoolReset ConnectionPoolDataSource
IDENTITY_VAL_LOCAL=1
IDENTITY_VAL_LOCAL=2
IDENTITY_VAL_LOCAL=3
End testPoolReset ConnectionPoolDataSource
Running connection checks on XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(3):connectionClosed
method calls on a closed connection
XADataSource <closedconn>.close() no error
XADataSource <closedconn>.createStatement() 08003 - No current connection.
XADataSource <closedstmt>.execute() null - Invalid operation: statement closed
Changes rolled back OK in auto closed local XAConnection
EVENT(3):connectionClosed
Start testPoolReset XADataSource
IDENTITY_VAL_LOCAL=1
IDENTITY_VAL_LOCAL=2
IDENTITY_VAL_LOCAL=3
End testPoolReset XADataSource
ERROR XJ015: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ015, SQLERRMC: Derby
system shutdown.
Running connection checks on DriverManager
isolation level 2
auto commit true
read only false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DriverManager <closedconn>.close() no error
DriverManager <closedconn>.createStatement() 08003 - No current connection.
DriverManager <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on DataSource
isolation level 2
auto commit true
read only false
has warnings false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DataSource <closedconn>.close() no error
DataSource <closedconn>.createStatement() 08003 - No current connection.
DataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(2):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(2):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Running connection checks on XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(4):connectionClosed
method calls on a closed connection
XADataSource <closedconn>.close() no error
XADataSource <closedconn>.createStatement() 08003 - No current connection.
XADataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(4):connectionClosed
method calls on a closed connection
XADataSource <closedconn>.close() no error
XADataSource <closedconn>.createStatement() 08003 - No current connection.
XADataSource <closedstmt>.execute() null - Invalid operation: statement closed
EVENT(5):connectionClosed
Running connection checks on Global XADataSource
isolation level 2
auto commit false
read only false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(5):connectionClosed
method calls on a closed connection
Global XADataSource <closedconn>.close() no error
Global XADataSource <closedconn>.createStatement() 08003 - No current
connection.
Global XADataSource <closedstmt>.execute() null - Invalid operation: statement
closed
Running connection checks on Global XADataSource
isolation level 2
auto commit false
read only false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(5):connectionClosed
method calls on a closed connection
Global XADataSource <closedconn>.close() no error
Global XADataSource <closedconn>.createStatement() 08003 - No current
connection.
Global XADataSource <closedstmt>.execute() null - Invalid operation: statement
closed
Running connection checks on Switch to local XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement closed
Running connection checks on Switch to local XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement closed
Running connection checks on Switch to global XADataSource
isolation level 2
auto commit false
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement closed
Running connection checks on Switch to global XADataSource
isolation level 2
auto commit false
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement 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 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
back to local (same as reset)
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
EVENT(6):connectionClosed
pre-X1 commit - local
isolation level REPEATABLE_READ
auto commit true
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
TESTING RE_USE OF STATEMENT OBJECTS
THE STATEMENT OBJECTS CAN NOT BE REUSED ACROSS LOCAL/GLOBAL CONNECTIONS
BECAUSE, LOCAL CONNECTION CREATES THEM
WITH HOLDABILITY TRUE WHEREAS GLOBAL CONNECTION CAN ONLY WORK WITH STATEMENTS
WITH HOLDABILITY FALSE
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 exception because global transaction sru1-global-2 is trying to use a
statement with holdability true
sru1-global-2: mismatched Statement connection
sru1-global-2: ru(SQL_CURLH000C4) contents {1} {2} {3}
sru2-global-3: mismatched Statement connection
sru2-global-3: ru(OAK2) contents {1} {2} {3}
Expecting exception because global transaction sru1-global-4 is trying to use a
statement with holdability true
sru1-global-4: mismatched Statement connection
sru1-global-4: ru(SQL_CURLH000C7) 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
PASS: got exception because holdability is true on prepared statement and that
is not allowed in global transactions
Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global
transaction.
sru1-local-5: mismatched Statement connection
sru1-local-5: ru(SQL_CURLH000C4) contents {1} {2} {3}
sru2-local-6: mismatched Statement connection
sru2-local-6: ru(SQL_CURLN000C8) 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
LOCK TABLE
xid row 0 lock count 12
xid row 1 lock count 12
END LOCK TABLE
sru1-local-8: mismatched Statement connection
sru1-local-8: ru(SQL_CURLH000C9) contents {1} {2} {3}
sru2-local-9: mismatched Statement connection
sru2-local-9: ru(SQL_CURLN000C1) contents {1} {2} {3}
sru3-local-10: mismatched Statement connection
sru3-local-10: ru(SQL_CURLH000C4) 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 12
xid row 1 lock count 12
END LOCK TABLE
sruBatch update counts : 1 1 2 1 :
sruBatch: mismatched Statement connection
sruBatch: ru(SQL_CURLH000C10) 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
testing jira 95 for DataSource; ok - expected exception: XCY00
testing jira 95 for XADataSource; ok - expected exception: XCY00
Completed checkDataSource
Running connection checks on DriverManager
isolation level 2
auto commit true
read only false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DriverManager <closedconn>.close() no error
DriverManager <closedconn>.createStatement() 08003 - No current connection.
DriverManager <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on DataSource
isolation level 2
auto commit true
read only false
has warnings false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DataSource <closedconn>.close() no error
DataSource <closedconn>.createStatement() 08003 - No current connection.
DataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(1):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(1):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Changes rolled back OK in auto closed pooled connection
EVENT(1):connectionClosed
expected java.sql.SQLException: Invalid operation: result set closed
expected java.sql.SQLException: Invalid operation: statement closed
Start testPoolReset ConnectionPoolDataSource
IDENTITY_VAL_LOCAL=1
IDENTITY_VAL_LOCAL=2
IDENTITY_VAL_LOCAL=3
End testPoolReset ConnectionPoolDataSource
Running connection checks on XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(3):connectionClosed
method calls on a closed connection
XADataSource <closedconn>.close() no error
XADataSource <closedconn>.createStatement() 08003 - No current connection.
XADataSource <closedstmt>.execute() null - Invalid operation: statement closed
Changes rolled back OK in auto closed local XAConnection
EVENT(3):connectionClosed
Start testPoolReset XADataSource
IDENTITY_VAL_LOCAL=1
IDENTITY_VAL_LOCAL=2
IDENTITY_VAL_LOCAL=3
End testPoolReset XADataSource
ERROR XJ015: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ015, SQLERRMC: Derby
system shutdown.
Running connection checks on DriverManager
isolation level 2
auto commit true
read only false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DriverManager <closedconn>.close() no error
DriverManager <closedconn>.createStatement() 08003 - No current connection.
DriverManager <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on DataSource
isolation level 2
auto commit true
read only false
has warnings false
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
method calls on a closed connection
DataSource <closedconn>.close() no error
DataSource <closedconn>.createStatement() 08003 - No current connection.
DataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(2):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(2):connectionClosed
method calls on a closed connection
ConnectionPoolDataSource <closedconn>.close() no error
ConnectionPoolDataSource <closedconn>.createStatement() 08003 - No current
connection.
ConnectionPoolDataSource <closedstmt>.execute() null - Invalid operation:
statement closed
Running connection checks on XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(4):connectionClosed
method calls on a closed connection
XADataSource <closedconn>.close() no error
XADataSource <closedconn>.createStatement() 08003 - No current connection.
XADataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(4):connectionClosed
method calls on a closed connection
XADataSource <closedconn>.close() no error
XADataSource <closedconn>.createStatement() 08003 - No current connection.
XADataSource <closedstmt>.execute() null - Invalid operation: statement closed
EVENT(5):connectionClosed
Running connection checks on Global XADataSource
isolation level 2
auto commit false
read only false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(5):connectionClosed
method calls on a closed connection
Global XADataSource <closedconn>.close() no error
Global XADataSource <closedconn>.createStatement() 08003 - No current
connection.
Global XADataSource <closedstmt>.execute() null - Invalid operation: statement
closed
Running connection checks on Global XADataSource
isolation level 2
auto commit false
read only false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
EVENT(5):connectionClosed
method calls on a closed connection
Global XADataSource <closedconn>.close() no error
Global XADataSource <closedconn>.createStatement() 08003 - No current
connection.
Global XADataSource <closedstmt>.execute() null - Invalid operation: statement
closed
Running connection checks on Switch to local XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement closed
Running connection checks on Switch to local XADataSource
isolation level 2
auto commit true
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement closed
Running connection checks on Switch to global XADataSource
isolation level 2
auto commit false
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement closed
Running connection checks on Switch to global XADataSource
isolation level 2
auto commit false
read only false
has warnings false
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for Statement.getConnection()
FAIL incorrect connection object returned for DatabaseMetaData.getConnection()
setTypeMap(EMPTY_MAP) - FAIL 0A000 - Feature not implemented: setTypeMap.
setTypeMap(null) - ok 0A000 - Feature not implemented: setTypeMap.
setTypeMap(map) - ok 0A000 - Feature not implemented: setTypeMap.
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() null - Invalid operation:
statement 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 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
back to local (same as reset)
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
EVENT(6):connectionClosed
pre-X1 commit - local
isolation level REPEATABLE_READ
auto commit true
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
TESTING RE_USE OF STATEMENT OBJECTS
THE STATEMENT OBJECTS CAN NOT BE REUSED ACROSS LOCAL/GLOBAL CONNECTIONS
BECAUSE, LOCAL CONNECTION CREATES THEM
WITH HOLDABILITY TRUE WHEREAS GLOBAL CONNECTION CAN ONLY WORK WITH STATEMENTS
WITH HOLDABILITY FALSE
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 exception because global transaction sru1-global-2 is trying to use a
statement with holdability true
sru1-global-2: mismatched Statement connection
sru1-global-2: java.sql.SQLException: Cannot set holdability
ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
sru2-global-3: mismatched Statement connection
sru2-global-3: ru(OAK2) contents {1} {2} {3}
Expecting exception because global transaction sru1-global-4 is trying to use a
statement with holdability true
sru1-global-4: mismatched Statement connection
sru1-global-4: java.sql.SQLException: Cannot set holdability
ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
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
PASS: got exception because holdability is true on prepared statement and that
is not allowed in global transactions
Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global
transaction.
sru1-local-5: mismatched Statement connection
sru1-local-5: ru(SQL_CURLH000C4) contents {1} {2} {3}
sru2-local-6: mismatched Statement connection
sru2-local-6: ru(SQL_CURLN000C8) 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
LOCK TABLE
xid row 0 lock count 4
xid row 1 lock count 12
END LOCK TABLE
sru1-local-8: mismatched Statement connection
sru1-local-8: ru(SQL_CURLH000C9) contents {1} {2} {3}
sru2-local-9: mismatched Statement connection
sru2-local-9: ru(SQL_CURLN000C1) contents {1} {2} {3}
sru3-local-10: mismatched Statement connection
sru3-local-10: ru(SQL_CURLH000C4) 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 4
xid row 1 lock count 12
END LOCK TABLE
sruBatch update counts : 1 1 2 1 :
sruBatch: mismatched Statement connection
sruBatch: ru(SQL_CURLH000C10) 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
testing jira 95 for DataSource; ok - expected exception: XCY00
testing jira 95 for XADataSource; ok - expected exception: XCY00
Completed checkDataSource
