Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 51999 invoked from network); 16 Nov 2007 15:18:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Nov 2007 15:18:06 -0000 Received: (qmail 98578 invoked by uid 500); 16 Nov 2007 15:17:52 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 98507 invoked by uid 500); 16 Nov 2007 15:17:52 -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 98497 invoked by uid 99); 16 Nov 2007 15:17:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Nov 2007 07:17:52 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED 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, 16 Nov 2007 15:17:50 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id CE91471424A for ; Fri, 16 Nov 2007 07:17:43 -0800 (PST) Message-ID: <1917988.1195226263842.JavaMail.jira@brutus> Date: Fri, 16 Nov 2007 07:17:43 -0800 (PST) From: "Dag H. Wanvik (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-2462) org.apache.derby.impl.store.access.BackingStoreHashTableFromScan does not honor ResultSet holdability In-Reply-To: <5766003.1174072989285.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 [ https://issues.apache.org/jira/browse/DERBY-2462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik closed DERBY-2462. -------------------------------- > org.apache.derby.impl.store.access.BackingStoreHashTableFromScan does not honor ResultSet holdability > ----------------------------------------------------------------------------------------------------- > > Key: DERBY-2462 > URL: https://issues.apache.org/jira/browse/DERBY-2462 > Project: Derby > Issue Type: Bug > Components: Store > Affects Versions: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0 > Environment: Test under Windows Vista, Java 1.4.2_13 > Reporter: Jeff Clary > Assignee: Dag H. Wanvik > Fix For: 10.3.1.4 > > Attachments: DERBY-2462-1.diff, DERBY-2462-1.stat, DERBY-2462-2.diff, DERBY-2462-2.stat, DERBY-2462-3.diff, DERBY-2462-3.stat, DERBY-2462-4.diff, DERBY-2462-4.stat, DerbyHoldabilityTest.java > > > After an unrelated statement on the same connection commits, and after some number of successful calls to ResultSet.next(), a subsequent call to ResultSet.next() throws an SQLException with a message like: The heap container with container id Container(-1, 1173965368428) is closed. This seems to be related to the hard-coded passing of false to the super in the constructor of org.apache.derby.impl.store.access.BackingStoreHashTableFromScan. > Steps to reproduce: > 1. Execute a statement on a connection that returns a result set. > 2. Execute a second statement on the same connection that modifies the database and commits. > 3. Call next() on the first result set until the exception is thrown. > Note that the number of rows that can be successfully retrieved from the result set seems to be related to the amount of data per row. Increasing the number of columns in the result set or the length of the columns causes the exception to be taken sooner. > The attached test program demonstrates the issue. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.