kettle 驱动 java kettle 数据库驱动

转载

数据小筑 2023-12-16 21:40:35

文章标签 kettle 驱动 java mysql big data sqlserver 数据库 文章分类 Java 后端开发

一、背景

领导要求使用kettle，把sqlsever数据同步到mysql,于是想到了kettle工具还可以配置增量同步和定时同步。结果连接就花了很久时间，自己是个萌新不太熟悉操作，哈哈哈，各位大神别嫌弃，就记录一下过程，第一次写文章不要介意水平，只是告诉自己有些小错误确实容易忽视。

起初报错代码情况如下：

[fee_query] : org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

。。。

一开始以为是没有安装驱动或者驱动版本不对
去官网下载对应的驱动，链接如下
1、https://dev.mysql.com/downloads/
点击Connector/J

kettle 驱动 java kettle 数据库驱动_kettle 驱动 java

点击"Looking for previous GA versions?"
下载后解压，将
mysql-connector-java-5.1.49.jar放入data-integration\lib下即可解决问题

2、下载不了或者网速慢可以这里下载：

https://mvnrepository.com/artifact/mysql/mysql-connector-java

kettle 驱动 java kettle 数据库驱动_数据库_02

二、千万不要下载新版本的驱动

mysql-connector-java-8.0.26.jar依然会提示找不到驱动，我们需要的org.gjt.mm.mysql.Driver，所以便去查看了下jar包，解压mysql-connector-java-5.1.49.jar这个包后发现，根本没有org\gjt\mm\mysql\Driver.class这个类，因此新版本并不适用于kettle(v9.0.0.0)
解压mysql-connector-java-5.1.49.jar后可以看到有
org\gjt\mm\mysql\Driver.class这个类

放到Kettle安装目录下：D:\kettle\data-integration\lib

下载jar包：mysql-connector-java-5.1.15-bin.jar

重启Spoon.bat问题解决.

三、重启Spoon.bat问题还没有解决

于是找资料发现这个版本限制问题，我就安装一堆对应的版本尝试，结果错误还是依旧，装高版本还报新的错误，直接裂开，这个报错就是没有驱动，之前那个怀疑是版本问题。

错误连接数据库 [tcc] : 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
at org.pentaho.di.core.database.Database.normalConnect(Database.Java:428)
at org.pentaho.di.core.database.Database.connect(Database.java:358)
at org.pentaho.di.core.database.Database.connect(Database.java:311)
at org.pentaho.di.core.database.Database.connect(Database.java:301)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2686)

玩了一下午驱动包，总共不止这些。

kettle 驱动 java kettle 数据库驱动_sqlserver_03