1. Documentation
2. 10.1 (Latest)10.09.109.99.89.79.69.59.49.39.29.19.08.28.18.07.6
3. Studio
4. How to
5. Using the MySQL Connector/J

Using the MySQL Connector/J (JDBC driver)

RapidMiner Studio comes bundled with theMariaDB Connector/J– a driver that allows to connect to both MariaDB and MySQL databases. If you want to connect to MySQL databases using the official driver, you need to manually download and configure theMySQL Connector/J.

This article will walk you through how to:

• Install the MySQL JDBC Connector/J
• Check which connector is used

Install the MySQL JDBC Connector/J

1. Download the latest MySQL Connector/J from the officialMySQL website.

   Both the compressed TAR archive and the ZIP archive will work.

2. The connector itself is a single file namedmysql-connector-java-X.X.XX-bin.jar. Extract this file from the downloaded archive to a location on your hard drive that is accessible from RapidMiner Studio.

3. In RapidMiner Studio, open theManage Database Driversdialog from the连接menu.

4. Click onAdd创建一个新条目the following properties:

   

   Select the connector extracted in the second step asJar file.

   Please pay special attention to the correctURL前缀andDriver class(an incorrect class might be selected by default).

5. Close the dialog by clicking onSave.

Check which connector is used

To check whether the MariaDB Connector/J or the MySQL Connector/J is used, open theShow Database Drivers…dialog from the连接menu:

If the driver classes for both the bundled and the newly created connectors iscom.mysql.jdbc.Driverthe MySQL Connector/J is being used. If it isorg.mariadb.jdbc.Driver, the bundled MariaDB Connector/J is used.