Looking at the solution for ORA_01000

[Eung maeng]

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 [e-mail]
SQLException[COPYMAI]: ORA-01000: maximum open cursors exceeded

[SAFROLE YUTANI]

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]

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]

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:

PreparedStatement stmt = conn.prepareStatement("SELECT NAME FROM EMP WHERE ID=?");
try {
   stmt.setLong(1, id);
   ResultSet rs = stmt.executeQuery();
   while (rs.next) {
      String name = rs.getString(1);
      // ... whatever ...
   }
} finally {
   stmt.close();
}

- Peter
[ June 12, 2003: Message edited by: Peter den Haan ]

[SAFROLE YUTANI]

You're welcome, and I think Peter pretty much summed it up with his response.
Raffi