我的kettle是7.1,mysql8.0,已经下载了5.1.48.jar包且存放到lib中,打开kettle成功连接数据库和可以正常执行和预览,但是启动后日志却报错。
报错内容:
2022/09/05 22:03:38 - 表输入.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : An error occurred, processing will be stopped:
2022/09/05 22:03:38 - 表输入.0 - Error occurred while trying to connect to the database
2022/09/05 22:03:38 - 表输入.0 -
2022/09/05 22:03:38 - 表输入.0 - Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2022/09/05 22:03:38 - 表输入.0 - 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.
2022/09/05 22:03:38 - 666 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
2022/09/05 22:03:38 - 666 - Unable to get database metadata from this database connection
问题出在共享数据库连接上。
参考以下运行任务的配置:
REM call-pentaho-job.bat
c:
cd /d "C:\pentaho\data-integration"
call Kitchen.bat /file:"C:\app\my-job.kjb" /level:Detailed /logfile:"C:\app\logs\my-job.txt"
exit
REM
REM schtasks /create /tn "MY-PENTAHO-JOB" /tr ""C:\app\call-pentaho-job.bat"" /ru MYDOMAIN\myuser /sc daily /st 03:00
REM