Using the MySQL Connector/J (JDBC driver)

RapidMiner Server comes bundled with three database drivers:

  • Oracle
  • PostgreSQL

If you want to connect to MySQL databases, you need to manually download and configure the MySQL Connector/J.

This article will walk you through how to:

Install the MySQL JDBC Connector/J

Due to a problem with MySQL JDBC Connector/J versions greater than 8.0.22, ensure to use at most version 8.0.22.

Due to a problem with the latest MySQL JDBC driver (8.0.14) the hibernate table update will not work with more than one RapidMiner Server schema per database user. If you want to store multiple RapidMiner Server schemas on the same MySQL Server and use the latest JDBC driver please create a new user per schema or use the older 5.1.47 version of the MySQL JDBC driver.

  1. Download the MySQL Connector/J from the official website. Currently the recommended version is 5.1.47, 8.0.11, or at most 8.0.22.

  2. The connector itself is a single file named mysql-connector-java-X.X.XX-bin.jar. Extract this file from the downloaded archive to the data/jdbc folder in your RapidMiner Server Installer folder.

  3. In the database configuration step select MySQL as database system and provide the file path of the connector extracted in the second step as Jar file.

  4. Make sure that the JDBC driver class is set to com.mysql.jdbc.Driver.

  5. Complete the installation.