java - com.mysql.jdbc.PacketTooBigException java

Question

我在尝试连接到我的数据库时遇到了这个问题。更改变量的值，但仍然存在此错误

值mysql

@@max_allowed_packet
16777216

Java代码

Properties connProps = new Properties();
connProps.put("user", Config.DB_USER);
connProps.put("password", Config.DB_PASS);
this._conn = DriverManager.getConnection("jdbc:" + Config.DB_DBMS + "://" + Config.DB_HOST + ":"
  + Config.DB_PORT + "/" + Config.DB_NAME, connProps);

错误:

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

修改我服务器上的my.cnf文件

Answer 1

jdbc 客户端也有一个“maxAllowedPacket”设置。

您可以像这样设置您的 jdbc url:jdbc:mysql://192.168.15.1/dbname?useUnicode=true&characterEncoding=UTF-8&maxAllowedPacket=16777216