Support Forums: Message List - How to overcome maximum open cursors error http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Thu, 23 May 2013 11:10:00 -0400 chitu http://www.theserverside.com/discussions/thread.tss?thread_id=25583 this may occur in recursive calling of the code.

 

just increase your cursor limit in the databese configurationj file.

]]> Thu, 03 Nov 2011 04:29:32 -0400 Thu, 03 Nov 2011 04:29:32 -0400 Thu, 03 Nov 2011 04:29:32 -0400 Nov 3, 2011 ravipati chaitanya 0 re: how can we use the resultset? http://www.theserverside.com/discussions/thread.tss?thread_id=25583
This exception is triggered...]]> Wed, 29 Mar 2006 17:17:39 -0500 Wed, 29 Mar 2006 17:17:39 -0500 Wed, 29 Mar 2006 17:17:39 -0500 Mar 29, 2006 Cool Dude 0 how can we use the resultset? http://www.theserverside.com/discussions/thread.tss?thread_id=25583
 How can we use the result set if we are closing after every Iteration? It will give exception.]]> Fri, 24 Feb 2006 05:13:27 -0500 Fri, 24 Feb 2006 05:13:27 -0500 Fri, 24 Feb 2006 05:13:27 -0500 Feb 24, 2006 Yasoda Supraja 1 close all the resources http://www.theserverside.com/discussions/thread.tss?thread_id=25583 n times within a loop and not closing ResultSet/Statement object at the end of each loop iteration
We closed all the ResultSet/Statement object...]]> Wed, 28 Apr 2004 15:03:23 -0400 Wed, 28 Apr 2004 15:03:23 -0400 Wed, 28 Apr 2004 15:03:23 -0400 Apr 28, 2004 H Roy 2 Close all the resources http://www.theserverside.com/discussions/thread.tss?thread_id=25583 Wed, 28 Apr 2004 13:09:37 -0400 Wed, 28 Apr 2004 13:09:37 -0400 Wed, 28 Apr 2004 13:09:37 -0400 Apr 28, 2004 Kenneth Phang Tak Yan 0 How to overcome maximum open cursors error http://www.theserverside.com/discussions/thread.tss?thread_id=25583 You may need to release unused cursors sooner by closing unused resultsets <I would suggest a code review to fix this problem.
2. If problem still remains that...]]> Wed, 28 Apr 2004 10:41:53 -0400 Wed, 28 Apr 2004 10:41:53 -0400 Wed, 28 Apr 2004 10:41:53 -0400 Apr 28, 2004 Deepak Gupta 3 How to overcome maximum open cursors error http://www.theserverside.com/discussions/thread.tss?thread_id=25583
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Iam not getting this error frequently. In rare instantce its happening.
Pls do let me know
1) In Which scenrios this error will come
2) How...]]> Wed, 28 Apr 2004 09:50:07 -0400 Wed, 28 Apr 2004 09:50:07 -0400 Wed, 28 Apr 2004 09:50:07 -0400 Apr 28, 2004 Srinivas Reddy Bijjam 6