Test Data Manager

  • 1.  Error while creating DB2 connection profile from TDM Portal

    Posted May 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 May 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 May 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 May 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 Mar 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

    Broadcom Employee
    Posted Aug 31, 2018 09:13 AM

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