Topic
  • 3 replies
  • Latest Post - ‏2013-02-14T17:03:42Z by SystemAdmin
SystemAdmin
SystemAdmin
9855 Posts

Pinned topic Db2 Driver Issue with ITDI

‏2013-02-13T19:45:02Z |
I am trying to connect to Db2 database from ITDI -JDBC Connector.

For the Connection parameters in ITDI, I am providing the following information :

JDBC URL : jdbc:db2//Projects.ad.org12.com:50000/MYDB
JDBC Driver: COM.ibm.db2.jcc.DB2Driver
UserName
Password
Schema
TableName

However when I try to test the connection, I get an error:

"exception": "java.lang.ClassNotFoundException: COM.ibm.db2.jcc.DB2Driver",
"message": "COM.ibm.db2.jcc.DB2Driver",
"class": "java.lang.ClassNotFoundException"
I understand that the "db2jcc.jar" and "db2jcc_license_cu.jar" needs to be supplied to ITDI. I have placed these files in the following locations:
C:\Program Files\IBM\TDI\V7.1\jars
C:\Program Files\IBM\TDI\V7.1\jars\3rdparty
C:\Program Files\IBM\TDI\V7.1\jars\3rdparty\IBM
C:\Program Files\IBM\TDI\V7.1\jars\3rdparty\others

I continue to get the error even after having the Jars placed at the above mentioned location and restarting the ITDI Service.
Any help on this will be appreciated.
Updated on 2013-02-14T17:03:42Z at 2013-02-14T17:03:42Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    9855 Posts

    Re: Db2 Driver Issue with ITDI

    ‏2013-02-14T05:28:56Z  
    should be: -

    com.ibm.db2.jcc.DB2Driver

    case sensitive

    Best regards,
  • SaqibFarooq
    SaqibFarooq
    21 Posts

    Re: Db2 Driver Issue with ITDI

    ‏2013-02-14T07:58:16Z  
    should be: -

    com.ibm.db2.jcc.DB2Driver

    case sensitive

    Best regards,
    Connection string should be like this:
    JDBC URL : jdbc:db2://Projects.ad.org12.com:50000/MYDB
    JDBC Driver: com.ibm.db2.jcc.DB2Driver
  • SystemAdmin
    SystemAdmin
    9855 Posts

    Re: Db2 Driver Issue with ITDI

    ‏2013-02-14T17:03:42Z  
    Connection string should be like this:
    JDBC URL : jdbc:db2://Projects.ad.org12.com:50000/MYDB
    JDBC Driver: com.ibm.db2.jcc.DB2Driver
    Thanks SaqibFarooq and Goonitsupport. This resolved by problem. Appreciate your help.