JDBC Drivers Delivered with DevTest 10.7.0 and later
Article ID: 259085
Updated On:
Products
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
Feedback
