KETTLE连接mysql 8.0.22报错（Error connecting to database: (using class com.mysql.cj.jdbc.Driver)）问题处理

最新推荐文章于 2023-08-18 13:04:18 发布

项目不好干

最新推荐文章于 2023-08-18 13:04:18 发布

阅读量4.1k

点赞数 1

分类专栏： KETTLE 文章标签： mysql jdbc

本文链接：https://blog.csdn.net/q222516/article/details/119056039

版权

本文记录了在使用Kettle连接MySQL 8.0.22时遇到的Error connecting to database错误，主要是由于ClassCastException问题。解决方法是设置连接参数serverTimezone为Asia/Shanghai，经过测试，该方法有效。

摘要由CSDN通过智能技术生成

KETTLE连接mysql 8.0.22报错（Error connecting to database: (using class com.mysql.cj.jdbc.Driver)）问题处理

前言

今天，在使用kettle开发流程时，遇到如下报错：
Error connecting to database [源端mysql库] :org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database

Error connecting to database: (using class com.mysql.cj.jdbc.Driver)
java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database

Error connecting to database: (using class com.mysql.cj.jdbc.Driver)
java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

at org.pentaho.di.core.database.Database.normalConnect(Database.java:440)
at org.pentaho.di.core.database.Database.connect(Database.java:331)
at org.pentaho.di.core.d