You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2006/04/06 07:17:18 UTC
svn commit: r391902 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/DerbyNetClient/ suites/ tests/jdbcapi/
Author: kmarsden
Date: Wed Apr 5 22:17:14 2006
New Revision: 391902
URL: http://svn.apache.org/viewcvs?rev=391902&view=rev
Log:
DERBY-435 jdbcapi/checkDataSource.java and jdbapi/checkDataSource30.java to tests should be changed or extended to test client DataSources
- Brings checkDataSource and checkDataSourc30 into derbynetclientmats
- Reenables tests for DERBY-1044 now that it is fixed.
Tests are excluded for some bugs uncovered by this test that have yet to
be resolved:
DERBY-1035, DERBY-1047, DERBY-1025, DERBY-1148, DERBY-1183
Added:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource_derby.properties (with props)
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource30.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out?rev=391902&r1=391901&r2=391902&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out Wed Apr 5 22:17:14 2006
@@ -2,24 +2,24 @@
isolation level 2
auto commit true
read only false
-setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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() null - invalid operation: connection closed
+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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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() null - invalid operation: connection closed
+DataSource <closedconn>.createStatement() 08003 - No current connection.
DataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
@@ -29,9 +29,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -45,9 +45,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -70,9 +70,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -85,29 +85,29 @@
IDENTITY_VAL_LOCAL=2
IDENTITY_VAL_LOCAL=3
End testPoolReset XADataSource
-ERROR XJ015: Derby system shutdown.
+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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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() null - invalid operation: connection closed
+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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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() null - invalid operation: connection closed
+DataSource <closedconn>.createStatement() 08003 - No current connection.
DataSource <closedstmt>.execute() null - Invalid operation: statement closed
Running connection checks on ConnectionPoolDataSource
isolation level 2
@@ -117,9 +117,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -133,9 +133,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -149,9 +149,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -165,9 +165,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -181,9 +181,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -196,9 +196,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -212,9 +212,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -228,9 +228,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -244,9 +244,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -260,9 +260,9 @@
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 null - Connection.setTypeMap is not supported
-setTypeMap(null) - ok null - Connection.setTypeMap is not supported
-setTypeMap(map) - ok null - Connection.setTypeMap is not supported
+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
@@ -288,33 +288,21 @@
isolation level READ_COMMITTED
auto commit true
read only false
-re-join X1
- isolation level READ_COMMITTED
- auto commit false
- 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_UNCOMMITTED
+ 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 REPEATABLE_READ
- auto commit false
- read only false
post-X1 end - local
isolation level REPEATABLE_READ
auto commit true
@@ -325,6 +313,10 @@
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
@@ -361,12 +353,12 @@
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.
+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 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.
+sru1-global-4: ru(SQL_CURLH000C) contents {1} {2} {3}
Statement State @ GLOBAL
getResultSetType() SCROLL_INSENSITIVE
getResultSetConcurrency() READ_ONLY
@@ -391,9 +383,9 @@
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}
+sru1-local-5: ru(SQL_CURLH000C) contents {1} {2} {3}
sru2-local-6: mismatched Statement connection
-sru2-local-6: ru(SQL_CURLN000C8) contents {1} {2} {3}
+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
@@ -418,15 +410,15 @@
getMaxFieldSize() 137
getMaxRows() 85
LOCK TABLE
- xid row 0 lock count 4
+ 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}
+sru1-local-8: ru(SQL_CURLH000C) contents {1} {2} {3}
sru2-local-9: mismatched Statement connection
-sru2-local-9: ru(SQL_CURLN000C1) contents {1} {2} {3}
+sru2-local-9: ru(SQL_CURLN000C) contents {1} {2} {3}
sru3-local-10: mismatched Statement connection
-sru3-local-10: ru(SQL_CURLH000C4) contents {1} {2} {3}
+sru3-local-10: ru(SQL_CURLH000C) contents {1} {2} {3}
Statement State @ LOCAL 2
getResultSetType() SCROLL_INSENSITIVE
getResultSetConcurrency() READ_ONLY
@@ -449,12 +441,12 @@
getMaxFieldSize() 137
getMaxRows() 85
LOCK TABLE
- xid row 0 lock count 4
+ 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}
+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.
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out?rev=391902&r1=391901&r2=391902&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out Wed Apr 5 22:17:14 2006
@@ -1,3 +1,558 @@
+Running JDBC 3.0 connection checks on DriverManager
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on DataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on ConnectionPoolDataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on ConnectionPoolDataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on XADataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on DriverManager
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on DataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on ConnectionPoolDataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on ConnectionPoolDataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on XADataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on XADataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on Global XADataSource
+ holdability false
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on Global XADataSource
+ holdability false
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on Switch to local XADataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on Switch to local XADataSource
+ holdability true
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on Switch to global XADataSource
+ holdability false
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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 JDBC 3.0 connection checks on Switch to global XADataSource
+ holdability false
+JDBC 3.0 savepoint java.sql.SQLException: Cannot issue savepoint when autoCommit is on.
+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
+ holdability true
+ isolation level READ_COMMITTED
+ auto commit true
+ read only false
+initial X1
+ holdability false
+ isolation level READ_COMMITTED
+ auto commit false
+ read only false
+modified X1
+ holdability false
+ isolation level READ_UNCOMMITTED
+ auto commit false
+ read only false
+modified local
+ holdability false
+ isolation level READ_UNCOMMITTED
+ auto commit true
+ read only false
+reset local
+ holdability false
+ isolation level READ_COMMITTED
+ auto commit true
+ read only false
+back to local (same as reset)
+ holdability false
+ isolation level READ_COMMITTED
+ auto commit true
+ read only false
+EVENT(6):connectionClosed
+new handle - local
+ holdability true
+ isolation level READ_COMMITTED
+ auto commit true
+ read only false
+EVENT(6):connectionClosed
+EVENT(6):connectionClosed
+pre-X1 commit - local
+ holdability true
+ isolation level REPEATABLE_READ
+ auto commit true
+ read only false
+post-X1 end - local
+ holdability true
+ isolation level REPEATABLE_READ
+ auto commit true
+ read only false
+post-X1 commit - local
+ holdability true
+ isolation level REPEATABLE_READ
+ auto commit true
+ read only false
+EVENT(6):connectionClosed
+Some more isolation testing using SQL and JDBC api
+initial local
+ holdability true
+ isolation level READ_COMMITTED
+ auto commit true
+ read only false
+Issue setTransactionIsolation in local transaction
+setTransactionIsolation in local
+ holdability true
+ 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
+ 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 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_CURLH000C) 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_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
+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_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
+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_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 12
+ 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
+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
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall?rev=391902&r1=391901&r2=391902&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall Wed Apr 5 22:17:14 2006
@@ -3,4 +3,5 @@
jdbcapi/xaStateTran.sql
jdbcapi/lobStreams.java
jdbcapi/XATest.java
+jdbcapi/checkDataSource.java
derbynet/SqlExceptionTest.junit
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource.java?rev=391902&r1=391901&r2=391902&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource.java Wed Apr 5 22:17:14 2006
@@ -88,12 +88,6 @@
// Tests for setting isolation level this way only run in embedded for now.
private boolean canSetIsolationWithStatement = TestUtil.isEmbeddedFramework();
- // DERBY-1044 [xa] client XAConnection.getConnection() does not have the
- // correct default isolation level if set by an earlier connection
- // obtained from the same XAConnection
- // Only print out initial isolation for embedded in this case
- private boolean isolationResetOnSecondGetConnection =
- TestUtil.isEmbeddedFramework();
// DERBY-1047 wiht client xa a PreparedStatement created before the global
//transaction starts gives java.sql.SQLException: 'Statement' already closed.'
@@ -107,6 +101,12 @@
// run only for embedded for now.
private static boolean autocommitCommitsOnXa_Start =TestUtil.isEmbeddedFramework();
+ // DERBY-1148 - Client Connection state does not
+ // get set properly when joining a global transaction.
+ private static boolean isolationSetProperlyOnJoin = TestUtil.isEmbeddedFramework();
+
+ // DERBY-1183 getCursorName not correct after first statement execution
+ private static boolean hasGetCursorNameBug = TestUtil.isDerbyNetClientFramework();
/**
* A hashtable of opened connections. This is used when checking to
* make sure connection strings are unique; we need to make sure all
@@ -408,7 +408,9 @@
// and isolation level from the transaction,
// holdability remains that of this handle.
xar.start(xid, XAResource.TMJOIN);
- printState("re-join X1", cs1);
+ // DERBY-1148
+ if (isolationSetProperlyOnJoin)
+ printState("re-join X1", cs1);
xar.end(xid, XAResource.TMSUCCESS);
// should be the same as the reset local
@@ -418,14 +420,16 @@
cs1.setReadOnly(true);
setHoldability(cs1, true);
cs1.close();
-
+
cs1 = xac.getConnection();
printState("new handle - local ", cs1);
cs1.close();
-
+
xar.start(xid, XAResource.TMJOIN);
cs1 = xac.getConnection();
- printState("re-join with new handle X1", cs1);
+ // DERBY-1148
+ if (isolationSetProperlyOnJoin)
+ printState("re-join with new handle X1", cs1);
cs1.close();
xar.end(xid, XAResource.TMSUCCESS);
@@ -436,7 +440,9 @@
cs1.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
printState("pre-X1 commit - local", cs1);
xar.start(xid, XAResource.TMJOIN);
- printState("pre-X1 commit - X1", cs1);
+ // DERBY-1148
+ if (isolationSetProperlyOnJoin)
+ printState("pre-X1 commit - X1", cs1);
xar.end(xid, XAResource.TMSUCCESS);
printState("post-X1 end - local", cs1);
xar.commit(xid, true);
@@ -447,8 +453,7 @@
System.out.println("Some more isolation testing using SQL and JDBC api");
cs1 = xac.getConnection();
s = cs1.createStatement();
- if (isolationResetOnSecondGetConnection)
- printState("initial local", cs1);
+ printState("initial local", cs1);
System.out.println("Issue setTransactionIsolation in local transaction");
cs1.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
@@ -915,7 +920,15 @@
}
private static void resultSetQuery(String tag, ResultSet rs) throws SQLException {
- System.out.print(tag + ": ru(" + rs.getCursorName() + ") contents");
+ String cursorName = rs.getCursorName();
+ // DERBY-1183 client cursor name is not correct.
+ // need to truncate the cursor number of the generated name as it might
+ // not be consistent.
+ if (hasGetCursorNameBug && cursorName.startsWith("SQL_CUR"))
+ {
+ cursorName = cursorName.substring(0,13);
+ }
+ System.out.print(tag + ": ru(" + cursorName + ") contents");
SecurityCheck.inspect(rs, "java.sql.ResultSet");
while (rs.next()) {
System.out.print(" {" + rs.getInt(1) + "}");
@@ -1708,7 +1721,7 @@
{
System.out.print("\ntesting jira 95 for DataSource");
EmbeddedDataSource ds = new EmbeddedDataSource();
- ds.setDatabaseName(dbName);
+ ds.setDatabaseName( dbName);
Connection conn1 = ds.getConnection();
conn1.close();
}
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource30.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource30.java?rev=391902&r1=391901&r2=391902&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource30.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource30.java Wed Apr 5 22:17:14 2006
@@ -55,11 +55,7 @@
public static void main(String[] args) throws Exception {
checkDataSource30 tester = new checkDataSource30();
- // portions of this test do not run yet with client and so
- // are enabled only for embedded with
- // if (TestUtil.isEmbeddedFramework())blocks
- if (TestUtil.isEmbeddedFramework())
- tester.runTest(args);
+ tester.runTest(args);
tester.checkXAHoldability();
testDerby1144();
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource_derby.properties
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource_derby.properties?rev=391902&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource_derby.properties (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource_derby.properties Wed Apr 5 22:17:14 2006
@@ -0,0 +1,2 @@
+derby.locks.deadlockTimeout=1
+derby.locks.waitTimeout=2
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource_derby.properties
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant?rev=391902&r1=391901&r2=391902&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant Wed Apr 5 22:17:14 2006
@@ -8,6 +8,7 @@
bestrowidentifier_app.properties
checkDataSource30_app.properties
checkDataSource30_derby.properties
+checkDataSource_derby.properties
checkDriver_app.properties
checkDriver_derby.properties
dataSourceReference_app.properties