Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

DB2 driver exception

Posted on 2004-04-23
14
334 Views
Last Modified: 2010-03-31
I am getting this exception.

java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver.


I have made sure that the db2jcc.jar is in ClassPath, but I am still getting the exception. ANy help is really appreciated.
0
Comment
Question by:dkathuria
  • 5
  • 4
  • 2
  • +1
14 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 10904624
You'll probably find that nonetheless is is NOT in your classpath. Put the jar in jre/lib/ext directory of your runtime and you won't need to worry about the classpath
0
 
LVL 92

Expert Comment

by:objects
ID: 10904845
what are u running when u get the exception?
If its a container such as tomcat then put your jar in <webapp>/WEB-INF/lib
0
 
LVL 92

Expert Comment

by:objects
ID: 10904848
And make sure yu have specified the correct classname.
Perhaps it should be:

com.ibm.db2.jdbc.net.DB2Driver
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:dkathuria
ID: 10904889
Tried as you said, but still no luck
0
 
LVL 92

Expert Comment

by:objects
ID: 10904940
so what exactly are you running when u get the exception?
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10904959
Are you sure that class is in that jar? List it to find out:

jar tvf db2jcc.jar
0
 

Author Comment

by:dkathuria
ID: 10905225
I could n't find COM.ibm.db2.jdbc.net.DB2Driver in db2jcc.jar. But I thought thats where this driver supposed to be. Any idea in which package this driver foing to be in?

Thanks
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10905242
That's the reason for the error then. Not sure about that db. All i can suggest is looking in all the jars that come with the db or are associated with it
0
 
LVL 92

Accepted Solution

by:
objects earned 38 total points
ID: 10905283
how exactly are you using it?
this may help you:
http://www-306.ibm.com/software/data/pubs/papers/sqlj/
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 37 total points
ID: 10905340
Be careful when you're checking that jar. This Java example (towards the bottom) suggests the driver *is* in that jar:

http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0401chong/index.html
0
 

Expert Comment

by:btobin1
ID: 10907071
Actually the link given by CEHJ says that the driver is NOT in db2jcc.jar, but rather:

The DB2 UDB type 3 driver is stored in file db2java.zip under sqllib\java (the same file as for the type 2 App driver)
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10907098
Depends what driver we're talking about:

>>
The DB2 type 2 Universal driver is stored in file db2jcc.jar under sqllib\java


The DB2 type 4 Universal driver is stored in file db2jcc.jar under sqllib\java (This Universal Driver implements Type 2 and Type 4 drivers). Type 4 only works with the TCP/IP protocol


The DB2 type 2 App driver is stored in file db2java.zip under sqllib\java
>>

To cover all bases, rename db2java.zip (if you have that file) to db2java.jar and place it in the ext directory where i mentioned before
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tomcat administrtor 12 58
Which non-HTML GUI front end to use with Java? 3 24
servlet and mdb, jms error 1 30
Java Eclipse Loop 3 20
INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question