Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Commons Users List" <user@commons.apache.org>
Received-SPF: pass (athena.apache.org: domain of ashah@opnet.com designates
 65.161.183.6 as permitted sender)
Message-ID: <500FFC3C.3050604@opnet.com>
Date: Wed, 25 Jul 2012 10:01:32 -0400
From: Amish Shah <ashah@opnet.com>
Reply-To: ashah@nc.opnet.com
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
 rv:1.9.2.28) Gecko/20120306 Thunderbird/3.1.20
MIME-Version: 1.0
To: user@commons.apache.org
Subject: [dbcp] prepared statement caching when connections are closed but
 connection pool still has connection
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Does the DBCP support prepared statement caching in the following condition
1) connection is opened from connection pool
2) Prepared statement are used
3) Connection is closed but returned to connection pool

If we reuse the connection from the connection pool is there a way the 
prepared statement from step #2,
could be used without parsing again.


What I am seeing is that prepared statement are being parsed again?
We are using version of DBCP 1.2.1

Any help/response would be good.

Amish Shah
OPNET Technology


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org