commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Davidson <bill...@gmail.com>
Subject Re: DBCP woes (running out of cursors).
Date Fri, 16 Oct 2009 21:36:26 GMT
Bill Davidson wrote:
 >Could maxOpenPreparedStatements possibly fix this?

Apparently it does.

The DBCP config docs need a better warning on poolPreparedStatements:

"*NOTE* - Make sure your connection has some resources left for the 
other statements."

just doesn't quite cut it.  Something more like:

"Pooling PreparedStatement's may keep their cursors open in the database,
causing you to run out of cursors.  You should also set
maxOpenPreparedStatements to some value less than the maximum number
of cursors you can have on a Connection."

or something along those lines.

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


Mime
View raw message