The last packet sent successfully to the server was 0 milliseconds ago. The driver has no received any packets from the server. (about JDBC)

0  from the server.

Today the operation of the database large database access to the problem, is roughly the database connection buffer pool problem, get a half-day of MySQL (Ubuntu).

Workaround:
(1) using the AutoReConnect attribute in the JDBC URL, the URL is added

&autoreconnect=true&failoverreadonly=false
For example:

String URL = "Jdbc:mysql://localhost:3306/mxmanage&autoreconnect=true&failoverreadonly=false";

(2) Modify the MySQL parameters. /ETC/MY.CNF add

[mysqld]wait_timeout=31536000interactive_timeout=31536000

(3) Restart MySQL

Service MySQL Restart

Cause Analysis:
(1) MySQL connection connection may fail in a large number of data access cases
(2) long time may ask, connection will fail

The last packet sent successfully to the server was 0 milliseconds ago. The driver has no received any packets from the server. (about JDBC)