Home » Developer & Programmer » JDeveloper, Java & XML » Re: maximum open cursors exceeded
Re: maximum open cursors exceeded [message #90979] Fri, 25 January 2002 03:55
Messages: 30
Registered: April 1999

I experienced the same here. The problem was,
that statement.close() (where statement is the
database statement) would only be executed when
statement.update() didn't throw any exception.
Seems that not closing the statement will leave
you with an open cursor - after a certain number
of error messages (= maximum number of open
cursors in the database, I guess) I was flooded
with 'maximum open cursors...' error messages.
Calling statement.close() no matter what cured
the problem.
Hope that helps
Previous Topic: Re: Problem while connecting Oracle with JDBC Thin Driver
Next Topic: ClassNotFoundException
Goto Forum:

Current Time: Sun Oct 17 20:17:33 CDT 2021