IBM DB2 Universal driver (JCC) not found

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

re: IBM DB2 Universal driver (JCC) not found

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.

re: IBM DB2 Universal driver (JCC) not found

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.

re: IBM DB2 Universal driver (JCC) not found

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.)

re: IBM DB2 Universal driver (JCC) not found

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.