mysql异常报错处理

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1044 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3178)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
	org.hibernate.loader.Loader.getResultSet(Loader.java:1787)

解决方法：

打开数据库  执行sql语句：
  set global max_allowed_packet = 50 * 1024 * 1024;
  show VARIABLES like '%max_allowed_packet%';