We have seen the same problem before. Closing everything cleanly wouldn't solve the problem. We don't really know whether this is an Oracle or Weblogic bug. The problem is that the Oracle db will cache all your opened cursors of prepared statements even though the statement itself is closed. The workaround we had was to set the PreparedStatement CacheSize value to 0 (you can do this on the Weblogic admin console). This seems to have fixed the problem. Hope it helps.
-JJ Milind Khandekar wrote: > Make sure you are closing all these resources in a finally block, with > individual try blocks for every close() call. > > -----Original Message----- > From: Dipak Patil [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 18, 2002 11:16 AM > To: JDJList > Cc: [EMAIL PROTECTED] > Subject: [jdjlist] Re: Maximum open cursor error > > Hi Vimal, > > If your closing the result set, statement and > connection then this problem should not occur, unless > there are many concurrent users, value of database > initialization parameter OPEN_CURSOR is low. > If you are using the connection pool then may be that > con.close() returns the connection to the connection > pool, so actual connection is not closed and may be > for long time. I am not sure if this would be the > reason that cursors are not released. Check with your > DBA about the size of BUFFER_POOL_KEEP, > BUFFER_POOL_RECYCLE, if that has any impact. Generally > LRU algorithm is used to scrap the cursors. > > Just a thought. > > Take care, > Dipak. > > --- "Sharma,Vimal" <[EMAIL PROTECTED]> wrote: > > 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 > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Autos - Get free new car price quotes > http://autos.yahoo.com > > 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 To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
