I recently had this same problem. I thought I was closing all statements,
etc., but as it turned out, I wasn't. This became readily apparent when I
started to use a connection pool, as the connections were left open and I
had created umpteen cursors (our limit was the default 50 in Oracle) by the
way of not close() ing the statements,etc. Carefully check that if you
create something, you close it, especially if you are in a loop and use the
same variable to open or get a new statement, but never close the previous
one (that's the one that caught me). Definitely use a finally clause in a
try/catch as well. By the way, Oracle lets you change the configuration on
how many cursors you can have open and the default I believe is 50.
Gary
> -----Original Message-----
> From: Kenia Nimesh [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 21, 1999 6:25 AM
> To: [EMAIL PROTECTED]
> Subject: URGENT!! Too many cursors open
>
> In one of our program we are opening 3 ResultSet(cursors) at a given point
> of time.
> The queries are retreving records from the database.If there are many
> records retreived we are getting the foll error.
>
> java.sql.SQLException: ORA-01000: maximum open cursors exceeded
> We have Oracle 8.0.5 as our database.
> The maximum OPEN_CURSORS set in init(DBinstance).ora is 120 still we are
> getting the error.
> Please help me.
> Thanks in advance
> Nimesh
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
