Return-Path: 
 <struts-user-return-68662-qmlist-jakarta-archive-struts-user=nagoya.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-struts-user-archive@apache.org
Received: (qmail 35157 invoked from network); 12 Mar 2003 16:00:09 -0000
Received: from exchange.sun.com (192.18.33.10)
  by daedalus.apache.org with SMTP; 12 Mar 2003 16:00:09 -0000
Received: (qmail 18438 invoked by uid 97); 12 Mar 2003 16:01:52 -0000
Delivered-To: qmlist-jakarta-archive-struts-user@nagoya.betaversion.org
Received: (qmail 18431 invoked from network); 12 Mar 2003 16:01:51 -0000
Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12)
  by nagoya.betaversion.org with SMTP; 12 Mar 2003 16:01:51 -0000
Received: (qmail 33100 invoked by uid 500); 12 Mar 2003 15:59:39 -0000
Mailing-List: contact struts-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:struts-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:struts-user-subscribe@jakarta.apache.org>
List-Help: <mailto:struts-user-help@jakarta.apache.org>
List-Post: <mailto:struts-user@jakarta.apache.org>
List-Id: "Struts Users Mailing List" <struts-user.jakarta.apache.org>
Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
Delivered-To: mailing list struts-user@jakarta.apache.org
Received: (qmail 33086 invoked from network); 12 Mar 2003 15:59:38 -0000
Received: from mail.uniway.be (HELO uw1.uniway.be) (195.72.91.237)
  by daedalus.apache.org with SMTP; 12 Mar 2003 15:59:38 -0000
Received: from uniway.be ([127.0.0.1]) by uw1.uniway.be
          (Netscape Messaging Server 4.15) with ESMTP id HBN8FB00.018 for
          <struts-user@jakarta.apache.org>; Wed, 12 Mar 2003 16:59:35 +0100
Message-ID: <3E6F5967.6030407@uniway.be>
Date: Wed, 12 Mar 2003 16:59:35 +0100
From: "Philippe Van Der Gucht" <philippe.vandergucht@uniway.be>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.0.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Struts Users Mailing List <struts-user@jakarta.apache.org>
Subject: Re: Using dbpc package in struts 1.0
References: <BE716DD3-5475-11D7-B9B3-003065CAA7E8@officinedigitali.it>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Thank you so much, it works beautifully. :-)

(we needed dbpc for the connection failover capability)

Mark Lowe wrote:
> It use the BasicDataSource rather than the older deprecated struts 
> GenericDataSource its more a case of the xml sytaax changing the config.xml
> 
> 
>     <data-source type="org.apache.commons.dbcp.BasicDataSource" 
> key="strutsConnection">
>             <set-property property="defaultAutoCommit" value="false"/>
>             <set-property property="driverClassName" 
> value="com.mysql.jdbc.Driver"/>
>             <set-property property="url" value="jdbc:mysql://etc"/>
>             <set-property property="maxActive" value="4"/>
>             <set-property property="username" value="arse"/>
>             <set-property property="password" value="bandit"/>
>             <set-property property="maxWait" value="5000"/>
>     </data-source>
> 
> To do this in java rather than the ds being addedas on object in the 
> action servlet context .. This example does the same as the xml
> 
> BasicDataSource dataSource = new BasicDataSource();
>     
> dataSource.setDefaultAutoCommit(false);
> dataSource.setUsername("arse");
> dataSource.setPassword("bandit");
> dataSource.setDriverClassName ("com.mysql.jdbc.Driver");
> dataSource.setUrl("jdbc:mysql://etc");
> dataSource.setMaxActive(2);
> 
>                
> context.setAttribute("myNewDataSource",dataSource);
> 
> 
> hope this helps mark
> 
> 
> Mercoled�, 12 mar 2003, alle 11:23 Europe/Rome, Gemes Tibor ha scritto:
> 
>> Philippe Van Der Gucht wrote:
>>
>>> Hello,
>>>
>>> I would like to use the dbpc package 
>>> (http://jakarta.apache.org/commons/dbcp/index.html) in our struts 1.0 
>>> application.
>>>
>>> Has somebody here already done this?
>>> If so, what are the issues involved?



-- 
Tel: +32-27179265


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