kettle连接数据mysql查_Kettle连接MySQL报错的解决方法

使用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)

at com.tyky.di.core.database.Database.connect(Database.java:285)

at com.tyky.di.core.database.