This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes new jdbc exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "new jdbc exception" Watch "new jdbc exception" New topic
Author

new jdbc exception

Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
hi
i am getting this exception

ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded

what should i do
[ March 15, 2005: Message edited by: Bear Bibeault ]

Hareesh Ram Chanchali
SCJP 5.0, IBM Certified Solution Designer
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

exception itself is telling problem,

paste the code here

thanks


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Ed Wallen
Ranch Hand

Joined: Feb 11, 2002
Posts: 34
You have a limited number of resources on your Oracle instance. This is governed by the startup parameter "OPEN_CURSORS". This dictates how many cursors Oracle may have open at any given time. Sounds like you need to work with your DBA and tune your application and database.

-Ed
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by Ed Wallen:
You have a limited number of resources on your Oracle instance.


Yes there are limited number of resources, but they are sufficient enough.

There might be some problem in code like open connection or else, that is why I asked for code :roll:

Otherwise ORA-00604 itself is very confusing

This error is always followed by a reason !!! and if reason can not be corrected then only recommendation would be to contact Oracle Support.

I found same on a website

For Oracle version: 8i
ORA-00604 error occurred at recursive SQL level num

Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables

Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.



For Oracle version: 9i
ORA-00604 error occurred at recursive SQL level string

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.



thanks...
[ March 04, 2005: Message edited by: Shailesh Chandra ]
Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
thanks guys i got it cleared by incresing resources and also optimized my program
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: new jdbc exception