Re: Struts 1.0.2 JDBC Connection Pool

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

> I want to avoid using hard coded library references...

        http://www.jguru.com/faq/view.jsp?EID=284877


                                                        Joe Sam

Joe Sam Shirah
conceptGo         -         Consulting/Development/Outsourcing
Java Filter Forum at:   http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Qué Java400?             http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Gibson.Stephen" <Gibson.Stephen@burlington.com>
To: <JAVA400-L@midrange.com>
Sent: Wednesday, December 11, 2002 10:35 AM
Subject: Struts 1.0.2 JDBC Connection Pool


> Greetings,
>
> I am attempting to use the Struts 1.0.2 JDBC connection pool using the
> native DB2 drivers for the AS400.  I have configured the struts-config.xml
> file as such
>
> <!-- ========================= Data Sources =============================
> -->
>
>   <data-sources>
>     <data-source>
>       <set-property property="autoCommit"
>                        value="true"/>
>       <set-property property="description"
>                        value="DB2 Datasource"/>
>       <set-property property="driverClass"
>                        value="com.ibm.db2.jdbc.app.DB2Driver"/>
>       <set-property property="maxCount"
>                        value="10"/>
>       <set-property property="minCount"
>                        value="2"/>
>       <set-property property="password"
>                        value="xxxxxxxxxx"/>
>       <set-property property="url"
>                        value="jdbc:db2:*local"/>
>       <set-property property="user"
>                        value="xxxxxxxxxx"/>
>     </data-source>
>   </data-sources>
>
> The application(s) works fine as long as all the necessary tables (files)
> are in the first library in the user profile library list.  It will not
look
> at any libraries in the initial library list however and cannot locate any
> tables in any other library in the library list for the user specified.  I
> want to avoid using hard coded library references in when defining my
> prepared statements.  Has anyone ran into this or have any sugestions?
>
> Addition information: I am using Webshpere 3.5.3 running on iSeries OS 5.2
>
> Stephen Gibson
>
> Lees Carpets - IT Department
> A Division of Burlington Industries
> 3330 West Friendly Avenue
> Greensboro, NC 27410
>
> Phone 336.379.2728
> gibson.stephen@burlington.com
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>