Are you using connection pooling? If you do anything with SYSDATE, oracle
for some reason "caches" this and keeps a cursor open for "Select sydate
from dual". So, if you have 50 connections in your pool, you may have 50
open cursors. Also, make sure you close your statements, connections, and
result sets - or else Oracle will hold on to the cursor.
Neal Kaiser
[EMAIL PROTECTED]
(703) 281 - 1745
(703) 281 - 1626 FAX
On Wed, 21 Apr 1999, Bob Withers wrote:
> At 04:54 PM 4/21/99 +0530, you wrote:
> > 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
>
> Nimesh,
>
> Look at the v$open_cursor view to determine the SQL statements which have
> open cursors. If you have a cursor leak this should give you some idea of
> where it is.
>
> Regards,
> Bob
>
> ___________________________________________________________________________
> 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
>
___________________________________________________________________________
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
