Re: Struts or DBCP Pooling and Toolbox

["Mark Phippard" <MarkP@xxxxxxxxxxxxxxx>]

I managed to get this working.  Turned out to be a stupid problem.  The 
names of some of the properties you must set in the struts-config.xml 
changed in a subtle way when they moved to DBCP and I didn't notice.  Here 
is what works:

<data-sources>
        <data-source key="MyDataSource" type=
"org.apache.commons.dbcp.BasicDataSource">
                <set-property property="description" value="IBM Toolbox 
for iSeries DataSource"/>
                <set-property property="driverClassName" value=
"com.ibm.as400.access.AS400JDBCDriver"/>
                <set-property property="url" value=
"jdbc:as400://MYSYS;translate binary=true;date format=iso;"/>
                <set-property property="username" value="WEBUSER"/>
                <set-property property="password" value="XXX"/>
                <set-property property="maxActive" value="2" />
                <set-property property="maxIdle" value="1"/>
                <set-property property="maxWait" value="10000" /> 
                <set-property property="defaultAutoCommit" value="true" />
                <set-property property="defaultReadOnly" value="true" />
        </data-source>
</data-sources>

Mark