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

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
Oliver
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