Solved

Maximum open cursors exceed

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

860 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