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.
Hi @ego2gogo , and welcome to the KNIME forum. I’ve now modified your original post so it now contains your jdbc URL information.
The problem with what you wrote was the presence of the < > characters, which the forum software interpreted and hid.
If you have any text containing such characters, or any code samples that you don’t want the forum software to modify in any way (eg changing of quotes to ‘smart quotes’ in code samples), highlight it and press the </> button on the toolbar:
Hello @ego2gogo ,
if you use the AWS JDBC driver you need to change your JDBC URL to jdbc:aws-wrapper:mariadb:// as described here instead of jdbc:mariadb://.
If this doesn’t solve the problem please add a pointer (e.g. download page) to any external driver and the full version. Unfortunately there are different drivers with different settings available. Thanks.
