【BUG】MySQL—— Packet for query is too large

Mysql Text字段的大小

TINYTEXT 256 bytes
TEXT 65,535 bytes ~64kb
MEDIUMTEXT 16,777,215 bytes ~16MB
LONGTEXT 4,294,967,295 bytes ~4GB

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (21982962 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3291)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1983)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
	at JDBCText.textToDB(JDBCText.java:39)
	at JDBCText.main(JDBCText.java:101)

找到mysql的my.ini配置文件 修改max_allowed_packet大小