Maybe DBCP you have to remove the abandoned connections. Try this: <Resource auth="Container" driverClassName="com.sybase.jdbc2.jdbc.SybDriver" initialSize="5" --> logAbandoned="false" maxActive="15" maxIdle="10" maxWait="30000" name="jdbc/xxxx" password="xxxx" --> removeAbandoned="true" --> removeAbandonedTimeout="60" type="javax.sql.DataSource" url="xxxx" username="xxxx"/> </Context>
Hope that helps. Regards, Lorenzo -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 2:39 AM To: commons-user@jakarta.apache.org Subject: DBCP Connection Pool Problem Hello: When I get the current Active Connection Number, it says 800, but actually DBA checked the Database connection, it's only 2x. Why they are inconsistant? Thanks for the answer. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Si usted no es el destinatario indicado en este mensaje o responsable como persona de la entrega del mensaje, no debe copiar o reenviar este mensaje, por favor notifique al correo [EMAIL PROTECTED] Para más referencia sobre términos importantes relacionados a este correo visite http://www.nacion.com/disclaimer/index_es2.htm If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or send this message to anyone, please notify to [EMAIL PROTECTED] Click on the following link for important additional terms relating to this e-mail http://www.nacion.com/disclaimer/index_en2.htm --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]