当前位置: 澳门新濠3559 > 数据库 > 正文

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

时间:2019-11-29 07:15来源:数据库
澳门新濠3559,在使用JDBC连接mysql时可能会遇到以下错误: 使用druid连接池连接数据库,出现了以下问题,忘各位大神解答 com.mysql.jdbc.exceptions.jorg.apache.ibatis.exceptions.PersistenceException: c

澳门新濠3559,在使用JDBC连接mysql时可能会遇到以下错误:

使用druid连接池连接数据库,出现了以下问题,忘各位大神解答
com.mysql.jdbc.exceptions.jorg.apache.ibatis.exceptions.PersistenceException:

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

Error updating database. Cause: 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.

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

Cause: 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";

 

 

练习一下英语:

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

编辑:数据库 本文来源:在使用JDBC连接mysql时可能会遇到以下错误

关键词: