报错信息如下:
错误连接数据库 [{mysql连接名称}] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class ‘org.gjt.mm.mysql.Driver‘ could not be found, make sure the ‘MySQL‘ driver (jar file) is installed.
org.gjt.mm.mysql.Driver
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class ‘org.gjt.mm.mysql.Driver‘ could not be found, make sure the ‘MySQL‘ driver (jar file) is installed.
org.gjt.mm.mysql.Driver
很明显,是因为没有找到mysql连接驱动jar包。
解决方法:
第一步,下载mysql连接驱动
https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-5.1.48.zip
(若有新版本发布,只需将链接中的版本号修改为最新的版本即可)
第二步,解压上一步下载的压缩包,将mysql-connector-java-5.1.48-bin.jar复制到Kettle安装目录下,即\pdi-ce-xxxxxxx\data-integration\lib目录下。
第三步,重启Spoon.bat,问题解决。若不重启Spoon.bat,仍会报错。