JDBC drivers delivered with DevTest

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

What JDBC drivers are delivered with DevTest?

Environment

All supported DevTest releases and platforms.

Cause

N/A

Resolution

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

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

SQL Server     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.7.0:  db2jcc4-10.5.0.4.jar             DevTest 10.7.2: db2jcc4-10.5.0.4.jar

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

 

The only driver we do not deliver is for MySQL, but starting with DevTest 10.7.2 SP3, mysql.mysql-connector-java-8.0.30.jar is delivered in the IAM_HOME\lib\lib\main because it comes with Keycloak.  You will also have to have this driver on Workstations connecting to a remote Registry as well.

 

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.  DB2 not supported for IAM.   (as of DevTest 10.7.2 we create this folder on install, but do not deliver all the drivers, so you can copy them from the LISA_HOME/lib/shared folder)