Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 1197 invoked from network); 31 May 2006 20:54:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 May 2006 20:54:18 -0000 Received: (qmail 52461 invoked by uid 500); 31 May 2006 20:54:18 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 52352 invoked by uid 500); 31 May 2006 20:54:17 -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 52317 invoked by uid 99); 31 May 2006 20:54:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 31 May 2006 13:54:17 -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-SPF: pass (asf.osuosl.org: local policy) Received: from [140.211.166.113] (HELO eris.apache.org) (140.211.166.113) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 31 May 2006 13:54:13 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id 8C1991A983A; Wed, 31 May 2006 13:53:53 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r410665 [1/2] - in /db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests: master/ master/DerbyNetClient/ suites/ tests/jdbcapi/ util/ Date: Wed, 31 May 2006 20:53:51 -0000 To: derby-commits@db.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20060531205353.8C1991A983A@eris.apache.org> 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 May 31 13:53:51 2006 New Revision: 410665 URL: http://svn.apache.org/viewvc?rev=410665&view=rev Log: DERBY-435 jdbcapi/checkDataSource.java and jdbapi/checkDataSource30.java to tests should be changed or extended to test client DataSources Partial port to 10.1 Contributed by Deepa Remesh * Merges the latest version of checkDataSource and checkDataSource30 tests from trunk into 10.1 branch. I have tried to make the 10.1 files match as closely as possible to trunk files. I have not included the tests for following changes intended only for trunk - DERBY-412, DERBY-467, DERBY-571. * Adds permission required to read system property to the testing jar and classes folder. These permissions are copied from the trunk. * Adds jdbcapi/checkDataSource.java to derbynetclientmats suite. checkDataSource30.java does not pass with client. I think this is because changes for some of the bug fixes are not fully merged into 10.1. I am looking at this and will post with more information separately. I also see that some parts of checkDataSource30 test are still disabled with client though the corresponding bugs have been fixed. * Modifies master files and adds new masters for client. Tests run using Sun jdk1.4.2 on Windows XP with classes and sane jars : * checkDataSource.java with embedded and client framework * checkDataSource30.java with embedded framework Added: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out (with props) db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out (with props) Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource.out db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource30.out db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetclientmats.runall db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource.java db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/checkDataSource30.java db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/util/derby_tests.policy Added: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out?rev=410665&view=auto ============================================================================== --- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out (added) +++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out Wed May 31 13:53:51 2006 @@ -0,0 +1,467 @@ +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 +method calls on a closed connection +DriverManager .close() no error +DriverManager .createStatement() null - invalid operation: connection closed +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 +method calls on a closed connection +DataSource .close() no error +DataSource .createStatement() null - invalid operation: connection closed +DataSource .execute() null - Invalid operation: statement closed +Running connection checks on ConnectionPoolDataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(1):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Running connection checks on ConnectionPoolDataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(1):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Changes rolled back OK in auto closed pooled connection +EVENT(1):connectionClosed +expected org.apache.derby.client.am.SqlException: Invalid operation: result set closed +expected org.apache.derby.client.am.SqlException: Invalid operation: statement closed +Start testPoolReset ConnectionPoolDataSource +IDENTITY_VAL_LOCAL=1 +IDENTITY_VAL_LOCAL=2 +IDENTITY_VAL_LOCAL=3 +End testPoolReset ConnectionPoolDataSource +Running connection checks on XADataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(3):connectionClosed +method calls on a closed connection +XADataSource .close() no error +XADataSource .createStatement() null - Attempt to use a closed 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 +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 +method calls on a closed connection +DriverManager .close() no error +DriverManager .createStatement() null - invalid operation: connection closed +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 +method calls on a closed connection +DataSource .close() no error +DataSource .createStatement() null - invalid operation: connection closed +DataSource .execute() null - Invalid operation: statement closed +Running connection checks on ConnectionPoolDataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(2):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Running connection checks on ConnectionPoolDataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(2):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Running connection checks on XADataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(4):connectionClosed +method calls on a closed connection +XADataSource .close() no error +XADataSource .createStatement() null - Attempt to use a closed connection. +XADataSource .execute() null - Invalid operation: statement closed +Running connection checks on XADataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(4):connectionClosed +method calls on a closed connection +XADataSource .close() no error +XADataSource .createStatement() null - Attempt to use a closed connection. +XADataSource .execute() null - Invalid operation: statement closed +EVENT(5):connectionClosed +Running connection checks on Global XADataSource + isolation level 2 + auto commit false + read only false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Global XADataSource .close() no error +Global XADataSource .createStatement() null - Attempt to use a closed connection. +Global XADataSource .execute() null - Invalid operation: statement closed +Running connection checks on Global XADataSource + isolation level 2 + auto commit false + read only false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Global XADataSource .close() no error +Global XADataSource .createStatement() null - Attempt to use a closed connection. +Global XADataSource .execute() null - Invalid operation: statement closed +Running connection checks on Switch to local XADataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to local XADataSource .close() no error +Switch to local XADataSource .createStatement() null - Attempt to use a closed connection. +Switch to local XADataSource .execute() null - Invalid operation: statement closed +Running connection checks on Switch to local XADataSource + isolation level 2 + auto commit true + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to local XADataSource .close() no error +Switch to local XADataSource .createStatement() null - Attempt to use a closed connection. +Switch to local XADataSource .execute() null - Invalid operation: statement closed +Running connection checks on Switch to global XADataSource + isolation level 2 + auto commit false + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to global XADataSource .close() no error +Switch to global XADataSource .createStatement() null - Attempt to use a closed connection. +Switch to global XADataSource .execute() null - Invalid operation: statement closed +Running connection checks on Switch to global XADataSource + isolation level 2 + auto commit false + read only false + has warnings false +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for Statement.getConnection() +FAIL incorrect connection object returned for DatabaseMetaData.getConnection() +setTypeMap(EMPTY_MAP) - FAIL null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to global XADataSource .close() no error +Switch to global XADataSource .createStatement() null - Attempt to use a closed connection. +Switch to global XADataSource .execute() null - Invalid operation: statement closed +initial local + isolation level READ_COMMITTED + auto commit true + read only false +initial X1 + isolation level READ_COMMITTED + auto commit false + read only false +modified X1 + isolation level READ_UNCOMMITTED + auto commit false + read only false +modified local + isolation level READ_UNCOMMITTED + auto commit true + read only false +reset local + isolation level READ_COMMITTED + auto commit true + read only false +back to local (same as reset) + isolation level READ_COMMITTED + auto commit true + read only false +EVENT(6):connectionClosed +new handle - local + isolation level READ_COMMITTED + auto commit true + read only false +EVENT(6):connectionClosed +EVENT(6):connectionClosed +pre-X1 commit - local + isolation level REPEATABLE_READ + auto commit true + read only false +post-X1 end - local + isolation level REPEATABLE_READ + auto commit true + read only false +post-X1 commit - local + isolation level REPEATABLE_READ + auto commit true + read only false +EVENT(6):connectionClosed +Some more isolation testing using SQL and JDBC api +initial local + isolation level READ_COMMITTED + auto commit true + read only false +Issue setTransactionIsolation in local transaction +setTransactionIsolation in local + isolation level READ_UNCOMMITTED + auto commit true + read only false +TESTING RE_USE OF STATEMENT OBJECTS +LOCK TABLE +END LOCK TABLE +Statement State @ Create + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 444 + getMaxFieldSize() 713 + getMaxRows() 19 +Statement State @ PS Create + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 888 + getMaxFieldSize() 317 + getMaxRows() 91 +Statement State @ CS Create + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 999 + getMaxFieldSize() 137 + getMaxRows() 85 +Params-local-1: ru(params) contents {3} +sru1-local-1: mismatched Statement connection +sru1-local-1: ru(SN1) contents {1} {2} {3} +Expecting downgrade because global transaction sru1-global-2 is using 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 downgrade because global transaction sru1-global-4 is using 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 +Statement State @ PS GLOBAL + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 888 + getMaxFieldSize() 317 + getMaxRows() 91 +Statement State @ CS GLOBAL + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 999 + getMaxFieldSize() 137 + getMaxRows() 85 +Params-global-1: ru(SQL_CURLH000C) contents {3} +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 +Statement State @ PS LOCAL + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 888 + getMaxFieldSize() 317 + getMaxRows() 91 +Statement State @ CS LOCAL + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 999 + getMaxFieldSize() 137 + getMaxRows() 85 +Params-local-2: ru(SQL_CURLH000C) contents {3} +LOCK TABLE + xid row 0 lock count 14 + xid row 1 lock count 14 +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 +Statement State @ PS LOCAL 2 + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 888 + getMaxFieldSize() 317 + getMaxRows() 91 +Statement State @ CS LOCAL 2 + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 999 + getMaxFieldSize() 137 + getMaxRows() 85 +LOCK TABLE + xid row 0 lock count 14 + 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 +conn4 autcommit true +acxs 1 +acxs 2 +autocommitxastart expected Invalid operation: result set closed +acxs 1 +acxs 2 +autocommitxastart expected : XAException - XAER_OUTSIDE : Error executing a XAResource.start(), Server returned XAER_OUTSIDE +Expected XA error code: -9 +acxs 3 +testing jira 95 for DataSource; ok - expected exception: XCY00 +testing jira 95 for XADataSource; ok - expected exception: XCY00 +Completed checkDataSource Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource.out ------------------------------------------------------------------------------ svn:eol-style = native Added: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out?rev=410665&view=auto ============================================================================== --- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out (added) +++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out Wed May 31 13:53:51 2006 @@ -0,0 +1,631 @@ +Running JDBC 3.0 connection checks on DriverManager + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 +method calls on a closed connection +DriverManager .close() no error +DriverManager .createStatement() null - invalid operation: connection closed +DriverManager .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on DataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 +method calls on a closed connection +DataSource .close() no error +DataSource .createStatement() null - invalid operation: connection closed +DataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on ConnectionPoolDataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(1):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on ConnectionPoolDataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(1):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Changes rolled back OK in auto closed pooled connection +EVENT(1):connectionClosed +expected org.apache.derby.client.am.SqlException: Invalid operation: result set closed +expected org.apache.derby.client.am.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 org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(3):connectionClosed +method calls on a closed connection +XADataSource .close() no error +XADataSource .createStatement() null - Attempt to use a closed 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 +Running JDBC 3.0 connection checks on DriverManager + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 +method calls on a closed connection +DriverManager .close() no error +DriverManager .createStatement() null - invalid operation: connection closed +DriverManager .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on DataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 +method calls on a closed connection +DataSource .close() no error +DataSource .createStatement() null - invalid operation: connection closed +DataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on ConnectionPoolDataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(2):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on ConnectionPoolDataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(2):connectionClosed +method calls on a closed connection +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() null - Attempt to use a closed connection. +ConnectionPoolDataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on XADataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(4):connectionClosed +method calls on a closed connection +XADataSource .close() no error +XADataSource .createStatement() null - Attempt to use a closed connection. +XADataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on XADataSource + holdability true +JDBC 3.0 savepoint org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(4):connectionClosed +method calls on a closed connection +XADataSource .close() no error +XADataSource .createStatement() null - Attempt to use a closed 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 SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Global XADataSource .close() no error +Global XADataSource .createStatement() null - Attempt to use a closed connection. +Global XADataSource .execute() null - Invalid operation: statement closed +Running JDBC 3.0 connection checks on Global XADataSource + holdability false +JDBC 3.0 savepoint SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Global XADataSource .close() no error +Global XADataSource .createStatement() null - Attempt to use a closed 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 org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to local XADataSource .close() no error +Switch to local XADataSource .createStatement() null - Attempt to use a closed 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 org.apache.derby.client.am.SqlException: Cannot set savepoint when in auto-commit mode. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to local XADataSource .close() no error +Switch to local XADataSource .createStatement() null - Attempt to use a closed 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 SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to global XADataSource .close() no error +Switch to global XADataSource .createStatement() null - Attempt to use a closed 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 SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface. +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 null - Connection.setTypeMap is not supported +setTypeMap(null) - ok null - Connection.setTypeMap is not supported +setTypeMap(map) - ok null - Connection.setTypeMap is not supported +EVENT(5):connectionClosed +method calls on a closed connection +Switch to global XADataSource .close() no error +Switch to global XADataSource .createStatement() null - Attempt to use a closed 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 +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 downgrade because global transaction sru1-global-2 is using 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 downgrade because global transaction sru1-global-4 is using 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() CLOSE_CURSORS_AT_COMMIT +Statement State @ PS GLOBAL + getResultSetType() SCROLL_INSENSITIVE + getResultSetConcurrency() READ_ONLY + getFetchDirection() REVERSE + getFetchSize() 888 + getMaxFieldSize() 317 + getMaxRows() 91 + getResultSetHoldability() CLOSE_CURSORS_AT_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() CLOSE_CURSORS_AT_COMMIT + Parameter Count 2 + 1 type 12 + 2 type 12 +Params-global-1: ru(SQL_CURLH000C) contents {3} +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 +Params-local-2: ru(SQL_CURLH000C) contents {3} +LOCK TABLE + xid row 0 lock count 14 + xid row 1 lock count 14 +END LOCK TABLE +sru1-local-8: ru(SN1) contents {1} {2} {3} +sru2-local-9: ru(OAK2) contents {1} {2} {3} +sru3-local-10: ru(SF3) 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 14 + 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 +conn4 autcommit true +acxs 1 +acxs 2 +autocommitxastart expected Invalid operation: result set closed +acxs 1 +acxs 2 +autocommitxastart expected : XAException - XAER_OUTSIDE : Error executing a XAResource.start(), Server returned XAER_OUTSIDE +Expected XA error code: -9 +acxs 3 +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 +CONNECTION(not in xa transaction yet) HOLDABILITY true +Notice that autocommit now is false for connection because it is part of the global transaction +Notice that connection's holdability at this point is CLOSE_CURSORS_AT_COMMIT because it is part of the global transaction +CONNECTION(in xa transaction) HOLDABILITY false +CONNECTION(in xa transaction) HOLDABILITY false +Autocommit on Connection inside global transaction has been set correctly to false +CONNECTION(non-xa) HOLDABILITY false +STATEMENT HOLDABILITY false +STATEMENT HOLDABILITY false +STATEMENT HOLDABILITY true +PREPARED STATEMENT HOLDABILITY true +CALLABLE STATEMENT HOLDABILITY true +H@1 id 1 +H@2 id 2 +H@3 id 3 +CONNECTION(xa) HOLDABILITY false +STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false +STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false +STATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false +PREPAREDSTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false +CALLABLESTATEMENT(this one was created with default holdability inside this global transaction. Check it's holdability) HOLDABILITY false +X@1 id 1 +X@2 id 2 +Expected SQLException No current connection. +Expected SQLException No current connection. +resume XA transaction and keep using rs +Check holdability of various jdbc objects after resuming XA transaction +CONNECTION(xa) HOLDABILITY false +STATEMENT(this one was created with holdability false, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false +STATEMENT(this one was created with holdability true, outside the global transaction. Check it's holdability inside global transaction) HOLDABILITY false +STATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false +PREPAREDSTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false +CALLABLESTATEMENT(this one was created with default holdability inside the global transaction when it was first started. Check it's holdability) HOLDABILITY false +STATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false +PREPAREDSTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false +CALLABLESTATEMENT(this one was created with default holdability after the global transaction was resumed. Check it's holdability) HOLDABILITY false +X@3 id 3 +Expected SQLException ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF. +Expected SQLException ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF. +Set connection to hold +CONNECTION(held) HOLDABILITY true +CONNECTION(xa) HOLDABILITY false +Expected SQLException(setHoldability) Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction. +HOLDABLE Statement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction. +HOLDABLE PreparedStatement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction. +HOLDABLE CallableStatement in global xact false connection warning ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction. +STATEMENT HOLDABILITY false +PREPARED STATEMENT HOLDABILITY false +CALLABLE STATEMENT HOLDABILITY false +CONNECTION(held) HOLDABILITY true +PASS XA HOLDABILITY TEST +**Test holdability state for: PooledConnection ** +PASS: Holdability matches expected holdability:HOLD_CURSORS_OVER_COMMIT +** Test autoCommit state for: PooledConnection** +PASS: autoCommit reset on getConnection +done creating table +*** Test isolation level reset on PooledConnection.getConnection()*** +setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED +PASS: No lock timeout occurs for READ_UNCOMMITTED +Get a new connection with PooledConnection.getConnection() +Isolation level should be reset to READ_COMMITTED +PASS: Expected lock timeout for READ_COMMITTED +done creating table +*** Test isolation level reset on XAConnection.getConnection()*** +setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED +PASS: No lock timeout occurs for READ_UNCOMMITTED +Get a new connection with XAConnection.getConnection() +Isolation level should be reset to READ_COMMITTED +PASS: Expected lock timeout for READ_COMMITTED +Completed checkDataSource30 Propchange: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/checkDataSource30.out ------------------------------------------------------------------------------ svn:eol-style = native Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource.out?rev=410665&r1=410664&r2=410665&view=diff ============================================================================== --- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource.out (original) +++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource.out Wed May 31 13:53:51 2006 @@ -2,6 +2,13 @@ isolation level 2 auto commit false read only false +setTypeMap(EMPTY_MAP) - ok +setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap' +setTypeMap(map) - ok 0A000 - Feature not implemented: no details. +method calls on a closed connection +Nested .close() no error +Nested .createStatement() 08003 - No current connection. +Nested .execute() XJ012 - 'Statement' already closed. Running connection checks on DriverManager isolation level 2 auto commit true @@ -13,7 +20,7 @@ DriverManager .close() no error DriverManager .createStatement() 08003 - No current connection. DriverManager .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedDataSource +Running connection checks on DataSource isolation level 2 auto commit true read only false @@ -22,10 +29,10 @@ setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap' setTypeMap(map) - ok 0A000 - Feature not implemented: no details. method calls on a closed connection -EmbeddedDataSource .close() no error -EmbeddedDataSource .createStatement() 08003 - No current connection. -EmbeddedDataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedSimpleDataSource +DataSource .close() no error +DataSource .createStatement() 08003 - No current connection. +DataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on SimpleDataSource isolation level 2 auto commit true read only false @@ -34,10 +41,10 @@ setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap' setTypeMap(map) - ok 0A000 - Feature not implemented: no details. method calls on a closed connection -EmbeddedSimpleDataSource .close() no error -EmbeddedSimpleDataSource .createStatement() 08003 - No current connection. -EmbeddedSimpleDataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedConnectionPoolDataSource +SimpleDataSource .close() no error +SimpleDataSource .createStatement() 08003 - No current connection. +SimpleDataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on ConnectionPoolDataSource isolation level 2 auto commit true read only false @@ -47,10 +54,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(1):connectionClosed method calls on a closed connection -EmbeddedConnectionPoolDataSource .close() no error -EmbeddedConnectionPoolDataSource .createStatement() 08003 - No current connection. -EmbeddedConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedConnectionPoolDataSource +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on ConnectionPoolDataSource isolation level 2 auto commit true read only false @@ -60,19 +67,19 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(1):connectionClosed method calls on a closed connection -EmbeddedConnectionPoolDataSource .close() no error -EmbeddedConnectionPoolDataSource .createStatement() 08003 - No current connection. -EmbeddedConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. Changes rolled back OK in auto closed pooled connection EVENT(1):connectionClosed expected SQL Exception: No current connection. expected SQL Exception: No current connection. -Start testPoolReset EmbeddedConnectionPoolDataSource +Start testPoolReset ConnectionPoolDataSource IDENTITY_VAL_LOCAL=1 IDENTITY_VAL_LOCAL=2 IDENTITY_VAL_LOCAL=3 -End testPoolReset EmbeddedConnectionPoolDataSource -Running connection checks on EmbeddedXADataSource +End testPoolReset ConnectionPoolDataSource +Running connection checks on XADataSource isolation level 2 auto commit true read only false @@ -82,21 +89,28 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(3):connectionClosed method calls on a closed connection -EmbeddedXADataSource .close() no error -EmbeddedXADataSource .createStatement() 08003 - No current connection. -EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. +XADataSource .close() no error +XADataSource .createStatement() 08003 - No current connection. +XADataSource .execute() XJ012 - 'Statement' already closed. Changes rolled back OK in auto closed local XAConnection EVENT(3):connectionClosed -Start testPoolReset EmbeddedXADataSource +Start testPoolReset XADataSource IDENTITY_VAL_LOCAL=1 IDENTITY_VAL_LOCAL=2 IDENTITY_VAL_LOCAL=3 -End testPoolReset EmbeddedXADataSource +End testPoolReset XADataSource ERROR XJ015: Derby system shutdown. Running connection checks on Nested isolation level 2 auto commit false read only false +setTypeMap(EMPTY_MAP) - ok +setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap' +setTypeMap(map) - ok 0A000 - Feature not implemented: no details. +method calls on a closed connection +Nested .close() no error +Nested .createStatement() 08003 - No current connection. +Nested .execute() XJ012 - 'Statement' already closed. Running connection checks on DriverManager isolation level 2 auto commit true @@ -108,7 +122,7 @@ DriverManager .close() no error DriverManager .createStatement() 08003 - No current connection. DriverManager .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedDataSource +Running connection checks on DataSource isolation level 2 auto commit true read only false @@ -117,9 +131,9 @@ setTypeMap(null) - ok XJ081 - Invalid value 'null' passed as parameter 'map' to method 'java.sql.Connection.setTypeMap' setTypeMap(map) - ok 0A000 - Feature not implemented: no details. method calls on a closed connection -EmbeddedDataSource .close() no error -EmbeddedDataSource .createStatement() 08003 - No current connection. -EmbeddedDataSource .execute() XJ012 - 'Statement' already closed. +DataSource .close() no error +DataSource .createStatement() 08003 - No current connection. +DataSource .execute() XJ012 - 'Statement' already closed. Running connection checks on EmbeddedSimpleDataSource isolation level 2 auto commit true @@ -132,7 +146,7 @@ EmbeddedSimpleDataSource .close() no error EmbeddedSimpleDataSource .createStatement() 08003 - No current connection. EmbeddedSimpleDataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedConnectionPoolDataSource +Running connection checks on ConnectionPoolDataSource isolation level 2 auto commit true read only false @@ -142,10 +156,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(2):connectionClosed method calls on a closed connection -EmbeddedConnectionPoolDataSource .close() no error -EmbeddedConnectionPoolDataSource .createStatement() 08003 - No current connection. -EmbeddedConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedConnectionPoolDataSource +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on ConnectionPoolDataSource isolation level 2 auto commit true read only false @@ -155,10 +169,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(2):connectionClosed method calls on a closed connection -EmbeddedConnectionPoolDataSource .close() no error -EmbeddedConnectionPoolDataSource .createStatement() 08003 - No current connection. -EmbeddedConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedXADataSource +ConnectionPoolDataSource .close() no error +ConnectionPoolDataSource .createStatement() 08003 - No current connection. +ConnectionPoolDataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on XADataSource isolation level 2 auto commit true read only false @@ -168,10 +182,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(4):connectionClosed method calls on a closed connection -EmbeddedXADataSource .close() no error -EmbeddedXADataSource .createStatement() 08003 - No current connection. -EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on EmbeddedXADataSource +XADataSource .close() no error +XADataSource .createStatement() 08003 - No current connection. +XADataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on XADataSource isolation level 2 auto commit true read only false @@ -181,11 +195,11 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(4):connectionClosed method calls on a closed connection -EmbeddedXADataSource .close() no error -EmbeddedXADataSource .createStatement() 08003 - No current connection. -EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. +XADataSource .close() no error +XADataSource .createStatement() 08003 - No current connection. +XADataSource .execute() XJ012 - 'Statement' already closed. EVENT(5):connectionClosed -Running connection checks on Global EmbeddedXADataSource +Running connection checks on Global XADataSource isolation level 2 auto commit false read only false @@ -194,10 +208,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(5):connectionClosed method calls on a closed connection -Global EmbeddedXADataSource .close() no error -Global EmbeddedXADataSource .createStatement() 08003 - No current connection. -Global EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on Global EmbeddedXADataSource +Global XADataSource .close() no error +Global XADataSource .createStatement() 08003 - No current connection. +Global XADataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on Global XADataSource isolation level 2 auto commit false read only false @@ -206,10 +220,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(5):connectionClosed method calls on a closed connection -Global EmbeddedXADataSource .close() no error -Global EmbeddedXADataSource .createStatement() 08003 - No current connection. -Global EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on Switch to local EmbeddedXADataSource +Global XADataSource .close() no error +Global XADataSource .createStatement() 08003 - No current connection. +Global XADataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on Switch to local XADataSource isolation level 2 auto commit true read only false @@ -219,10 +233,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(5):connectionClosed method calls on a closed connection -Switch to local EmbeddedXADataSource .close() no error -Switch to local EmbeddedXADataSource .createStatement() 08003 - No current connection. -Switch to local EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on Switch to local EmbeddedXADataSource +Switch to local XADataSource .close() no error +Switch to local XADataSource .createStatement() 08003 - No current connection. +Switch to local XADataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on Switch to local XADataSource isolation level 2 auto commit true read only false @@ -232,10 +246,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(5):connectionClosed method calls on a closed connection -Switch to local EmbeddedXADataSource .close() no error -Switch to local EmbeddedXADataSource .createStatement() 08003 - No current connection. -Switch to local EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on Switch to global EmbeddedXADataSource +Switch to local XADataSource .close() no error +Switch to local XADataSource .createStatement() 08003 - No current connection. +Switch to local XADataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on Switch to global XADataSource isolation level 2 auto commit false read only false @@ -245,10 +259,10 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(5):connectionClosed method calls on a closed connection -Switch to global EmbeddedXADataSource .close() no error -Switch to global EmbeddedXADataSource .createStatement() 08003 - No current connection. -Switch to global EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. -Running connection checks on Switch to global EmbeddedXADataSource +Switch to global XADataSource .close() no error +Switch to global XADataSource .createStatement() 08003 - No current connection. +Switch to global XADataSource .execute() XJ012 - 'Statement' already closed. +Running connection checks on Switch to global XADataSource isolation level 2 auto commit false read only false @@ -258,9 +272,9 @@ setTypeMap(map) - ok 0A000 - Feature not implemented: no details. EVENT(5):connectionClosed method calls on a closed connection -Switch to global EmbeddedXADataSource .close() no error -Switch to global EmbeddedXADataSource .createStatement() 08003 - No current connection. -Switch to global EmbeddedXADataSource .execute() XJ012 - 'Statement' already closed. +Switch to global XADataSource .close() no error +Switch to global XADataSource .createStatement() 08003 - No current connection. +Switch to global XADataSource .execute() XJ012 - 'Statement' already closed. initial local isolation level READ_COMMITTED auto commit true @@ -519,6 +533,7 @@ acxs 1 acxs 2 autocommitxastart expected : XAException - null +Expected XA error code: -9 acxs 3 testing jira 95 for DataSource; ok - expected exception: XCY00 testing jira 95 for XADataSource; ok - expected exception: XCY00