Solved

Maximum open cursors exceed

Posted on 2006-06-15
6
633 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
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
numbers ascending pyramid 101 195
stackato and cloud 4 85
Configure a Bean in an XML file 4 31
throw exception 21 44
For customizing the look of your lightweight component and making it look opaque like it was made of plastic.  This tip assumes your component to be of rectangular shape and completely opaque.   (CODE)
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…

770 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