You are viewing the RapidMiner Server documentation for version 9.0 -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 latest MySQL JDBC driver (8.0.11) 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 please create a new user per schema.
Download the MySQL Connector/J from the official website. Currently the recommended version is8.0.11.
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.
妈ke sure that theJDBC driver classis set to
com.mysql.jdbc.Driver.Complete the installation.
