users@glassfish.java.net

Re: ORA-1000 Max Open cursors

From: <glassfish_at_javadesktop.org>
Date: Wed, 10 Dec 2008 08:48:55 PST

* you can increase pool-resize-quantity.
* you can decrease the idle-timeout to a smaller value. If the connections are idle, they would be removed from the pool. This can help to minimize the statement leaks.

Tuning pool-resize-quantity, idle-timeout, max-connection-usage will help. Can you try using the statement caching available in Oracle driver. Not sure whether unclosed statements are taken care by the feature.
[Message sent by forum member 'jr158900' (jr158900)]

http://forums.java.net/jive/thread.jspa?messageID=321059