can not create a connection to database：com.mysql.jdbc.Driver

KNIME Analytics Platform
1

if a want to get a connection to mysql in the workflow,i should add the mysql driver file like "mysql-connector-java-5.1.6-bin.jar"   it will be ok but if i export the workflow to a zip file......run it on the windows command line

   c:\....\knime.exe ...-workflowFile=c:\....connectToMysql   

 the error will occour like: can not create a connection to database：com.mysql.jdbc.Driver

 how to solve the problem?

2

You need to export the preferences from your KNIME GUI instance which contain the path to the JDBC driver. When running the batch executor you need to point it to the exported preferences file with the -preferences argument.

Or you install the "Common JDBC drivers" extension, which include a MySQL JDBC driver.