Test Data Manager

Expand all | Collapse all

Error while creating DB2 connection profile from TDM Portal

Jump to Best Answer
  • 1.  Error while creating DB2 connection profile from TDM Portal

    Posted 05-04-2017 02:28 PM

    Hi All,

    I'm receiving the following error while creating DB2 connection profile from TDM Portal. I'm able to connect to the database in Datamaker through ODBC connection though.

     

    Failed to connect.

    The server replied: Could not load JDBC driver class [com.ibm.db2.jcc.DB2Driver]; nested exception is java.sql.SQLException

     

    Appreciate your help.

     

    Regards,

    Srini.



  • 2.  Re: Error while creating DB2 connection profile from TDM Portal
    Best Answer

    Posted 05-04-2017 02:35 PM

    Hi Srini, 

     

    Can you try copying the db2jcc4.jar file into the tomcat/lib directory? By default this is located here: C:\Program Files\CA\CA Test Data Manager Portal\tomcat\lib

     

    Best regards,

    Taylor



  • 3.  Re: Error while creating DB2 connection profile from TDM Portal

    Posted 05-04-2017 03:51 PM

    Thanks Taylor.

    I could create a connection profile after copying the .jar file into the specified library. However, I'm receiving an error during publish from TDM portal even though I was able to publish the same from datamaker.

     

    nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-798, SQLSTATE=428C9, SQLERRMC=USER_ID, DRIVER=4.18.60

     

    Regards,

    Srini.



  • 4.  Re: Error while creating DB2 connection profile from TDM Portal

    Posted 05-04-2017 04:10 PM

    Hi Srini, 

     

    It looks like another customer was able to resolve this by making a change in their variables. 

     

    Here is IBM's community post on this error: IBM "...SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<USERNAME>.USER_TABLES, DRIVER=3.…  

     

    If this doesn't help, please open a support case so that we can look more closely at your publish and its configuration. 

     

    Best regards,

    Taylor



  • 5.  Re: Error while creating DB2 connection profile from TDM Portal

    Posted 03-24-2018 08:01 PM

    try to change the site properties under database folder and mark lisadb.internal.enabled=false



  • 6.  Re: Error while creating DB2 connection profile from TDM Portal

    Posted 08-31-2018 09:13 AM

    Jdbc drivers should go into C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers