[vkamin99]

I can’t connect to our db2 database using the DB explorer.

We are using UDB 8, fixpack 11

I myeclipse->driver
Drive Template: IBM DB2 (Universal driver)

Drivers Jars
d:\SQLLIB\java\db2java.zip

Driver classname : com.ibm.db2.jdbc.net.DB2Driver

When I create a new connection in DB explorer. It just gets stuck does nothing

I read thru some of the old posting, but nothing has helped so far.

Appreciate all your help

Thanks
-VKA

[Haris Peco]

VKA,

You have tried use Type 3 driver.MyEclipse is not tested with this driver, but I suppose that it will work if you have correct set middleware servers (middleware server is gateway to heterogeneous backend servers).It is database indepenent protocol and I doubt that it is what you wanted.

For Type 4 (recommended) and Type 2 (you can use it, but you have to set correct db2 environment in current session) driver class name is :

COM.ibm.db2.jdbc.app.DB2Driver

Driver’s jars are db2jcc.jar and db2jcc_license_cu.jar (you can find this jars in sqllib/java directory).

Example of URLs are :

jdbc:db2//server:port/database
jdbc:db2//server/database

for Type4

and

jdbc:db2:database

for Type 2 driver

Regards,

[adamwork]

I’m having the same problem.

I’ve set my DB Explorer to the following.

I’ve used all 3 types of templates and the one below and none are working.

COM.ibm.db2.jdbc.app.DB2Driver

I’ve included the jar files below.

db2jcc.jar and db2jcc_license_cu.jar

but when I try to connect it keeps saying “Database connection lost. Do you want to re-connect.”

I keep saying yes and it keeps going back to the same message.

When I’m at the Schema Details screen and I try to add one I get a message that says. Unable to retrieve database meta information.

I’m using the same drives and information in my dbvisualiser but would like to use the DB profiler to create hibernate files and classes.

Any idea?

Thanks

Adam Shepherd

[Riyad Kalla]

Adam,
If you check your log file <workspace dir>\.metadata\.log near the end, are there any telling exceptions?

[adamwork]

Riyad,

There wasn’t anything in the log file. There were not exceptions.

Thanks

Adam Shepherd

[Author]

Posts