You are viewing the RapidMiner Legacy documentation for version 9.9 -Check here for latest version
Using the MySQL Connector/J (JDBC driver)
RapidMiner Server comes bundled with three database drivers:
- MSSQL
- Oracle
- PostgreSQL
If you want to connect to MySQL databases, you need to manually download and configure theMySQL 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 version8.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 older5.1.47version of the MySQL JDBC driver.
Download the MySQL Connector/J from the official website. Currently the recommended version is5.1.47,8.0.11, or at most8.0.22.
The connector itself is a single file named
mysql-connector-java-X.X.XX-bin.jar. Extract this file from the downloaded archive to thedata/jdbcfolder in your RapidMiner Server Installer folder.In the database configuration step selectMySQLasdatabase systemand provide the file path of the connector extracted in the second step as
Jar file.
Make sure that theJDBC driver classis set to
com.mysql.jdbc.Driver.Complete the installation.
