473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ORA-01000 maximum open cursors exceeded

We are encountering the problem of "maximum open cursors exceeded"
exception.

Our web based system uses jdk1.3 as frontend with Oracle 9i as backend
and Oracle JDBC Driver version - 9.0.2.0.0 for connectivity.

Connection pooling is being used and the resultset is fetched in the
functions and returned to JSPs where the functions are being called.

As per the articles on the net this exception occurs as a result of
not closing the prepared statements/ statements/ resultSets.

The problem is how do we close the statements as we are using the
resultsets in the JSPs. We cannot close the prepared statements/
statements/ resultSets in the JSPs as we cannot access them because
they are local to the respective functions. Nor can we close them in
the functions as we are retrieving the records from the resultsets in
our JSPs.

Kindly reply with a solution as soon as possible.
Jul 19 '05 #1
3 21446
Deepali ,

I would select your results into a java object(i.e.hash table) in a
serverlet then close the cursor.
"Deepali Gupta" <de***********@yahoo.co.uk> wrote in message
news:c1**************************@posting.google.c om...
We are encountering the problem of "maximum open cursors exceeded"
exception.

Our web based system uses jdk1.3 as frontend with Oracle 9i as backend
and Oracle JDBC Driver version - 9.0.2.0.0 for connectivity.

Connection pooling is being used and the resultset is fetched in the
functions and returned to JSPs where the functions are being called.

As per the articles on the net this exception occurs as a result of
not closing the prepared statements/ statements/ resultSets.

The problem is how do we close the statements as we are using the
resultsets in the JSPs. We cannot close the prepared statements/
statements/ resultSets in the JSPs as we cannot access them because
they are local to the respective functions. Nor can we close them in
the functions as we are retrieving the records from the resultsets in
our JSPs.

Kindly reply with a solution as soon as possible.

Jul 19 '05 #2
"Dan White" <da*@omegaconcepts.net> wrote in message news:<ex*****************@nwrdny01.gnilink.net>...
Deepali ,

I would select your results into a java object(i.e.hash table) in a
serverlet then close the cursor.

Which is obviously a completely undesirable solution as you won't see
any changes to the table anymore. The OP just needs to increase the
init.ora parameter open_cursors and bounce the database.
I would strongly urge you to learn something about relational
databases.
Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #3
sy******@yahoo.com wrote in message news:<a1*************************@posting.google.c om>...
"Dan White" <da*@omegaconcepts.net> wrote in message news:<ex*****************@nwrdny01.gnilink.net>...
Deepali ,

I would select your results into a java object(i.e.hash table) in a
serverlet then close the cursor.

Which is obviously a completely undesirable solution as you won't see
any changes to the table anymore. The OP just needs to increase the
init.ora parameter open_cursors and bounce the database.
I would strongly urge you to learn something about relational
databases.
Sybrand Bakker
Senior Oracle DBA


If the problem is that statements aren't closed properly, increasing
open_cursors will only make it last a little longer before you have the
same problem again. If you're lucky the connection pool will clean up for
you but that solution is pure symptom fighting and will not help you.
Erik
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Subrahmanyam Arya | last post by:
Dear oracle gurus, I am unable to get past the error ORA-12154: TNS: could not resolve service name on my host when using hsodbc to talk to a remote mysql database. i got from the meta link all...
6
by: John | last post by:
Hi Right password -> ORA-12154: TNS:Could not resolve service name wrong password => ORA-01017: invalid username/password; logon denied Tested on a Windows XP client connecting to Oracle on...
1
by: Park Yeon Jo | last post by:
About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I installed Oracle 8.1.7 on Windows XP Professional. and I wanto connect to that server...
1
by: Adam Ruth | last post by:
I'm using OCI on Mac OS X and I've run into a strange problem with my TNSNAMES.ORA file. My TNSNAMES.ORA file has one entry INV4II and it works fine. However, it will only work if that is the...
6
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
4
by: Tig | last post by:
Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine. ...
2
by: mpatel6 | last post by:
I had this error in alert log and my instance was down, anybody can help me? Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc: ORA-07445: exception encountered: core...
2
by: Dwie | last post by:
Dear All, I'm a new in Oracle DB. I'm using Windows 2000 as server and Windows XP as client. I installed Oracle Enterprise on server and Oracle 8.1 on clients. I have some client with 2 different...
5
by: mivey4 | last post by:
Hi, First off, I am aware that this is a very heavily documented error and I have done my homework for throughly researching probable causes before deciding to post my problem here. At this point,...
1
by: michael ngong | last post by:
michael.john@gmx.at (Michael John) wrote in message news:<90cc4edd.0306230900.28075193@posting.google.com>... MIchael I you stated the OS and platform that could make it easier to address your...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.