在动用JDBC连接mysql时大概会遇上以下错误:

MySql的Communications link failure化解办法,mysqllinkfailure

在使用JDBC连接mysql时可能会遇上以下错误:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
link failure

The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server

缓慢解决方式:

String url = “jdbc:mysql://192.168.xxx.xxx:3306/db”;
此处的IP部分增添到hosts文件中,并动用hosts中安装的名目进行一而再。 例:
String url = “jdbc:mysql://127.0.0.1:3306/db”; 变为
String url = “jdbc:mysql://localhost:3306/db”;     练习一下罗马尼亚(罗曼ia)语: This
error may encountered when using JDBC to connect Mysql:

  com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure

  The last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server

sulotions:

You need add target IP to your hosts file and name it.

make String url = “jdbc:mysql://192.168.xxx.xxx:3306/db”;
 be 
String url = “jdbc:mysql://hostname:3306/db”;**

example:

String url = “jdbc:mysql://127.0.0.1:3306/db”; change to
String url = “jdbc:mysql://localhost:3306/db”;

link
failure化解办法,mysqllinkfailure
在行使JDBC连接mysql时或者会碰到以下错误:
com.mysql.jdbc.exceptions.jdbc四.CommunicationsException…

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
link failure

The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server

化解方法:

String url = “jdbc:mysql://192.168.xxx.xxx:3306/db”;

这里的IP部分增添到hosts文件中,并选用hosts中装置的名号进行连接。

例:

String url = “jdbc:mysql://127.0.0.1:3306/db”;

变为

String url = “jdbc:mysql://localhost:3306/db”;