Yea, that trick worked with windows. I guess with linux it wont.
I just unzipped the db2java.zip and then created a jar
file , and tried again but the call
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
gets an exception
(even though when I built the jar file, It had the file
DB2Driver.class in directory COM/ibm/db2/jdbc/app/
I wonder of it is a uppercase/lower case problem.
----- Original Message -----
From: Steven Peterson <[EMAIL PROTECTED]>
Date: Thursday, January 22, 2004 11:19 am
Subject: Re: [Juglist] Tomcat and DB2: No suitable driver
> In the following line, are you confusing the zip file with a jar
> file? i.e. does the zip file need to be unzipped?
>
>
>
> >cp -p /opt/IBM/db2/V8.1/java/db2java.zip
> $CATALINA_HOME/common/lib/db2java.jar
>
> --
> Steven Peterson, President
> Frontier Productions, Inc.
> 310 Wesley Drive
> Chapel Hill, NC 27516
> Tel: 919-942-1386
> Fax: 919-933-2677
>
> Creators of List Pilot
> Easier email broadcasting from your customer database.
> http://www.listpilot.net
>
>
>
> [EMAIL PROTECTED] wrote:
>
> >I am using Tomcat 5.0.16 and can't get jdbc working with DB2 8.1
> on Linux
> >Red Hat 9.
> >
> >The exact error I get is java.sql.SQLException: No sitable driver
> >
> >I have tried the following jdbc calls combinations:
> >
> >Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); // Type2
> >String url = "jdbc:db2:test"; // Type2
> >
> >Class.forName("com.ibm.db2.jcc.DB2Driver"); // Type4
> >String url = " jdbc:db2://localhost:50000/test"; // Type4
> >
> >
> >conn= DriverManager.getConnection(url, "test", "test");
> >
> >I have tried copying the db2java.zip as follows:
> >cp -p /opt/IBM/db2/V8.1/java/db2java.zip
> $CATALINA_HOME/common/lib/db2java.jar>
> >As well, I have copied it to Put db2java.jar in :
> %CATALINA_HOME%/lib/ , /server/lib/, /common/lib/, ../web-inf/lib
> >
> >Any suggestions...
> >
> >No problems when I used tomcat/db2 on a windows2k machine.
> >
> >I wonder if I should go back to an earlier Tomcat or DB2?
> >
> >
> >
> >
> >
> >
> >
> >_______________________________________________
> >Juglist mailing list
> >[EMAIL PROTECTED]
> >http://trijug.org/mailman/listinfo/juglist_trijug.org
> >
> >
> >
>
>
>
>
> _______________________________________________
> Juglist mailing list
> [EMAIL PROTECTED]
> http://trijug.org/mailman/listinfo/juglist_trijug.org
>
_______________________________________________
Juglist mailing list
[EMAIL PROTECTED]
http://trijug.org/mailman/listinfo/juglist_trijug.org
