Most likely, you're leaking connection handles or result sets. A common error is storing them on the session. When the session times out they are not necessarily garbage collected.
George Sexton MH Software, Inc. http://www.mhsoftware.com/ Voice: 303 438 9585 > -----Original Message----- > From: Sharath Babu S S S [mailto:sharath.b...@solix.com] > Sent: Thursday, September 17, 2009 8:22 PM > To: Tomcat Users List > Subject: Maximum Number of processes Exceeded > > > Hi, > > We are using Tomcat Server and oracle database. After running for a > while we are getting this error in the log files. > Its taking both inactive and active processess. how to remove the > inactive processess so that we dont have this error. > > Debug: makeConnection(Database) > > java.sql.SQLException: ORA-00020: maximum number of processes (300) > exceeded > > > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:1 > 12) > > at > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > > at > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283) > > at > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278) > > at > oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthentic > ate.java:294) > > at > oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357) > > at > oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:43 > 9) > > at > oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) > > at > oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension. > java:35) > > at > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) > > at > org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(Dr > iverConnectionFactory.java:38) > > at > org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Poolab > leConnectionFactory.java:294) > > at > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generic > ObjectPool.java:974) > > at > org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedO > bjectPool.java:84) > > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingData > Source.java:96) > > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSour > ce.java:880) > > at > utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256) > > at > utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76) > > at beans.PurgeProcess_T.run(PurgeProcess_T.java:166) > > > > > > > With Regards............ > Sharat Babu Shravanam > > > > -------------------------------------------------------------------- > Byte and Switch Names Solix Technologies > One of the Top 10 Startups to Watch > > Read More at http://www.solix.com/top10startups > --------------------------------------------------------------------- > > > > > > > > **************** CAUTION - Disclaimer ***************** > > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended > solely for the use of the addressee(s). If you are not the intended > recipient, please notify the sender by e-mail and delete the original > message. Further, you are not to copy, disclose, or distribute this > e-mail or its contents to any other person and any such actions are > unlawful. This e-mail may contain viruses. Solix has taken every > reasonable precaution to minimize this risk, but is not liable for any > damage you may sustain as a result of any virus in this e-mail. You > should carry out your own virus checks before opening the e-mail or > attachment. Solix reserves the right to monitor and review the content > of all messages sent to or from this e-mail address. Messages sent to > or > from this e-mail address may be stored on the Solix e-mail system. > > > ****End of Disclaimer ********************************** > > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org