Relational Migrator - JDBC driver for MySQL are not installed

Working with Data Connectors & Integrations
1

Im gettting the below error when i try to connect to MySQL database via Relational migrator.

Error:
JDBC drivers for MySQL are not installed. Please download, copy to the drivers folder for your OS, and restart Relational Migrator.

Note:

  1. I have downloaded the mysql-connector-j-9.0.0.jar file for platform independent version and placed it to the below folder
    C:\Users\44244\AppData\Local\MongoDB\Relational Migrator\Data\Drivers

  2. Restarted relational migrator multiple times

2

Hi @Praburaja_Paramasivam

I would start with verifying the checksum of the downloaded zip against that on the download page, although the unzip should be verifying the extract jar anyway.

Next stop would be to check the log files and see if there are any errors or warnings.

c:\Users\<username>\AppData\Local\MongoDB\Relational Migrator\Data\Logs\migrator.log

3

Hi @Praburaja_Paramasivam -

Per the docs we recommend you use v8.3.0 of the MySQL driver, although in my testing the v9.0.0 version did at least allow the project to be created.

Two things to double check:

  1. Do you have just the .jar file in the Drivers folder as per my screenshot?
  2. Did you restart RM from the tray icon (as opposed to just closing the browser page)?

image
image1007×634 33.3 KB

1 Like
4

In my experience, one have to restart the computer to make Relational Migrator detect the newly copied JDBC-driver.

5

I am having a problem in my Macbook Air M3. I did put the . jar file inside the "~/Library/Application Support/MongoDB/Relational Migrator/Drivers/ folder, restarted the Application by exiting the tray, and restarted the whole laptop but I still get this problem.

Is there an issue in my Java installation and environment variables? i have openjdk 17 from brew install