Troubleshooting
Problem
While support for MySQL 8 exists in Netcool Impact from FP20 onwards, the MySQL 8 JDBC Driver .jar files can't be used because the full package name for the Driver class has changed in MySQL 8 (from org.git.mm.mysql.Driver to com.mysql.cj.jdbc.Driver).
Symptom
Connections for data sources to MySQL v8 will fail to connect.
Cause
The package name for the Driver class has changed in MySQL 8 to com.mysql.cj.jdbc.Driver from org.git.mm.mysql.Driver in version 5.
Diagnosing The Problem
You will see an error message relating to the driver class, for example:
Could not load JDBC driver for user at jdbc:mysql://host:3306/database,user at jdbc:mysql://host:3306/database: org.gjt.mm.mysql.Driver
Resolving The Problem
This issue will be addressed by APAR IJ33464 in Impact 7.1.0.23 (Fixpack 23).
There are 2 possible workarounds for the issue:
- Use the MySQL 5 JDBC Driver, for MYSQL 8, instead.
- Use a Generic SQL Data Source and specify the MySQL 8 JDBC driver in the definition - i.e. in the "JDBC Driver Name" field, specify "com.mysql.cj.jdbc.Driver" as the driver class.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSCP78Y","label":"Netcool\/Impact"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
02 September 2021
UID
ibm16485917