Return-Path: Delivered-To: apmail-ws-axis-user-archive@ws.apache.org Received: (qmail 69373 invoked by uid 500); 9 May 2003 19:33:11 -0000 Mailing-List: contact axis-user-help@ws.apache.org; run by ezmlm Precedence: bulk Reply-To: axis-user@ws.apache.org list-help: list-unsubscribe: list-post: Delivered-To: mailing list axis-user@ws.apache.org Received: (qmail 69264 invoked from network); 9 May 2003 19:33:10 -0000 Subject: Re: JDBC, DB2 and AXIS To: axis-user@ws.apache.org X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: ian_d_stewart@bankone.com Date: Fri, 9 May 2003 15:22:25 -0400 X-MIMETrack: Serialize by Router on CMHSMTP11/SMTP/SVR/ONE(Release 5.0.8 |June 18, 2001) at 05/09/2003 03:30:13 PM MIME-Version: 1.0 Content-type: text/plain; charset="us-ascii" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N I was able to get this working by copying db2java.zip over to $CATALINA_HOME/webapps/axis/WEB-INF/lib and renaming it to db2java.jar (apparently Tomcat only loads .jar files). Ian Ian D. Stewart Open Systems Engineer II Enterprise Midrange - Bank One Infrastructure & Operations ian_d_stewart@bankone.com (614) 213-6100 ian_d_stewart@bankone.com on 05/09/2003 01:41:25 PM Please respond to axis-user@ws.apache.org To: axis-user@ws.apache.org cc: Subject: JDBC, DB2 and AXIS Dear List, I'm running into difficulty connecting to a DB2 database via JDBC in AXIS. I'm hoping someone else has already run across this and developed a fix/work-around. If it maters, operating system is RedHat Advanced Server 2.1, database is IBM DB2 Universal Database Enterprise Edition version 7.2.5 for Linux, AXIS is version 1.0 and Servlet container is Tomcat 4.1. >From the command line, I am able to connect, both by the Command Line Processor and JDBC. The only requirement being that I need to source the db2profile first. I have the following code within the init() method of my Handler, but it consistently dies with IllegalArgumentException: unknown driver: COM.ibm.db2.jdbc.app.DB2Driver: String driver = (String)getOption("driver"); try { // register the driver with java.sql.DriverManager System.out.println("registering JDBC driver " + driver); Class.forName(driver); } catch (ClassNotFoundException cnfe) { throw new IllegalArgumentException("unknown driver: " + driver); } I have tried sourcing db2profile in /etc/tomcat4/tomcat4.conf (and have confirmed that the file is being sourced) but that doesn't seem to make any difference. Any insight would be greatly appreciated. Thanx, Ian Ian D. Stewart Open Systems Engineer II Enterprise Midrange - Bank One Infrastructure & Operations ian_d_stewart@bankone.com (614) 213-6100 This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.