JDBC Drivers Delivered with DevTest

Products

• Service Virtualization

Issue/Introduction

JDBC drivers delivered with DevTest.

Environment

All supported DevTest releases.

Cause

N/A

Resolution

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