commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amish Shah <>
Subject [dbcp] prepared statement caching when connections are closed but connection pool still has connection
Date Wed, 25 Jul 2012 14:01:32 GMT

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:
For additional commands, e-mail:

View raw message