From users-return-17327-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org Thu Dec 18 22:40:54 2008
Return-Path: <users-return-17327-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-users-archive@www.apache.org
Received: (qmail 45228 invoked from network); 18 Dec 2008 22:40:53 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 18 Dec 2008 22:40:53 -0000
Received: (qmail 2242 invoked by uid 500); 18 Dec 2008 22:41:05 -0000
Delivered-To: apmail-activemq-users-archive@activemq.apache.org
Received: (qmail 2214 invoked by uid 500); 18 Dec 2008 22:41:05 -0000
Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@activemq.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@activemq.apache.org>
List-Post: <mailto:users@activemq.apache.org>
List-Id: <users.activemq.apache.org>
Reply-To: users@activemq.apache.org
Delivered-To: mailing list users@activemq.apache.org
Received: (qmail 2203 invoked by uid 99); 18 Dec 2008 22:41:05 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Dec 2008 14:41:05 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of bruce.snyder@gmail.com designates 209.85.198.250 as permitted sender)
Received: from [209.85.198.250] (HELO rv-out-0708.google.com) (209.85.198.250)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Dec 2008 22:40:43 +0000
Received: by rv-out-0708.google.com with SMTP id f25so584813rvb.26
        for <users@activemq.apache.org>; Thu, 18 Dec 2008 14:40:22 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:in-reply-to:mime-version:content-type
         :content-transfer-encoding:content-disposition:references;
        bh=qsgqtNgAV/lqEfuS8mgsIBKEueFCklTiq7Q1m15RXwQ=;
        b=vyhRcQzSu7KzGqnQR5GKWolHICvw8Lz3ieh0NQTcyxK9qwan4GGS6kZgRZiN9MLnkP
         F9EyXG1q8UXqDrFxwPzyF1X1xsro0rnKo0gIrWO9+JCXQhTeOS8+ODDYav0c3bzK5lps
         eZKDtPVLmO7eV4X1nl7UzMYY1pT2x3TLwkcpQ=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=N4I2g6bdrnEDpE3BeZTPXU9yIZx9H+8q8S0eYspL1fsp0bgeX1/szF6TpqqN0zgovN
         p5K0ty6sN0lnYJyeeflHXPH3BQC1eeSLfOmdOLlP80vB2GWtye1CY612tjwXc2qVw0va
         FzG794yQHCuCVJ4UdRyppUP4qSalkgfnTSctE=
Received: by 10.141.209.6 with SMTP id l6mr661524rvq.2.1229640022688;
        Thu, 18 Dec 2008 14:40:22 -0800 (PST)
Received: by 10.141.161.12 with HTTP; Thu, 18 Dec 2008 14:40:22 -0800 (PST)
Message-ID: <7b3355cb0812181440o55dc2af3hbe2a31ddb37e9022@mail.gmail.com>
Date: Thu, 18 Dec 2008 15:40:22 -0700
From: "Bruce Snyder" <bruce.snyder@gmail.com>
To: users@activemq.apache.org
Subject: Re: testonborrow for DBCP
In-Reply-To: <d9cab5bb0812181130i5812e0e9vb8639b59c107123@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <d9cab5bb0812181130i5812e0e9vb8639b59c107123@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

On Thu, Dec 18, 2008 at 12:30 PM, AD <straightflush@gmail.com> wrote:
> Hello,
>  Is there a way to enable teh "testonborrow" feature with a mysql datasource
> in a standlone ActiveMQ 5.1 deployment?  We are seeing the "mysql
> Communication failure" error and would like to enable this feature to
> prevent this.

IIRC, I think that's just a property on the DBCP datasource that wraps
the MySQL datasource, correct? E.g.:

<bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
  <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  <property name="url"
value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true" />
  <property name="username" value="activemq" />
  <property name="password" value="activemq" />
  <property name="maxActive" value="200" />
  <property name="poolPreparedStatements" value="true" />
  <property name="testOnBorrow" value="true" />
</bean>

Bruce
-- 
perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'

Apache ActiveMQ - http://activemq.org/
Apache Camel - http://activemq.org/camel/
Apache ServiceMix - http://servicemix.org/

Blog: http://bruceblog.org/