日期:2014-05-16  浏览次数:20849 次

Kettle 4.3 连接Mysql报错

Kettle设置Mysql数据库连接后报以下错误,原因是Kettle自带的Mysql驱动去Mysql版本冲突,解决办法为:

下载最新Mysql驱动,我这里下载的是:mysql-connector-java-5.1.22-bin.jar

放到KETTLE_HOME\pdi-ce-4.3.0-stable\data-integration\libext\JDBC\下,关闭程序,重新执行Spoon.bat

?

--------------------------------------Error Log------------------------------------

错误连接数据库?[foodmartconn]?:?org.pentaho.di.core.exception.KettleDatabaseException:?
Error?occured?while?trying?to?connect?to?the?database

Exception?while?loading?class
org.gjt.mm.mysql.Driver


org.pentaho.di.core.exception.KettleDatabaseException:?
Error?occured?while?trying?to?connect?to?the?database

Exception?while?loading?class
org.gjt.mm.mysql.Driver


at?org.pentaho.di.core.database.Database.normalConnect(Database.java:368)
at?org.pentaho.di.core.database.Database.connect(Database.java:317)