Re: Using dbpc package in struts 1.0

[Philippe Van Der Gucht]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]