Hi Experts,
Iam new to KNIME,
Iam getting the following error when I am clicking Fetch metadata button in Database reader node.
Can anyone please suggest me how to solve this issue and How can I get the data from mysql table.
Error during fetching metadata from database, reason: org.knime.core.node.InvalidSettingsException: Driver "com.mysql.jdbc.Driver" does not accept URL: jdbc:odbc://localhost:3306/p2k_localdb
Thanks in advance
Janu
Dear Janu,
Were you be able to connect to the MySQL database through the Database Connector node? If yes, you should first select org.mysql.jdbc.Driver as database driver and then use the following database URL to connect to the MySQL DB: jdbc:mysql://<host>:<port>/<database_name>. Once you are connected to the database, you can use the Database Table Selector node to select the table you are interested in and finally the Database Connection Table Reader to read the entire data table from the database into KNIME Analytics Platform.
Hope that helps,
Best,
Vincenzo