MySQL 5.7

链接url:jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8

主要报错如下:

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,720 milliseconds ago.  The last packet sent successfully to the server was 1,709 milliseconds ago.

Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors

 

造成这个报错可能的原因是链接地址中的 useSSL=true 造成的。

 useSSL=true 改为  useSSL=false 即可解决。

(把这个 useSSL=true& 删除也可以解决,不过会有一个警告。)

 

记录一下,希望可以帮助碰到同样问题的朋友。