Service Virtualization

  • 1.  Tech Tips: JDBC Drivers Delivered with DevTest

    Broadcom Employee
    Posted Feb 23, 2017 01:03 PM
    Edited by Marcy Nunns Feb 01, 2023 05:59 PM

    The JDBC drivers, we deliver with DevTest for the external databases we support, are:

     

    Oracle             DevTest 10.6.0: ojdbc7-12.1.0.2.jar       DevTest 10.7.0:  ojdbc7-12.1.0.2.jar                DevTest 10.7.2:  ojdbc8-12.2.0.1.jar

    SQL Server     DevTest 10.6.0: sqljdbc4-4.0.jar        DevTest 10.7.0:  mssql-jdbc-8.2.0.jre8.jar      DevTest 10.7.2:  mssql-jdbc-8.2.0.jre8.jar

    DB2                 DevTest 10.6.0: db2jcc4-10.5.0.4.jar    DevTest 10.7.0: db2jcc4-10.5.0.4.jar             DevTest 10.7.2:  db2jcc4-10.5.0.4.jar

    PostgreSQL     DevTest 10.6.0: postgresql-42.2.5.jar  DevTest 10.7.0: postgresql-42.2.20.jar         DevTest 10.7.2:  postgresql-42.3.2.jar


    For IAM the drivers are in:

    DEVTEST_HOME\IdentityAccessManager\database\drivers

    For Enterprise Dashboard the drivers are in:

    DEVTEST_HOME\lib\dradis

    For Registry the drivers are in:

    DEVTEST_HOME\lib\shared

    The drivers we delivers can be used with the databases we support for each release.

    The only driver we do not deliver is for MySQL.  

    1. You can download and install JDBC client for MySQL referred to as Connector/J from (http://dev.mysql.com/downloads/connector/j/)

     

    2. For DevTest, the driver goes in the DEVTEST_HOME/lib/dradis folder, for Enterprise Dashboard,  DEVTEST_HOME/lib/shared folder, for Registry) and the DEVTEST_HOME/IdentitfyAccessManager/database/drivers for IAM.

    NOTE: You will need to create the DEVTEST_HOME/IdentitfyAccessManager/database/drivers folder.

     

    You will also have to have this driver on Workstations connecting to a remote Registry as well.

    https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-6/installing/preinstallation/system-requirements.html#concept.dita_32422ef2bcae24b675c3df2ce5836fe565b94511_DatabaseRequirements

    https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-7/installing/preinstallation/system-requirements.html#concept.dita_32422ef2bcae24b675c3df2ce5836fe565b94511_DatabaseRequirements

     



  • 2.  Re: Tech Tips: JDBC Drivers Delivered with DevTest

    Posted Jun 14, 2017 03:41 PM