connect to remote mysql db

KNIME Analytics Platform
1

Hello,

I’m new to KNIME and I’m having trouble using it to read from a remote database.

I drop the Database Reader node and configure it as follows:

sun.jdbc.odbc.JdbcOdbcDriver
jdbc:mysql://imgdb01:3306/af

with the username and password entered correctly I get the following messages:

WARN DatabaseReaderConnection PreparedStatment not support by database: Driver “sun.jdbc.odbc.JdbcOdbcDriver” does not accept URL: jdbc:mysql://imgdb01:3306/af
WARN Database Reader java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver “sun.jdbc.odbc.JdbcOdbcDriver” does not accept URL: jdbc:mysql://imgdb01:3306/af

It appears that my JdbcOdbcDriver doesn’t recognize the mysql:// URL I gave it. I’m certain I have the db host, name, user, and password correct. Does anyone know what is going wrong here and how I could fix/work around it?

Thanks
-adam

2

Dear Adam,
In order to connect to a MySQL database you need a JDBC MySQL Driver.
Download the driver and unpack it somewhere, then click the “Load” button of the Database Reader’s dialog and select the “mysql-connector-java-xxx.jar”. In the drop down box you can select - as far as I know - every mysql driver. Then everything should work as expected. (Same holds for every other database like Oracle, DB2, etc.: the referring JDBC Driver has to be loaded in order to connect to it).

Fabian

3

I download JDBC MySQL Driver, unzip on Win XP and intended Load, it doesn’t work, What can I do? Thanks.

4

Hi jromero,
If you have downloaded the Jar, there is no need to unzip it. Simply go into the KNIME preference page and load to file inside the KNIME/Database Driver section.
Best, Thomas

5

I can do it. Thank you very much, best…

6