Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Commons Users List" <user@commons.apache.org>
Received-SPF: pass (nike.apache.org: domain of phil.steitz@gmail.com
 designates 209.85.210.171 as permitted sender)
Message-ID: <4ECC0C3A.9090605@gmail.com>
Date: Tue, 22 Nov 2011 13:55:22 -0700
From: Phil Steitz <phil.steitz@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
 rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
To: Commons Users List <user@commons.apache.org>
Subject: Re: [dbcp] Connections not validated even with validation query and
 test on borrow
References: <F7772A98565E4111B34A53495915B2E8@neilhp>
In-Reply-To: <F7772A98565E4111B34A53495915B2E8@neilhp>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On 11/22/11 1:45 PM, Neil Aggarwal wrote:
> Hello:
>
> I have the following code in my app to get a connection
> pool to a MySQL database:
>
>     String dbUri = "jdbc:mysql://localhost:3306/mydb";
>     ConnectionFactory connectionFactory = new
> DriverManagerConnectionFactory(dbUri,user,password);
>     GenericObjectPool connectionPool = new GenericObjectPool(null);
>     connectionPool.setMinEvictableIdleTimeMillis(5*60*1000);
>     connectionPool.setTimeBetweenEvictionRunsMillis(15*60*1000);
>     new
> PoolableConnectionFactory(connectionFactory,connectionPool,null,"select
> 1",false,true);
>  
> ((org.apache.commons.pool.impl.GenericObjectPool)connectionPool).setTestOnBo
> rrow(true);
>     return new PoolingDataSource(connectionPool);
>
> I have a long running cron job that is giving me this error:
>
> The last packet sent successfully to the server was 41,120,156 milliseconds
> ago. 
> is longer than the server configured value of 'wait_timeout'. You should
> consider 
> either expiring and/or testing connection validity before use in your
> application, 
> increasing the server configured values for client timeouts, or using the C
> onnector/J connection property 'autoReconnect=true' to avoid this problem.
>
> So, it looks like the connection validation is not happening.
>
> Did I do something wrong in my code?

The validation happens when the connection is borrowed from the
pool, i.e., when your code requests a connection from the
DataSource.  If you code is holding onto the checked out connection
for longer than the timeout, it will not be re-validated by DBCP. 
Is it possible that that is your problem?

Phil

>
> Thanks,
>   Neil
>
> --
> Neil Aggarwal, (972)834-1565, http://UnmeteredVPS.net/centos
> Virtual private server with CentOS 6 preinstalled
> Unmetered bandwidth = no overage charges
>
>
> ---------------------------------------------------------------------
> 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