Are you sure you are closing the object that references the cursor that is returned by the stored procedure before you close anything else? The Oracle drivers are notorious for not freeing the resources implicitly... Any resource allocated must be closed explicitly in the following order typically in a finally clause in a try/catch block;
result set, statement, connection. Greg. "Sharma,Vimal" <[EMAIL PROTECTED]> on 2002/07/11 10:19:49 AM Please respond to "JDJList" <[EMAIL PROTECTED]> To: "JDJList" <[EMAIL PROTECTED]> cc: 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 To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
