All,

I'm trying to configure our application to run on Tomcat on an iSeries.
(Previously we've been running on a wintel box)

I'm having problems with the connection pool configuration in the
server.xml:

          <Resource name="jdbc/myDataSource" scope="Shareable"
type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/myDataSource">
            <parameter>
              <name>password</name>
              <value>thepassword</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:as400://nsbas1;driver=native;naming=system;date
format=iso;date separator=-;libraries=<a really long library list>;</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>com.ibm.as400.access.AS400JDBCDriver</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>theuser</value>
            </parameter>
          </ResourceParams>

If I take out the driver=native property, i.e. to use the toolbox driver,
the app works. But if I include it to use the native driver, then it looks
as if all the remaining properties, such as naming and libraries are
ignored, and the application falls over in a big heap. Is there anything
special I need to do to use the native driver? Nothing interesting appears
in the QSQSRVR jobs' joblog.

Any help would be appreciated.

Chris.


=======DISCLAIMER=======
This email transmission and any attachments may contain confidential
information which is legally privileged.  You are also notified that the
contents of this email and any which you may send in reply, may be viewed by
authorised personnel on behalf of NSB Retail Systems Plc or its subsidiaries
(the Company) in accordance with the Company's Information Access Policy.
The content of this email is always subject to contract.  The information is
intended only for the individual or entities to whom it is addressed.  If
you are not an intended recipient please contact me immediately and you are
hereby notified that any disclosure, copying, distribution, storage on any
medium or use of the information contained in this transmission is strictly
prohibited.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.