Author: psteitz
Date: Sun Oct 18 17:10:23 2009
New Revision: 826470
URL: http://svn.apache.org/viewvc?rev=826470&view=rev
Log:
Added more explicit warning on statement pooling resource considerations.
Thanks to Bill Davidson.
Modified:
commons/proper/dbcp/trunk/xdocs/configuration.xml
Modified: commons/proper/dbcp/trunk/xdocs/configuration.xml
URL:
http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/xdocs/configuration.xml?rev=826470&r1=826469&r2=826470&view=diff
==============================================================================
--- commons/proper/dbcp/trunk/xdocs/configuration.xml (original)
+++ commons/proper/dbcp/trunk/xdocs/configuration.xml Sun Oct 18 17:10:23 2009
@@ -280,6 +280,10 @@
<p>
<img src="images/icon_warning_sml.gif"/>
<strong>NOTE</strong> - Make sure your connection has some resources left for
the other statements.
+Pooling PreparedStatements may keep their cursors open in the database,
causing a connection to run out of cursors,
+especially if maxOpenPreparedStatements is left at the default (unlimited) and
an application opens a large number
+of different PreparedStatements per connection. To avoid this problem,
maxOpenPreparedStatements should be set to a
+value less than the maximum number of cursors that can be open on a Connection.
</p>
