Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 44626 invoked from network); 17 Nov 2006 09:21:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Nov 2006 09:21:03 -0000 Received: (qmail 36614 invoked by uid 500); 17 Nov 2006 09:21:11 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 36575 invoked by uid 500); 17 Nov 2006 09:21:11 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 36525 invoked by uid 99); 17 Nov 2006 09:21:11 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Nov 2006 01:21:11 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Nov 2006 01:21:00 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 42A5371432A for ; Fri, 17 Nov 2006 01:20:40 -0800 (PST) Message-ID: <7265923.1163755240270.JavaMail.jira@brutus> Date: Fri, 17 Nov 2006 01:20:40 -0800 (PST) From: "Bernt M. Johnsen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Reopened: (DERBY-2084) getTransactionIsolation() in network client should not activate a transaction In-Reply-To: <7635963.1163507498266.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ http://issues.apache.org/jira/browse/DERBY-2084?page=all ] Bernt M. Johnsen reopened DERBY-2084: ------------------------------------- Merge to 10.2 > getTransactionIsolation() in network client should not activate a transaction > ----------------------------------------------------------------------------- > > Key: DERBY-2084 > URL: http://issues.apache.org/jira/browse/DERBY-2084 > Project: Derby > Issue Type: Bug > Components: Network Client > Affects Versions: 10.2.1.6, 10.1.3.1, 10.3.0.0 > Reporter: Bernt M. Johnsen > Assigned To: Bernt M. Johnsen > Fix For: 10.3.0.0 > > Attachments: DERBY-2084.diff > > > getTransactionIsolation() is implemented by means of > rs = getTransactionIsolationStmt.executeQuery("values current isolation"); > This will activate a transaction. Thus the code snippet > Connection conn = > DriverManager.getConnection(url); > conn.setAutoCommit(false); > int tx = conn.getTransactionIsolation(); > conn.close(); > will fail with > java.sql.SQLException: Cannot close a connection while a transaction is still active. > at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) > at org.apache.derby.client.am.Connection.closeResourcesX(Unknown Source) > at org.apache.derby.client.am.Connection.closeX(Unknown Source) > at org.apache.derby.client.net.NetConnection.closeX(Unknown Source) > at org.apache.derby.client.am.Connection.close(Unknown Source) > at org.apache.derby.client.net.NetConnection.close(Unknown Source) > at GetTransactionIsolation.test(GetTransactionIsolation.java:12) > at GetTransactionIsolation.main(GetTransactionIsolation.java:22) > Caused by: org.apache.derby.client.am.SqlException: Cannot close a connection while a transaction is still active. > at org.apache.derby.client.am.Connection.checkForTransactionInProgress(Unknown Source) > ... 7 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira