I never had too much success with the net driver. But I think your problem is with the class name. The name of the class is COM.ibm.db2.jdbc.net.DB2Driver. Note the COM in all caps.
-- Darian Shimy > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 1:38 AM > To: Tomcat Users List > Subject: Re: Cannot load JDBC Driver class > com.ibm.db2.jdbc.app.DB2Driver > > > > try using the com.ibm.db2.jdbc.net.DB2Driver . (instead of the > ...app.DB2Driver.) > it's a thin client that doesn't require finding libraries locally... > url would be something like: > jdbc:db2//localhost/db_name > > or if you use a non-standard port and use an ip address instead of a > hostname: > jdbc:db2//192.168.1.123:9993/db_name > > /gilad > > > > Gilad Buzi > R&D Engineer * CONCATEL > > > [EMAIL PROTECTED] > c/Sardenya, 229-237 Atic. 2a * > 08013 Barcelona Spain > tel. +34.93.244.88.77 * fax > +34.93.244.88.78 > > www.concatel.com > > > > > > > > > Stephen > > Peterson Para: > [EMAIL PROTECTED] > > <[EMAIL PROTECTED] cc: > > oo.com> Asunto: Cannot > load JDBC Driver class com.ibm.db2.jdbc.app.DB2Driver > > > 02/04/2003 > > 12:28 > > Por favor, > > responda a > > "Tomcat Users > > List" > > > > > > > > > Hello, > > I'm getting this java.sql.SQLException when trying to open a > connection > on my datasource. The WebSphere Test Environment datasource > opens connections fine, > but not Tomcat/4.1.24. Other details, using DB2 Personal > Edition version 7.2, > on Windows 2000 Professional. > > I copied C:\sqllib\db2java.zip to $CATALINA_HOME/common/lib > directory, renaming > to db2java.jar. > > I verified that the com.ibm.db2.jdbc.app.DB2Driver class was > actually in the jar file. > > In the server.xml listing below I added parms for username > and password since I always see them in other postings, although > I have always spcified the username/password in the > getConnection > method call, successfully in websphere. > ============== > server.xml: > > <DefaultContext> > <Resource name="jdbc/GuppyDB" auth="Container" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/GuppyDB"> > <parameter> > <name>factory</name> > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>COM.ibm.db2.jdbc.app.DB2Driver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:db2:gupt1b</value> > </parameter> > <parameter> > <name>password</name> > <value>password</value> > </parameter> > <parameter> > <name>username</name> > <value>user1</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>8</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>4</value> > </parameter> > </ResourceParams> > </DefaultContext> > ================ > in web.xml: > <resource-ref> > <description> > Resource reference to a factory for java.sql.Connection > instances that may be used for talking to a particular > database that is configured in the server.xml file. > </description> > <res-ref-name> > jdbc/GuppyDB > </res-ref-name> > <res-type> > javax.sql.DataSource > </res-type> > <res-auth> > Container > </res-auth> > </resource-ref> > =================== > in my servlet: > > import java.sql.Connection; > import javax.naming.Context; > import javax.naming.InitialContext; > import javax.sql.DataSource; > > Context initCtx = new InitialContext(); > Context envCtx = (Context) initCtx.lookup("java:comp/env"); > DataSource ds = (DataSource) envCtx.lookup("jdbc/GuppyDB"); > Connection conn = ds.getConnection("user1", "passwd"); > conn.close(); > > The following is thrown in the ds.getConnection method: > > java.sql.SQLException: Cannot load JDBC driver class > 'com.ibm.db2.jdbc.app.DB2Driver' > > Now I did see Fabio Mengue's posting from Feb 20 in a response > to someone asking a similar question. I compared his config > with mine, added at the top of <TOMCAT>/bin/setclasspath.sh > the line > set JAVA_OPTS="-Djava.library.path=C:/Program > Files/sqllib/java/" > > and started tomcat with the startup.sh instead of the services > start in the Computer Management dialog. > > The other item: > ---------------- > Add the following line > Create <TOMCAT>/bin/setenv.sh, as a copy (or a link) of file > <DB2>/sqllib/db2profile. > ---------------- > I am at a loss, since I cannot find a db2profile file on my PC, > although I do have the DB2 server software installed as well as > the > DB2 client software. > > If anyone has any helpful suggestions that would be welcome. > > Thanks > Stephen Peterson > > __________________________________________________ > Do you Yahoo!? > Yahoo! Tax Center - File online, calculators, forms, and more > http://tax.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
