You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by Paul Hsu <hs...@verizon.net> on 2005/01/27 18:04:32 UTC

connection boorow time out

Hi,

I just wonder that DBCP can monitor a connection pool to check if a connection is borrowed too long by a client periodically, if so then pool will mandatory move the connection from active to idle. This can void whoever borrow the connection and never return to pool. So we need to parameters can be set, one is the how often pool will monitor and other is how long a connection can be borrowed out.


Thanks,

Paul

Re: [DBCP] connection boorow time out

Posted by Dirk Verbeeck <di...@pandora.be>.
You can still use removeAbandoned. It isn't recommended but it your 
application misbehaves then it can be usefull to enable it.

For a more complete answer see Q4 on
http://wiki.apache.org/jakarta-commons/DBCP

Cheers
Dirk

Paul Hsu wrote:

> Dirk,
> 
> Thank you. But I think the feature is deprecated? Can I still use it?
> 
> Thanks,
> 
> Paul



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org

Re: [DBCP] connection boorow time out

Posted by Paul Hsu <hs...@verizon.net>.
Dirk,

Thank you. But I think the feature is deprecated? Can I still use it?

Thanks,

Paul

----- Original Message ----- 
From: "Dirk Verbeeck" <di...@pandora.be>
To: "Jakarta Commons Developers List" <co...@jakarta.apache.org>
Sent: Thursday, January 27, 2005 10:46 AM
Subject: Re: [DBCP] connection boorow time out


> You are looking for the "removeAbandoned" feature.
> DBCP doesn't check periodically but only when the pool is almost empty. 
> More information on the configuration page:
> http://jakarta.apache.org/commons/dbcp/configuration.html
>
> -- Dirk
>
> Paul Hsu wrote:
>
>> Hi,
>>
>> I just wonder that DBCP can monitor a connection pool to check if a 
>> connection is borrowed too long by a client periodically, if so then pool 
>> will mandatory move the connection from active to idle. This can void 
>> whoever borrow the connection and never return to pool. So we need to 
>> parameters can be set, one is the how often pool will monitor and other 
>> is how long a connection can be borrowed out.
>>
>>
>> Thanks,
>>
>> Paul
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-dev-help@jakarta.apache.org
>
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org

Re: [DBCP] connection boorow time out

Posted by Dirk Verbeeck <di...@pandora.be>.
You are looking for the "removeAbandoned" feature.
DBCP doesn't check periodically but only when the pool is almost 
empty. More information on the configuration page:
http://jakarta.apache.org/commons/dbcp/configuration.html

-- Dirk

Paul Hsu wrote:

> Hi,
> 
> I just wonder that DBCP can monitor a connection pool to check if a connection is borrowed too long by a client periodically, if so then pool will mandatory move the connection from active to idle. This can void whoever borrow the connection and never return to pool. So we need to parameters can be set, one is the how often pool will monitor and other is how long a connection can be borrowed out.
> 
> 
> Thanks,
> 
> Paul



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org