Jdbc .jar file for custom adapter won't load

Jdbc .jar file for custom adapter won't load

book

Article ID: KB0081984

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6 and earlier

Description

Scenario:
A custom adapter has been created and the vendor's jdbc .jar file has been added to <install dir>/conf/adapters/custom/<your adapter name>
but when you attempt to use the adapter to create a new datasource, the Studio pops up an error message containing the text:

"The proper JDBC adapter must be installed to access this type of datasource.
Copy the appropriate driver jar/zip to the directory  <install dir>/conf/adapters/custom/<your adapter name>
"

Despite restarts of the server to load the vendor's .jar file, that .jar file isn't taking effect.

Issue/Introduction

This discusses the creation of a custom adapter in TDV v7.0.6 and older.

Resolution

Check with the vendor to see what version of the java JDK this .jar file was compiled with.
If you are using TDV v7.0.6 or earlier, by default it is embedded with jre v1.7.
If your .jar file was compiled under v1.8, you will need to either upgrade to TDV v7.0.7 (or later) where it embeds jre v1.8, or you can manually upgrade the jre to v1.8 yourself on the earlier TDV release.

To upgrade your jre on TDV v7.0.6, search for knowledge base article 000034296.