使用Kettle报错的解决方法
1.当你在navicat上面测试数据库连接的时候可以看到数据库连接成功。而在Kettle上面连接同样的库的时候报出一大段错误出来,这时候是不是感觉有点懵逼了。
错误内容如下:
错误连接数据库 [test库] : com.tyky.di.core.exception.XbridgeDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Connection setting too low for ‘maxAllowedPacket‘. When ‘useServerPrepStmts=true‘, ‘maxAllowedPacket‘ must be higher than 8203. Check also ‘max_allowed_packet‘ in MySQL configuration files.
com.tyky.di.core.exception.XbridgeDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Connection setting too low for ‘maxAllowedPacket‘. When ‘useServerPrepStmts=true‘, ‘maxAllowedPacket‘ must be higher than 8203. Check also ‘max_allowed_packet‘ in MySQL configuration files.
at com.tyky.di.core.database.Database.normalConnect(Database.java:374)
at com.tyky.di.core.database.Database.connect(Database.java:323