Versions:All supported versions
Summary:
Error when connecting to 'MYSQL5' data source from the Information Designer: Error initializing data source with name 'Test': Cannot instantiate JDBC driver with class name com.mysql.cj.jdbc.Driver NOTE: This article also applies to the same error message when it refers to the older, deprecated 'com.mysql.jdbc.Driver' driver class, as in the following: Error initializing data source with name 'Test': Cannot instantiate JDBC driver with class name com.mysql.jdbc.Driver
Details:
When connecting to the 'MySQL5' data source present inside the "Tools > Information Designer" menu item, the below error message appears:
---------------------------------------------------------------------
The data source type 'mysql5' is not supported.
Cannot connect to data source 'Manager', due to invalid configuration or that the data source is not running.
Database reported:
Error initializing data source with name 'Test': Cannot instantiate JDBC driver with class name com.mysql.cj.jdbc.Driver
---------------------------------------------------------------------
See also the attached reference image 'MYSQL5_Error.png', which refers to the older, deprecated 'com.mysql.jdbc.Driver' class that was still current when this article was first written, as in the following:
Error initializing data source with name 'Test': Cannot instantiate JDBC driver with class name com.mysql.jdbc.Driver
Resolution:
To resolve the issue, follow the below steps:
1) Open the below link in the browser to download the latest available MySQL JDBC driver. Link: https://dev.mysql.com/downloads/connector/j/
2) Download the corresponding Zip file and extract/unzip it.
3) Copy the file - mysql-connector-java-5.X.XX-bin.jar - to <TIBCO Spotfire Server installation directory>\tomcat\custom-ext if using TIBCO Spotfire Server 10.3 or higher, or <TIBCO Spotfire Server installation directory>\tomcat\lib if using TIBCO Spotfire Server 10.2 or lower.
4) Now restart the Spotfire Server service.