commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phil Steitz <p...@steitz.com>
Subject Re: DBCP Returning Closed Connections
Date Wed, 17 Sep 2008 23:19:21 GMT
Khawaja Shams wrote:
>   Thanks Wes for the suggestion.  Should I file a bug for testOnBorrow not
> testing the connections properly?
>   
Yes, if you have testOnBorrow set to true and you are getting 
connections back that are closed, that is a bug.
>
>
> On Wed, Sep 17, 2008 at 1:11 PM, Wes Clark <wclark@guidewire.com> wrote:
>
>   
>> We've had the same problem on SQL Server. Set the "testWhileIdle" to
>> test a few connections every so often.  It will keep the connections
>> alive.
>>
>> -----Original Message-----
>> From: Khawaja Shams [mailto:ksshams@gmail.com]
>> Sent: Wednesday, September 17, 2008 12:40 PM
>> To: user@commons.apache.org
>> Subject: DBCP Returning Closed Connections
>>
>> Hello,   One of our servers goes through periods of activity followed by
>> long idle durations.  It appears as though after the server sits idle
>> for a few hours, subsequent requests to the DBCP Pool return connections
>> that have already been closed. This is a bit frustrating as I could not
>> find a way to take that connection out of the pool, and the same
>> instance of the connection keeps getting returned to other requests.
>> The connection is to a MySQL server.  I tried setting the testOnBorrow
>> variable to true (I am using
>> BasicDataSource) before the first time I borrow the connection, but it
>> does not seem to have any impact.  Does anybody have a work around or a
>> hunch as to what I may be doing wrong? Thanks.
>>
>>
>> Regards,
>> Khawaja Shams
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
>> For additional commands, e-mail: user-help@commons.apache.org
>>
>>
>>     
>
>   


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


Mime
View raw message