We are using Connector Xpress to create JDBC Dynamic Connector for MySQL. When we set up the JDBC data source and selected MySQL as Database Type, data source test failed with the following error.
Data source test failed : java.sql.SQLException: No suitable driver found for jdbc:mysql://<IP Address>:3306/<db name>?sessionVariables=sql_mode='ANSI'
Connector Xpress isn't shipped with JDBC driver for MySQL because of license related legal reason. Customer has to accept MySQL license agreement, download the driver jar file and put it under Connector Xpress' lib directory.
Please agree to MySQL license agreement, download specifically mysql-connector_java-5.0.8.tar.gz driver file, extract the file and find mysql-connector-java-5.0.8-bin.jar file and put this jar file under Connector Xpress' lib directory and restart Connector Xpress.
At the time this article is written, we can download mysql-connector_java-5.0.8.tar.gz from the following URL
At the "Product Version:" field select 5.0.8 from the drop down and you should see mysql-connector_java-5.0.8.tar.gz download item.