commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lorenzo Jiménez <ljime...@nacion.co.cr>
Subject RE: DBCP Connection Pool Problem
Date Wed, 17 Jan 2007 14:50:48 GMT
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: sailormo@seed.net.tw [mailto:sailormo@seed.net.tw] 
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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


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 infosegura@nacion.com.
 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
infosegura@nacion.com.  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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message