Unbounded prepared statement pooling can bring Oracle to its knees
------------------------------------------------------------------
Key: GEOS-3727
URL: http://jira.codehaus.org/browse/GEOS-3727
Project: GeoServer
Issue Type: Bug
Reporter: Andrea Aime
Assignee: Andrea Aime
Fix For: 2.0.1
For most databases prepared statement caching is sort of cheap. For Oracle, it's not, each prepared statement keeps a cursor open on the server side.
Cursors are usually limited by admins being expensive resources to keep around.
Expose a property to limit the number of cached prepared statements.
Limitless does not sound very good in general, we may want to provide this property for any database that uses prepared statements.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira