No suitable driver found for JDBC MySQL using Connector Xpress

book

Article ID: 134411

calendar_today

Updated On:

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'




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.

Environment

Release :14.x


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.

Attachments