java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver "sun.jdbc.odbc.JdbcOdbcDriver" does not accept URL:

KNIME Analytics Platform
1

Dear All,
When I run example workflow “knime://EXAMPLES/008_WebAnalytics_and_OpenStreetMap/008004_geolocalization_IP_static_2013”,Bleow error information printed, please help me how to fix it.

WARN Database Table Connector java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver “sun.jdbc.odbc.JdbcOdbcDriver” does not accept URL: jdbc:sqlite:/C:/Users/bliu/AppData/Local/Temp/knime_temp_space_bliu_59470/008004_geolocalization_IP_static_201359489/008004_geolocalization_IP_static_2013/Java Edit Variable simple (#5)/drop/ipdb.sqlite

2

Hi,

teh node should use the SQLite driver which does not seem to be installed. Please have a look at the Database Documentation page on how to install a JDBC driver. You will also find a link to the apropriate SQLite driver.

Bye,

Tobias