From derby-user-return-1522-apmail-db-derby-user-archive=db.apache.org@db.apache.org Fri Jul 15 03:07:17 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 86767 invoked from network); 15 Jul 2005 03:07:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Jul 2005 03:07:17 -0000 Received: (qmail 67297 invoked by uid 500); 15 Jul 2005 03:07:16 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 67267 invoked by uid 500); 15 Jul 2005 03:07:15 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 67254 invoked by uid 99); 15 Jul 2005 03:07:15 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jul 2005 20:07:15 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.182.141] (HELO e1.ny.us.ibm.com) (32.97.182.141) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jul 2005 20:07:12 -0700 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [9.56.227.234]) by e1.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j6F37BCR010018 for ; Thu, 14 Jul 2005 23:07:11 -0400 Received: from d01av03.pok.ibm.com (d01av03.pok.ibm.com [9.56.224.217]) by d01relay02.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j6F37Au7254088 for ; Thu, 14 Jul 2005 23:07:10 -0400 Received: from d01av03.pok.ibm.com (loopback [127.0.0.1]) by d01av03.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j6F37AkC022873 for ; Thu, 14 Jul 2005 23:07:10 -0400 Received: from [127.0.0.1] (sig-9-48-119-34.mts.ibm.com [9.48.119.34]) by d01av03.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j6F3778F022779 for ; Thu, 14 Jul 2005 23:07:10 -0400 Message-ID: <42D7285A.8050208@sbcglobal.net> Date: Thu, 14 Jul 2005 20:07:06 -0700 From: Kathey Marsden User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Cursors References: <20050714045103.28866.qmail@web30707.mail.mud.yahoo.com> <42D70CD3.1090402@Sourcery.Org> In-Reply-To: <42D70CD3.1090402@Sourcery.Org> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Satheesh Bandaram wrote: >If closing ResultSets and Statements don't release memory, I think, that would >be a bug. If you have a repro, I would file a bug in Jira and attach a test case. > >Satheesh > > > >simmi iyer wrote: > >>What I mean is ResultSet.close() in java is not >>closing the cursors at database end. Because of that >>RAM utilized keeps on increasing and at some point of >>time "Out of Memory" error occurs. >> > > I don't know of a problem with ResultSets, but for network server, DERBY-210 is an issue for prepared statements. http://issues.apache.org/jira/browse/DERBY-210 I added a comment to the bug on how to workaround this issue. Kathey