File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Android Security Essentials Live Lessons this week in the Android 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
 
Similar Threads
How do you having a varying content in a JFrame's status bar?
Agile Process basics
apache feedparser's alternative for media content parsing
Servlet,Xml: How to use servletInputStream for parsing xml?
Array List