Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Commons Users List" <user@commons.apache.org>
Subject: Re: [dbcp] auto reconnecting
To: Commons Users List <user@commons.apache.org>
References: 
 <AT5PR84MB0146985CAC652590357CAE49EC360@AT5PR84MB0146.NAMPRD84.PROD.OUTLOOK.COM>
From: Phil Steitz <phil.steitz@gmail.com>
Message-ID: <56159B3B.9050903@gmail.com>
Date: Wed, 7 Oct 2015 15:22:51 -0700
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0)
 Gecko/20100101 Thunderbird/38.3.0
MIME-Version: 1.0
In-Reply-To: 
 <AT5PR84MB0146985CAC652590357CAE49EC360@AT5PR84MB0146.NAMPRD84.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

On 10/7/15 12:35 PM, Pruitt, Byron S wrote:
> My server has long standing idle periods.  We are seeing:  com.mysql.jd=
bc.exceptions.jdbc4.CommunicationsException: The last packet successfully=
 received from the server was...  errors.
>
> I would like to fix it as simply as possible.  MySQL has two properties=
 autoReconnect and autoReconnectForPools that might fix the problem.  The=
y both default to false and I can't find an easy way to set them.
> I had an earlier problem with auto commit and I fixed it with the setDe=
faultAutoCommit method on PoolableConnectionFactory.  But, it doesn't hav=
e a similar setter for auto reconnect.
>
> The only example I found of setting the autoReconnect property is on th=
e connection url.  I use the interface where I pass an instance of Proper=
ties, so I assume I can set those properties with it.
>
> I am curious if there are better ways to set those properties.

If you are using BasicDataSource, you can use it's
addConnectionProperty method to add driver-specific connection
properties such as this.  Just make sure to add the property before
you use the datasource.

You can achieve the same effect by enabling validation on borrow or
while idle (testOnBorrow, testWhileIdle).

Phil
>
> Thanks.
>
> -SP
>
> ---------------------------------------------------------------------
> 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