I have seen this error most commonly caused by the prepareStatement inside a loop and the stmt.close() outside the loop.
Dipak Patil wrote: > > 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
