wood burning stoves*
The moose likes JDBC and the fly likes Looking at the solution for ORA_01000 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 "Looking at the solution for ORA_01000" Watch "Looking at the solution for ORA_01000" New topic
Author

Looking at the solution for ORA_01000

Eung maeng
Ranch Hand

Joined: Feb 10, 2002
Posts: 68
Hi guys,
Would anyone be able to show what the good way is to resolve this issue when I get in processing?
Sometime, I had the error in processing and fell over the process. I was getting problem with this.
Hope, look forward to hear from you. soon
paul
emai aul.maeng@intentia.com.au
SQLException[COPYMAI]: ORA-01000: maximum open cursors exceeded
SAFROLE YUTANI
Ranch Hand

Joined: Jul 06, 2001
Posts: 257
I've seen this error many times in the past, and it's usually because you're forgetting to close and release resources in your code, specifically ResultSets, Statements, PreparedStatements, etc. In your persistence logic code, make sure you have finally blocks that close all of your resources.
Hope it helps!
Raffi
Eung maeng
Ranch Hand

Joined: Feb 10, 2002
Posts: 68
Hi Raffi,
Really thanks for your comments. That's what i thought exactly. I was trying to put the close of each.
Should I close for resultset as well like preparedstatement?
And, when should I close fo them if I use while? That's hard for me to get correct place
thanks
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Closing a (Prepared)Statement will close any ResultSet that might still be open, so in many cases you can get away without closing this explicitly.
Not sure what you mean by your "while" question; the following snippet might help: - Peter
[ June 12, 2003: Message edited by: Peter den Haan ]
SAFROLE YUTANI
Ranch Hand

Joined: Jul 06, 2001
Posts: 257
You're welcome, and I think Peter pretty much summed it up with his response.
Raffi
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Looking at the solution for ORA_01000