IBM Support

JDBC probe - "Probe unable to find the JDBC Driver class" error

Question & Answer


Question

How to fix the probe error  "Probe unable to find the JDBC Driver class" ?

Cause

The JDBC driver is missing.

Answer

The JDBC probe is installed and configured to establish a connection with  MySQL DB. After the probe is started, the below error can be found in the log :

"Probe unable to find the JDBC Driver class"

JDBC driver for the target database from the database vendor and install it according to the vendor's instructions. The drivers are usually provided as Java™ archives (.jar).

Then, you need to set CLASSPATH variable and the below probe properties :

https://www.ibm.com/support/knowledgecenter/SSSHTQ/omnibus/probes/jdbc_probe/wip/reference/jdbcpr_connecting_event_source.html

e.g

JdbcDriver :

com.mysql.jdbc.Driver

JdbcUrl :

jdbc:mysql://host_name[,failover_host]:port/db_name[?param1=value1&param2=value2]

Where host_name is the name of the database host machine, failover_host is the name of the optional failover host, port is the port number, db_name is the name of the database, and param1 and param2 are optional parameters. The default port is 3306.

e.g

jdbc:mysql://server.example.ibm.com:3306/alerts

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"ARM Category":[{"code":"a8m500000008a6DAAQ","label":"Probes->1 Individual Probes->JDBC nco_p_jdbc"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Version(s)","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

nco_p_jdbc

Document Information

Modified date:
29 April 2020

UID

ibm16202770

Page Feedback