|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.