I'm having no luck connecting to an RDS mysql instance with latest jdbc drivers
This error continues to be thrown after attempting to connect Knime to an RDS instance of a MySql DB. I am running Knime on MacOS. I’ve tried JDBC version 3, 8 and 9.
ERROR MySQL Connector 3:2 Execute failed: Selected JDBC driver does not support given JDBC url.
Here is my connection string:
jdbc:mariadb://<serverURL>:3306/<myDB>I have also attempted to use this string:
jdbc:mysql://<serverURL>:3306/<myDB>The
<serverURL>is copied directly from the AWS console (and it also appears in my local MySql Workbench configuration).
The funny thing is that a colleague of mine, using the same Knime project but on Windows, is able to access the database using version 3.4.1 of the JDBC driver, but NOT the 9.1.0 version of the driver.