日期:2014-05-16 浏览次数:20880 次
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)