Solved

Maximum open cursors exceed

Posted on 2006-06-15
6
636 Views
Last Modified: 2010-07-27
Hi

I have a problem with Open Cursor in ORACLE JDBC. While im handling 3 different results sets im getting the following error.

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

I have tried other solutions by increasing pool size and cursor size. I have to handle 10000 records which are coming form each ResultSet.

Its very urgent. Reply ASAP...
0
Comment
Question by:anumalas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 125 total points
ID: 16910639
Make sure you're closing de resources properly
0
 
LVL 1

Assisted Solution

by:Shoikana
Shoikana earned 125 total points
ID: 16910878
If you need the ResultSets together, you could dump each Result Set into a collection of records and then close the ResultSet.  
0
 
LVL 3

Assisted Solution

by:runa_paathak
runa_paathak earned 125 total points
ID: 16910886
You are probably not closing the ResultSet or Statement object properly. Close them in a finally block after you are done using them.
0
 
LVL 1

Assisted Solution

by:ctamrakar
ctamrakar earned 125 total points
ID: 16918549
increase the value of no.of open cursors parameter in  init.ora file. what is your current value for this parameter?
 But if you are not handling the cursors in JDBC code( closing resultset and statments) your program will consume
all the database cursor resources
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
The viewer will learn how to implement Singleton Design Pattern in Java.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question