Oracle data source connections fails in TIBCO Data Virtualization Studio 8.3.0 after importing a .car file from version 7.0.8

Oracle data source connections fails in TIBCO Data Virtualization Studio 8.3.0 after importing a .car file from version 7.0.8

book

Article ID: KB0074160

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.0 and higher

Description

After importing the .car file taken from TDV 7.0.8 version to the TDV 8.3 server, the connection with the Oracle data source fails with the below error message:

Unable to load JDBC driver class "Oracle 12c (Thin Driver)".  [datasrc-2962041]
Cause: oracle.jdbc.OracleDriver [Log ID: dd8d576b-3b5d-4de8-b7bb-e6befb5d5c94]

Root cause:
The issue occurs if the driver-jar files are not compatible with the Java version used by the TDV server. The TDV 8.3 uses JDK 11 and TDV 7.0.8 used JRE 1.8. Hence, driver jars certified for JDK 11 need to be used in the TDV 8.3 server. 

Issue/Introduction

The connection with the Oracle data source fails in 8.3 TIBCO Data Virtualization Studio after importing a .car file from version 7.0.8.

Environment

All Supported Operating Systems

Resolution

Follow the below steps to resolve the issue:

1. Download the JDBC Oracle driver jar files which are certified for JDK 11 from the Oracle download site.

Reference Link:
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

2. Copy the downloaded ojdbc10.jar file to the path:
[ TDV Server 8.3 dir ]\conf\adapters\system\oracle_12c_thin_driver

3. Restart the TDV server services.

4. Test the connection with the configured Oracle data source. 
Powered by Wolken Software