Unable to open the information link, Error Message: Unable to load JDBC driver class "Oracle 12c (Thin Driver) from the TDV data source

Product: TIBCO Data Virtualization

Versions: 7.x and above

Summary:

Unable to open the information link, Error Message: Unable to load JDBC driver class "Oracle 12c (Thin Driver) from the TDV data source.

Details:

While executing the information link from the TIBCO Spotfire Analyst, configured from the TIBCO Data Virtualization(TDV) using Oracle Thin data source, the below error message may occur:

---------------------------------------------------
InformationModelServiceException at Spotfire.Dxp.Services:
Failed to execute query: An exception occurred when executing the following query: "SELECT I1."TEST_ID" AS "TESTID", I1."ITEMNAME_ID" AS "ITEMNAMEID" FROM "MANOJ"."TEST" I1".  Cause: Unable to load JDBC driver class "Oracle 12c (Thin Driver)".  [datasrc-2962041] [Log ID: 0611836e-5580-45c5-be27-d1e80bd9d825] [jdbc-1906510] (HRESULT: 80131509)
---------------------------------------------------

Resolution:

To resolve the issue, place the desired JDBC Oracle Thin driver at the below locations:

1) <TDV Server Installation Directory>\conf\adapters\system\oracle_12c_thin_driver
2) <TDV Server Installation Directory>\apps\dlm\cis_ds_oracle\lib

After placing the desired driver, restart the TDV Server Service.

Note: Similarly, check the stack trace of the error message and paste the desired driver in the corresponding adapters location/folder.