From derby-commits-return-2858-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Thu Apr 06 05:17:44 2006 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 20248 invoked from network); 6 Apr 2006 05:17:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Apr 2006 05:17:43 -0000 Received: (qmail 73736 invoked by uid 500); 6 Apr 2006 05:17:43 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 73667 invoked by uid 500); 6 Apr 2006 05:17:42 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 73656 invoked by uid 99); 6 Apr 2006 05:17:42 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Apr 2006 22:17:42 -0700 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 05 Apr 2006 22:17:40 -0700 Received: (qmail 20103 invoked by uid 65534); 6 Apr 2006 05:17:19 -0000 Message-ID: <20060406051719.20102.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit 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 -0000 To: derby-commits@db.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.0.7 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 .close() no error -DriverManager .createStatement() null - invalid operation: connection closed +DriverManager .createStatement() 08003 - No current connection. DriverManager .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 .close() no error -DataSource .createStatement() null - invalid operation: connection closed +DataSource .createStatement() 08003 - No current connection. DataSource .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 .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 .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 .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 .close() no error -DriverManager .createStatement() null - invalid operation: connection closed +DriverManager .createStatement() 08003 - No current connection. DriverManager .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 .close() no error -DataSource .createStatement() null - invalid operation: connection closed +DataSource .createStatement() 08003 - No current connection. DataSource .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 .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 .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 .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 .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 .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 .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 .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 .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 .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 .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 .close() no error +DriverManager .createStatement() 08003 - No current connection. +DriverManager .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 .close() no error +DataSource .createStatement() 08003 - No current connection. +DataSource .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 .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .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 .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .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 .close() no error +XADataSource .createStatement() 08003 - No current connection. +XADataSource .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 .close() no error +DriverManager .createStatement() 08003 - No current connection. +DriverManager .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 .close() no error +DataSource .createStatement() 08003 - No current connection. +DataSource .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 .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .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 .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .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 .close() no error +XADataSource .createStatement() 08003 - No current connection. +XADataSource .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 .close() no error +XADataSource .createStatement() 08003 - No current connection. +XADataSource .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 .close() no error +Global XADataSource .createStatement() 08003 - No current connection. +Global XADataSource .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 .close() no error +Global XADataSource .createStatement() 08003 - No current connection. +Global XADataSource .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 .close() no error +Switch to local XADataSource .createStatement() 08003 - No current connection. +Switch to local XADataSource .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 .close() no error +Switch to local XADataSource .createStatement() 08003 - No current connection. +Switch to local XADataSource .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 .close() no error +Switch to global XADataSource .createStatement() 08003 - No current connection. +Switch to global XADataSource .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 .close() no error +Switch to global XADataSource .createStatement() 08003 - No current connection. +Switch to global XADataSource .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