Chris, Ive had problems before because the native and the toolbox drivers specify some different properties. Look at the documentation on the ibm site to get the properties cheers Colin.W Extension 5800 Direct dial 0870 429 5800 -----Original Message----- From: Price, Chris [mailto:chris_price@xxxxxxxxx] Sent: 22 September 2004 16:29 To: java400-l@xxxxxxxxxxxx Subject: Tomcat on iSeries & Connection Pooling 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. -- 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/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 e-mail has been sent by a company of Bertram Group Ltd, whose registered office is 1 Broadland Business Park, Norwich, NR7 0WF. This message, and any attachments, are intended solely for the addressee and may contain privileged or confidential information. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender immediately. Opinions, conclusions and statements of intent in this e-mail are those of the sender and will not bind a Bertram Group Ltd company unless confirmed in writing by a director independently of this message. Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.