JDBC Drivers Delivered with DevTest 10.7.0 and later
search cancel

JDBC Drivers Delivered with DevTest 10.7.0 and later

book

Article ID: 259085

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

JDBC drivers delivered with DevTest 10.7.0, 10.7.2, 10.8.0 and 10.8.1

Environment

All supported DevTest releases.

Resolution

The JDBC drivers delivered with DevTest for the external databases supported are:

Oracle            DevTest 10.7.0:  ojdbc8-12.2.0.1.jar               DevTest 10.7.2:  ojdbc8-12.2.0.1.jar             DevTest 10.8.0:  ojdbc8-12.2.0.1.jar              DevTest 10.8.1:  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     DevTest 10.8.0:  mssql-jdbc-8.2.0.jre8.jar     DevTest 10.8.1:  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            DevTest 10.8.0:  Do not support                    DevTest 10.8.1:  Do not support

PostgreSQL   DevTest 10.7.0:  postgresql-42.2.20.jar          DevTest 10.7.2:  postgresql-42.3.2.jar          DevTest 10.8.0:  postgresql-42.5.5.jar           DevTest 10.8.1:  postgresql-42.5.5.jar

 

For IAM the drivers are in:

DEVTEST_HOME\IdentityAccessManager\database\drivers  (DB2 not supported for IAM)

For Enterprise Dashboard the drivers are in:

DEVTEST_HOME\lib\dradis

For Registry the drivers are in:

DEVTEST_HOME\lib\shared

The drivers delivered can be used with the databases DevTest supports for each release.

 

The only driver not delivered is for MySQL.  

1. 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: Need to create the DEVTEST_HOME/IdentitfyAccessManager/database/drivers folder.

 

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


Database Requirements for DevTest 10.7.x

Database Requirements for DevTest 10.8.x