DB2 - Cannot Connect to Database

General Questions/Discussions
1

Using DB-VA SQL 2.2, I am trying to set up a JDBC DB2 Net Driver (Type 4) connection for DB2. I have selected C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar in the Driver file location, and correctly entered my connection URL.

Trying to test the connection, I get
java.lang.Exception: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver
v.qua.i(:542)

I have also tried using other drivers but still get the same error message.

Thanks
Jeff

2

Hi Jeff,

I will notify our engineers about this problem. In the meantime, could you provide me with the full log? The full log file could be found under the bin directory of VP Suite installation directory.

Looking forward to hearing from you.

Best Regards,
Jick

3

Hi Jeff,

I just got a reply from our engineers. Please press the down arrow button and change the class name to “com.ibm.db2.jcc.DB2Driver”. We will fix this problem in the next release. Sorry about this.

Best Regards,
Jick

4

Hi Jeff,

The fix will be available in build 20060218 that will be available next week.

Best Regards,
Jick

5

Hi Jeff,

The fix is ready at the latest release. Please perform a product update to obtain the fixed copy. For details about performing update, please visit:
http://resource.visual-paradigm.com/tips_and_tricks/general/keeping_your_tool_up-to-date.html

Please let me know if there are any questions.

Best Regards,
Jick

6

I am trying to generate sql form the entity relationship diagram I created but I am having problem sin doing so. How do I go about it.

7

Hi user,

Could you please let me know what the problem is? Any warning or error? If possible, could you capture screenshot to show the problem? Thank you in advance.

Best Regards,
Jick

8

hi,i am getting this exception
Warning: Error registering driver [com.ibm.db2.jcc.DB2Driver]
java.lang.ClassNotFoundException: com/ibm/db2/jcc/DB2Driver.
plz nyone help me.
regards,
smita

9

Hi Smita,

Thanks for your post. Could you please send me the vp.log file (inside VPSuite/bin folder) to take a look? Thanks in advance!

Best regards,
Lilian Wong