Kettle連接數據庫失敗

• 2021 年 3 月 11 日
• 筆記
• JAVA, Python

Kettle是使用Java開發，開源的一款ETL工具，這裡記錄一下關於Kettle有關於數據庫連接的問題

1、mysql版本需要注意區分，在mysql8.0的文檔中官方已經給出，使用caching_sha2_password作為首選身份驗證插件，

同時，官方也給出解決方案

kettle連接數據庫問題及解決方法：

1、錯誤連接數據庫 [111] : 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

解決方案：這樣的報錯是因為缺少連接數據庫的jar包，在mysql官網下載一個jar包，將其放置到kettle安裝目錄下的lib文件夾下即可。然後重啟kettle即可解決

2、錯誤連接數據庫 [222] : 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

解決方案：這是因為jar包的不兼容造成，不兼容原因在文章開頭已經給出，mysql-connector-java-5.1.48-bin.jar是可以解決這種兼容性問題的，所以只要到官網下載這個版本的jar包將其放置到kettle安裝目錄下的lib文件夾內，然後重啟kettle即可解決