commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefano Nichele <>
Subject Re: [dbcp] poolPreparedStatements parameter
Date Thu, 26 Feb 2009 10:59:10 GMT
Thanks for you answer.  This is what I think (talking also about your 
other email). What I don't understand is why it is false by default. 
Maybe memory usage ? I don't know....I would like to turn on it on 
production but I'm a bit doubtful. Is there any trab ?
Bugs ? Just for completeness I'm using postgres.

Curious the fact that the validation query is not a prepared 
statement....but it should be performed rarely.


Gamnacke wrote:
> I can tell you that a modern database (Oracle 10) does not seem to do a good
> job of caching the query. According to snapshots taken on our DB we get a
> one-to-one correspondence between query execution and query parsing if we
> turn off pooling. With pooling turned on, the query needs only be parsed
> once.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message