Hi Christian, This is a commonly faced problem and I am sure your will find hundreds of replies in the archives at : http://archives.java.sun.com/jsp-interest.html
For example, below is one of the recent replies from Rajesh for a similar discussion : Hope this helps ! Regards, Ritesh Database end You need to increase the number of allowable open cursors at the database end. Please lookup your Oracle documentation to get to the right point. Close ResultSets This happens because you do not close ResultSets. Rule - close everything Remember that the rule is to close every resource you open. If you do not use connection pooling be sure to close connections. Story / analogy We ran into such problems when we did load testing of an application at 250 simultaneous users. Oracle does not clean out open anonymous cursors for half-an-hour after they are opened. Cheers Rajesh Message----- at rare, random times we get the following error from our oracle 8i server (8.1.7): java.sql.SQLException: ORA-01000: maximum open cursors exceeded before anything I must say that we do close all our PreparedStatement, but not the ResultSet. AFAIK not closing the ResultSet shouldn't be a problem. We even had some tests on this issue and they were successfull. the maximum open cursors in our init.ora is 300 and we are using tomcat 4.1.12 ----- Original Message ----- From: "Christian Hamann L" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 11:48 PM Subject: Big Problem with anyone solution > Hi > i have Problems with my ConnectionPool , it is the first time that i use > this type of connection but i dont understand why is working bad. > I have Oracle Database and i use my ConnectionPool there, but when many > users connect , my application get a error ORA-01000 : OPEN CURSORS > EXCEDEED, and all connections of connection pool are closed.. my application > down.. > i increase the open_cursors parameter in my init.ora file, but is not a > solutions, the problem persist. > do you know any sentence to refreshh the cursors? or any sentence in my java > program which close the cursors? > atte > Christian Hamann L. > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
