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:
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?