Error when connecting to 'MYSQL5' data source from the Information Designer in TIBCO Spotfire client - Error initializing data source with name 'Test': Cannot instantiate JDBC driver with class name com.mysql.cj.jdbc.Driver
Article ID: KB0071320
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All supported versions |
Description
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
Environment
Resolution
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.
Issue/Introduction
Additional Information
- MySQL Community Downloads
Feedback
