Kettle安装初始化问题

🏆1、Kettle启动闪退:

原因：自己的JDK是16

8.0的Kettle适配JDK1.8

【Spoon.bat 双击后闪退】解决办法 - 知乎

🏆2、KettleDB连接中文命名

Unexpected problem reading shared objects from XML file : null

Error reading information from input stream

Invalid byte 1 of 1-byte UTF-8 sequence.

将

if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m"

修改为

if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms4096m" "-Xmx4096m" "-XX:MaxPermSize=512m" "-Dfile.encoding=UTF-8"

🏆3、Kettle数据抽取中文乱码

2023/09/24 00:40:13 - General - Invalid byte 1 of 1-byte UTF-8 sequence.

解决方式：

set names utf8mb4

Kettle连接不上数据库及中文乱码问题解决_Bug.Remove()的博客-CSDN博客