db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r391902 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNetClient/ suites/ tests/jdbcapi/
Date Thu, 06 Apr 2006 05:17:18 GMT
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



Mime
View raw message