IBM DB2 Universal driver (JCC) not found

[adbijagare]

Hi ,

I am trying to connect to my database through the development centre.
In the database connection wizard i m using the followin information

Driver : IBM DB2 universal type 2

Database name

location : jdbc:db2:databasename

Driver Class: com.ibm.db2.jcc.DB2Driver

When i try to connect to the database it shows an error message stating that

connection to database failed
IBM DB2 universal driver (JCC) not found.

Please suggest some solution over this.
Have i missed something in the db2 installation ?



Thanks&Regards
Abhijeet

[kim_jin]

I assume you did not set the environment variable correctly.Pls check the "CLASSPATH" variable on Windows and run you java application with -cp variable on Unix.
For example:
java -cp {DB2HOME}/sqllib/java/db2jcc.jar JavaClassName
Try it.

[dvineel]

I assume you did not set the environment variable correctly.Pls check the "CLASSPATH" variable on Windows and run you java application with -cp variable on Unix.
For example:
java -cp {DB2HOME}/sqllib/java/db2jcc.jar JavaClassName
Try it.

what should be there in the java class path and class name.
is it the same you have given above or it is system dependent.

[sakthikumaran]

hi

i can't understand what is 'Development centre',.... but i'm using eclipse in that i simple include(import) the mentioned file(mentioned in post #2) to my project... after that it won't tell an error message
(before that me too had the same problem in eclipse.)

[hbwilly54]

Ok if you are using eclipse for to excute Jython there are a few things to need to do.

Right click on your project and select properties in the list
Then click on PyDev - PythonPath
in the box for External Source Folders
Add db2jcc.jar and
Add db2cc_license_cr.jar filles
and click ok.