Return-Path: 
 <user-return-23150-apmail-commons-user-archive=commons.apache.org@commons.apache.org>
Delivered-To: apmail-commons-user-archive@www.apache.org
Received: (qmail 86293 invoked from network); 22 Jun 2009 20:26:09 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 22 Jun 2009 20:26:09 -0000
Received: (qmail 14976 invoked by uid 500); 22 Jun 2009 20:26:19 -0000
Delivered-To: apmail-commons-user-archive@commons.apache.org
Received: (qmail 14897 invoked by uid 500); 22 Jun 2009 20:26:18 -0000
Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@commons.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@commons.apache.org>
List-Post: <mailto:user@commons.apache.org>
List-Id: <user.commons.apache.org>
Reply-To: "Commons Users List" <user@commons.apache.org>
Delivered-To: mailing list user@commons.apache.org
Received: (qmail 14887 invoked by uid 99); 22 Jun 2009 20:26:18 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Jun 2009 20:26:18 +0000
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [193.252.22.190] (HELO smtp6.freeserve.com) (193.252.22.190)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Jun 2009 20:26:09 +0000
Received: from me-wanadoo.net (localhost [127.0.0.1])
	by mwinf3633.me.freeserve.com (SMTP Server) with ESMTP id E64F87000085
	for <user@commons.apache.org>; Mon, 22 Jun 2009 22:25:46 +0200 (CEST)
Received: from smtp.homeinbox.net (unknown [91.109.141.126])
	by mwinf3633.me.freeserve.com (SMTP Server) with ESMTP id C9C167000082
	for <user@commons.apache.org>; Mon, 22 Jun 2009 22:25:46 +0200 (CEST)
X-ME-UUID: 20090622202546826.C9C167000082@mwinf3633.me.freeserve.com
Received: from localhost (localhost [127.0.0.1])
	by smtp.homeinbox.net (Postfix) with ESMTP id 3B61B1A4DF6
	for <user@commons.apache.org>; Mon, 22 Jun 2009 21:25:36 +0100 (BST)
X-Virus-Scanned: Debian amavisd-new at homeinbox.net
Received: from smtp.homeinbox.net ([127.0.0.1])
	by localhost (server01.dev.local [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id CnKMGGzb5ytd for <user@commons.apache.org>;
	Mon, 22 Jun 2009 21:25:32 +0100 (BST)
Received: from [192.168.0.9] (study03.dev.local [192.168.0.9])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by smtp.homeinbox.net (Postfix) with ESMTPSA id 90E791A47FB
	for <user@commons.apache.org>; Mon, 22 Jun 2009 21:25:32 +0100 (BST)
Message-ID: <4A3FE8BC.7020604@apache.org>
Date: Mon, 22 Jun 2009 21:25:32 +0100
From: Mark Thomas <markt@apache.org>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: Commons Users List <user@commons.apache.org>
Subject: Re: apache dbcp + mysql reconnect problem
References: <4A3FE7B4.7080602@gmail.com>
In-Reply-To: <4A3FE7B4.7080602@gmail.com>
X-Enigmail-Version: 0.95.7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Jason Novotny wrote:
> 
> Hi,
> 
>    My application connects to the database maybe once a day.

Which begs the question is there really any need to use DBCP?

> The first
> time after I startup my app everything works fine, however the next day
> when it tries to connect to the MySql database I get an exception posted
> at the end.
> 
> I'm using spring 2.6+hibernate 3.4+apache dbcp+ MySql 5.0.44...  the
> dbcp configuration in Spring looks like:
> 
> <bean id="dataSource" destroy-method="close"
> class="org.apache.commons.dbcp.BasicDataSource">
>        <property name="driverClassName" value="${jdbc.driverClassName}"/>
>        <property name="url" value="${jdbc.url}"/>
>        <property name="username" value="${jdbc.username}"/>
>        <property name="password" value="${jdbc.password}"/>
>        <property name="maxActive" value="15"/>
>        <property name="maxIdle" value="5"/>
>        <property name="maxWait" value="120000"/>
>    </bean>
> 
> Wondering is someone has any idea how to solve this problem...

I suspect a validation query on configured to run on borrow would solve
this.

Mark



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