Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of dremesh@gmail.com designates
 66.249.82.192 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=IPdB4eTYsDvYGRjhHIjRNA1AnzVwXBAbv6UGDfm8OZGnR6tz1UWUZb+OXuq53AW4gX5n69TkaUtPQTobNPJ+41thIxn+XIHo8Bma6+ZKOTQvv/JcZctQ+jFL+FoC7Hn1uDZBi7LLMrXk4eHB/Juw0nc4gfhgzbLqDx5NsSAxvJs=
Message-ID: <58ed70f50606091517n206afad7ne98599d4c55e6693@mail.gmail.com>
Date: Fri, 9 Jun 2006 15:17:21 -0700
From: "Deepa Remesh" <dremesh@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Newbie questions on PreparedStatement in Derby
In-Reply-To: <44891AE3.5030007@sun.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4486EE10.3020709@sun.com> <4486FA00.7070805@gmail.com>
	 <44871885.6050602@sun.com> <44891AE3.5030007@sun.com>

On 6/8/06, Farrukh Najmi <Farrukh.Najmi@sun.com> wrote:
>
> OK. So I will make sure to explictly close all PreparedStatements in
> finally blocks and not rely on Connection.close() so as to avoid:
>
> http://issues.apache.org/jira/browse/DERBY-210
>
> One more related question. Are there known memory leaks if my
> application also does not close regular Statements (as opposed to
> PreparedStatements)
> and relies on Connection.close()?

Yes. The memory leak applies to regular Statements too. Please close
all statement objects explicitly after use.

Most of DERBY-210 has been fixed by the following sub-task
http://issues.apache.org/jira/browse/DERBY-1103. These fixes will be
available in the upcoming 10.1.3 release.

The list of outstanding issues for DERBY-210 can be seen at
http://issues.apache.org/jira/browse/DERBY-210#action_12370254

Thanks,
Deepa