[jdjlist] RE: Maximum open cursor error

[Sylvestre, Kenny]

There is a parameter in the initialization file of an Oracle Database to specify Maximum Open Cursors. If your application exceeds the number specified in the parameter file of the Database you could get this Error.   Check with your DBA about this entry in the Database initialization file.   Thanks   Kenny     -----Original Message----- From: Jeff Fisher [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:27 AM To: JDJList Subject: [jdjlist] RE: Maximum open cursor error I would say it would have to be in WebLogic, not Oracle.  We use the thin driver in our own home grown app server and the only time we've gotten this problem is when we forgot to explicitly close a statement.  Our server has been running 24x7 for about 6 months now and we have not had an open cursor problem. -----Original Message----- From: Sharma,Vimal [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:20 AM To: JDJList Subject: [jdjlist] Maximum open cursor error Guys,   We have an application that runs  Weblogic Server 6.1sp1 with Oracle Thin Driver on Oracle8.1.7. Servlet calls a  stored procedure which returns a cursor, than fetches the rows using the cursor and then cleanly closes everything ( statements, results sets, connection ). Once in 3 days application cashes with Exception:ORA-01000: maximum open cursors exceeded.   Mind it I have checked application many times for closing statement object, resultset object and connection object. Everything is closed. Can it be any other reason, like bug in oracle driver or in weblogic.   If anybody has any clue on this, it will be greatly appreciated.   Thanks, Vimal   To change your membership options, refer to: http://www.sys-con.com/java/list.cfm CONFIDENTIALITY NOTICE This transmission is intended for the sole use of the individual and/or entity to whom it is addressed, and may contain information and/or attachments that are privileged, confidential and exempt from disclosure under applicable law. If the reader of this transmission is not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, duplication or the taking of any action in reliance on the contents of this transmission by someone other than the intended addressee or its designated agent is strictly prohibited. If your receipt of this transmission is in error, please notify the sender by replying immediately to this transmission and destroy the transmission. Thank you. (MSPR2/ODrt) To change your membership options, refer to: http://www.sys-con.com/java/list.cfm