db2 and JDBC

saurabhsood · #1 (**permalink**) 03-02-11, 09:31

i am making an application in Java using db2 as backend. I have db2 installed, and using the db2inst1 user, I am able to connect to the database and access the information, but using an existing user, it gives me the ClassNotFoundException. I am using db2 express C 9.7 on ubuntu 10.10.

pls help

thnx...

ARWinner · #2 (**permalink**) 03-02-11, 10:00

What are you trying to execute when you get the exception? What is the full exception you are getting?

Andy

saurabhsood · #3 (**permalink**) 03-02-11, 10:51

am getting this error...

java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver
at java.net.URLClassLoader$1****n(URLClassLoader.java :217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 21)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 66)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at trials.db2query.main(db2query.java:14)
Java Result: 1
BUILD SUCCESSFUL (total time: 0 seconds)

ARWinner · #4 (**permalink**) 03-02-11, 10:54

Your JDBC driver is not in your classpath.

Andy

saurabhsood · #5 (**permalink**) 03-02-11, 10:57

how to set the classpath in linux?

ARWinner · #6 (**permalink**) 03-02-11, 11:18

Google returns:

Linux Headquarters: Setting your Classpath

Andy

saurabhsood · #7 (**permalink**) 03-02-11, 11:22

how do i set it for the db2 jdbc driver?

ARWinner · #8 (**permalink**) 03-02-11, 11:31

It depends on where it is. You should check your classpath for db2inst1 and set the classpath to the same thing for the user.

Andy

shammat · #9 (**permalink**) 03-02-11, 11:42

This is a pure Java question and not related to DB2 at all.

Firt: Do not change (or use) the CLASSPATH variable, it is no longer needed.

When starting your application you need to specify the jar files that your application needs:

Code:

java -cp myapp.jar;db2java.jar mypackage.MyMain

For more details refer to the manual:
http://download.oracle.com/javase/6/docs/technotes/tools/windows/classpath.html

saurabhsood · #10 (**permalink**) 03-02-11, 11:46

setting the classpath didnt work for (might have done it wrong). though, i managed to get it working by including the driver using netbeans. now i am able to connect to the database

thnx for the response...

shammat · #11 (**permalink**) 03-02-11, 11:55

As I said: do not use CLASSPATH.

"Including the driver using netbeans" is essentially providing the necessary information for the -cp parameter.

Please do read the link I posted. This is absolute basic Java knowledge

Internet Services

Web Development

Digital Marketing

Consumer Tech