com.mysql.jdbc.PacketTooBigException java

Question

I'm having this problem when trying to connect to my database. Change the value of the variable but still this error persists

Value mysql

@@max_allowed_packet
16777216

Java Code

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);

Error :

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.

Modify the my.cnf file on my server

Did you restart MySQL on the server after updating the configuration file? — Gord Thompson
– Gord Thompson, Commented Apr 6, 2016 at 19:01
If, in fact reset mysql, verify the value in the database and the new value appears, but from my jar receipt that error @GordThompson — hateful
– hateful, Commented Apr 6, 2016 at 19:12

Changming Sun · Accepted Answer · 2017-02-21 14:13:07Z

1

The jdbc client, also has a "maxAllowedPacket" setting.

You may set your jdbc url like: jdbc:mysql://192.168.15.1/dbname?useUnicode=true&characterEncoding=UTF-8&maxAllowedPacket=16777216

answered Feb 21, 2017 at 14:13

Changming Sun

9332 gold badges7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

nyedidikeke · Accepted Answer · 2018-03-24 13:17:08Z

0

Had the same error, trying to connect to a MySQL database using DataGrip 2016.1 (from JetBrains).

Troubleshooting further, I've realised that my records entry were wrong; the database password was not correct.

Upon rectification using the correct database password, I no longer encountered the error and was able to connect successfully.

answered Mar 24, 2018 at 13:17

nyedidikeke

7,8188 gold badges48 silver badges65 bronze badges

Collectives™ on Stack Overflow

com.mysql.jdbc.PacketTooBigException java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related