RE: Struts or DBCP Pooling and Toolbox -- JAVA400-L

Thanks for the response to my stupid question.  I had a lighting strike that
told me DBCP could possibly stand for Database Connection Pool big dummy.

Anyway, I have implemented your example and I am rocking and rolling,

Thanks

-----Original Message-----
From: Mark Phippard [mailto:MarkP@xxxxxxxxxxxxxxx]
Sent: Thursday, May 01, 2003 2:39 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: Struts or DBCP Pooling and Toolbox


That is the definition of the connection pool.  Struts does this in its 
XML config file.  The Struts code then uses DBCP to do the pooling and I 
just use the normal Struts code to "get" a connection from the datasource 
and return it.

Mark






"Gibson.Stephen" <Gibson.Stephen@xxxxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
05/01/2003 02:21 PM
Please respond to Java Programming on and around the iSeries / AS400 
 
        To:     "'Java Programming on and around the iSeries / AS400'" 
<java400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Struts or DBCP Pooling and Toolbox


Is this a single data connection or a connection pool.  It this is not a
connection pool, do you have a connection pool example?

-----Original Message-----
From: Mark Phippard [mailto:MarkP@xxxxxxxxxxxxxxx]
Sent: Thursday, May 01, 2003 9:18 AM
To: Java Programming on and around the iSeries / AS400
Subject: RE: Struts or DBCP Pooling and Toolbox


This works for me with Struts 1.1, which is using DBCP:

<data-source key="MyDS" 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://MYAS400;translate 

binary=true;"/>
        <set-property property="username" value="DBUSER"/>
        <set-property property="password" value="DBPWD"/>
        <set-property property="maxActive" value="10" />
        <set-property property="maxIdle" value="5"/>
        <set-property property="maxWait" value="10000" /> 
        <set-property property="defaultAutoCommit" value="true" />
        <set-property property="defaultReadOnly" value="true" />
</data-source>

When running native on the iSeries, I just change the driverClassName and 
url to the values for the native JDBC driver.

Mark







"Gibson.Stephen" <Gibson.Stephen@xxxxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
05/01/2003 07:07 AM
Please respond to Java Programming on and around the iSeries / AS400 
 
        To:     "'Java Programming on and around the iSeries / AS400'" 
<java400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Struts or DBCP Pooling and Toolbox


David,

I am using the Struts Data source connection and I am interested in
switching to DBCP.  I would like if you could share your example on who to
use this. 

Thanks,

Steve Gibson

-----Original Message-----
From: David Morris [mailto:David.Morris@xxxxxxxxxxxxx]
Sent: Tuesday, January 28, 2003 6:57 PM
To: java400-l@xxxxxxxxxxxx
Subject: Re: Struts or DBCP Pooling and Toolbox


Mark,

I do not use a Struts data source, but I do use Struts and DBCP, which
is the 
underlying support that Struts uses. In our case it was helpful to be
able to 
dynamically pick the driver based on the environment -- native or thin.
This 
also facilitated setting the effective user for the thread running the
SQL 
statement when running natively. If you are interested in this option
let me 
know and I will give you an example (which was based on the Struts 
implementation).

David Morris


>>> MarkP@xxxxxxxxxxxxxxx 01/28/03 01:54PM >>>
Anyone care to share a Struts DataSource configuration that works with
the 
Toolbox driver?  Did you use the Toolbox DataSource driver or the DBCP

BasicDataSource and the normal Toolbox JDBC classes.  Any pros/cons?

Thanks
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 

mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.