Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 50432 invoked from network); 4 Jul 2005 20:39:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Jul 2005 20:39:29 -0000 Received: (qmail 48388 invoked by uid 500); 4 Jul 2005 20:39:24 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 48124 invoked by uid 500); 4 Jul 2005 20:39:22 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 48111 invoked by uid 99); 4 Jul 2005 20:39:22 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jul 2005 13:39:22 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of alan@chandlerfamily.org.uk designates 82.44.22.127 as permitted sender) Received: from [82.44.22.127] (HELO home.chandlerfamily.org.uk) (82.44.22.127) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jul 2005 13:39:23 -0700 Received: from kanger.home ([192.168.0.21]) by home.chandlerfamily.org.uk with esmtp (Exim 4.50) id 1DpXio-0005YY-V0 for commons-user@jakarta.apache.org; Mon, 04 Jul 2005 21:39:18 +0100 From: Alan Chandler To: commons-user@jakarta.apache.org Subject: [DBCP] PreparedStatement pooling with JSP pages Date: Mon, 4 Jul 2005 21:39:18 +0100 User-Agent: KMail/1.8.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200507042139.19020.alan@chandlerfamily.org.uk> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Assuming I set poolPreparedStatement to true in setting DBCP up, how do I re-use a prepared statement. Assuming at the start of a request, I grab a connection from the pool, how do I organise to get the same connection as the one I used on my previous run through on which I know I already have a prepared sql statement that I want to re-use. -- Alan Chandler http://www.chandlerfamily.org.uk --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org