No suitable driver found for JDBC MySQL using Connector Xpress

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

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'

Environment

Release :14.x

Cause

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.

Resolution

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

   https://downloads.mysql.com/archives/c-j/

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.