kettle 关闭的链接问题

您好，根据错误提示：org.pentaho.di.core.exception.KettleDatabaseException

没做hadoop 2.20的配置前，kettle4.4是支持hive的取数

解决：

采用kettle5.0.1，配置hadoop 2.20的相关插件后，是可以了。

INFO 13-06 15:19:00,420 (LogWriter.java:println:406) -file2DBTest - New database connection defined

ERROR 13-06 15:19:00,421 (LogWriter.java:println:403) -表输出.0 - An error occurred intialising this step:

Error occured while trying to connect to the database

Exception while loading class

net.sourceforge.jtds.jdbc.Driver

ERROR 13-06 15:19:00,422 (LogWriter.java:println:403) -表输出 - 错误初始化步骤[表输出]

INFO 13-06 15:19:00,422 (LogWriter.java:println:406) -transFile2db - 步骤 [Excel输入.0] 初始化不完全，有缺陷.

INFO 13-06 15:19:00,423 (LogWriter.java:println:406) -transFile2db - 步骤 [字段选择.0] 初始化不完全，有缺陷.

ERROR 13-06 15:19:00,423 (LogWriter.java:println:403) -transFile2db - 步骤 [表输出.0] 初始化失败!

ERROR 13-06 15:19:00,424 (LogWriter.java:println:403) -表输出.0 - Unexpected error rolling back the database connection.

ERROR 13-06 15:19:00,425 (LogWriter.java:println:403) -表输出.0 - org.pentaho.di.core.exception.KettleDatabaseException:

Unable to get database metadata from this database connection

at test.ReaderTransFromRep.main (ReaderTransFromRep.java:71)

at test.ReaderTransFromRep.callNativeJob (ReaderTransFromRep.java:41)

由于kettle是纯java编辑，所以kettle连接mysql库的时候需要mysql的java连接包，百度下载一个mysql的java连接驱动。

将下载的mysql jdbc包解压，取出mysql-connector-java.jar包（这里驱动包有版本号）。放入kettle的lib目录下面。

3

重新启动kettle。可以测试连接，此时连接已经连上。

---