Solved

Maximum open cursors exceed

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Java / Linux and Regular Expressions 11 71
JUnit 4 @Before and @BeforeClass differences 3 48
Java DateChooser? 3 29
print map entry 34 56
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
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…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now