IBM Support

Error code XQE-JDB-0004 while testing JDBC data source connection to Oracle server

Troubleshooting


Problem

Testing a JDBC connection received the error code XQE-JDB-0004 a problem occurred finding the driver class "oracle.jdbc.OracleDriver"

Cause

The JDBC connector is missing from install_location\drivers folder or not installed properly.

Diagnosing The Problem

Check the install_location/drivers for missing ojdbc8.jar file

Resolving The Problem

  • If the ojdbc8.jar file is present in the install_location/webapps/p2pd/WEB-INF/lib folder then copy the file to the install_location/drivers folder.
  • If the ojdbc8.jar file is not available, download the file from the download center site: https://www.oracle.com/ca-en/database/technologies/appdev/jdbc-downloads.html
  • Then, copy the ojdbc8.jar file to the install_location/drivers folder.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration->Data Sources"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
03 November 2021

UID

ibm16513286