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: local policy)
Date: Wed, 07 Jun 2006 11:17:36 -0400
From: Farrukh Najmi <Farrukh.Najmi@Sun.COM>
Subject: Newbie questions on PreparedStatement in Derby
Sender: Farrukh.Najmi@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <4486EE10.3020709@sun.com>
MIME-version: 1.0
Content-type: multipart/mixed; boundary="Boundary_(ID_mMAWLKOgSj8II9F15iP3vQ)"
User-Agent: Thunderbird 1.5.0.2 (X11/20060420)

This is a multi-part message in MIME format.

--Boundary_(ID_mMAWLKOgSj8II9F15iP3vQ)
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT


My application uses Derby 10.1 in a derby client that is a servlet 
running within a Servlet Container (typically Sun Java Application 
Srever 8.2 a.k.a AS or Tomcat 5.0.x).

We use PreparedStatement quite a bit. I would like to know what we can 
do to maximize reuse of PreparedStatement optimization plan within Derby.
Whose job is it to do PreparedStatement pooling?
Is is Derby's or the container (AS / Tomcat)?
What can we do do maximize leverage of PreparedStatement caching in my 
configurations?

BTW We do not typically close our PreparedStatement basedon the possibly 
faulty assumption that this would remove the PreparedStatement form the 
PreparedStatement cache. We instead rely on Connection.close() to take 
care of doing whatever closing is
needed to be done. Is this a bad practice?

Above practice has led us into trouble with the following known Derby issue:

http://issues.apache.org/jira/browse/DERBY-210

It seems the workaround is to close all PreparedStatements explicitly.

If we do that will it remove PreparedStatement that is being closed from 
the PreparedStatement cache?

Thanks for any guidance on this.

-- 
Regards,
Farrukh


--Boundary_(ID_mMAWLKOgSj8II9F15iP3vQ)
Content-type: text/x-vcard; name=farrukh.najmi.vcf; charset=utf-8
Content-transfer-encoding: 7BIT
Content-disposition: attachment; filename=farrukh.najmi.vcf

begin:vcard
fn:Farrukh Najmi
n:Najmi;Farrukh
email;internet:farrukh.najmi@sun.com
tel;work:781-442-9017
url:http://ebxmlrr.sourceforge.net/tmp/farrukhRacePointIcon.jpg
version:2.1
end:vcard


--Boundary_(ID_mMAWLKOgSj8II9F15iP3vQ)--