commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno Melloni <>
Subject RE: "Connection reset" exceptions
Date Mon, 05 Apr 2010 20:19:13 GMT
Yup!  "Select 1"

And the exception only happens every once in a while, not constantly.

-----Original Message-----
From: [] On Behalf Of James
Sent: Monday, April 05, 2010 3:17 PM
To: Commons Users List
Cc: Bruno Melloni
Subject: Re: "Connection reset" exceptions

you've tried supplying a validation query?

On Mon, Apr 5, 2010 at 4:13 PM, Bruno Melloni
<> wrote:
> I started getting these on a long-running command-line application, with Spring, SQL
Server and DBCP for the DataSource.   What I found by googling seems to point towards:
> a)      The database times out on idle connections and resets them.  Then DBCP does
not know how to handle it and fails.
> b)      A network failure causes a failure that triggers the error.
> The only solutions I found suggest that there is a bug in DBCP and that I should switch
to the c3p0 DataSource/connection pool.  But I suspect that there must be a way (perhaps
through config settings) to make DBCP not have these issues.  I would welcome any help that
I can get.
> Thank you.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message