IBM Support

Unable to connect to Teradata database using generic JDBC in WCA 3.5

Question & Answer


Question

I am trying to setup a generic JDBC connection in Watson Content Analytics for the first time to Teradata. I have copied the .jar files to a location on the server and then tried to go through the setup in the admin console. After fininshing the setup I receive error FFQD2329E: The JDBC driver terajdbc4.jar could not be loaded. The logs also show the following: 251658517"1"1428517226474"603982204"11956"169" " discovery" DWPBITA001" OSSLogger.java"234"3 java.lang.ClassNotFoundException: terajdbc4.jar"3 java.lang.ClassNotFoundException: terajdbc4.jar Why am I reciveing this error and how can I get a successful connection to Teradata?

Cause

The JDBC driver could not be loaded because the class path for the specified JDBC driver is incorrect.

Answer

The "JDBC driver class path" must be set like a typical Java Classpath variable. In other words, it is not to be confused with a system path.

      Incorrect
      /data/wcadata/JDBCDrivers/Teradata

      Changed
      /data/wcadata/JDBCDrivers/Teradata/terajdbc4.jar:/data/wcadata/JDBCDrivers/Teradata/tdgssconfig.jar

      Please note: The Windows platform separator is the semi-colon :

Example:

[{"Product":{"code":"SS5RWK","label":"Content Analytics with Enterprise Search"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg21902776

Page Feedback