基于Springboot框架
已解决!
创作者:吴仔汕
部署在服务器docker中的某服务,连接数据库时出现以下报错:
在网上搜过许多资料,尝试各种方式都没法解决,
ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:mysql://10.10.20.16:3306/acs?&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&serverTimezone=Asia/Kolkata, errorCode 0, state 08S01
com.mysql.cj.jdbc.exceptions.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.
具体错误信息也就是以下内容:
ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:mysql://10.10.20.16:3306/acs?&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&serverTimezone=Asia/Kolkata, errorCode 0, state 08S01
com.mysql.cj.jdbc.exceptions.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.
报错原因:
可能是jdk版本不同的问题,这个报错提示估计是要mysql走ssl协议,而导致的
解决办法:我在本地机器试着把jdk-8里面的 java.security 中SSLv3去掉,重启服务,但还是无法解决。
最后,在服务配置里面的mysql连接字符串追加这个,&useSSL=false 也就是禁用ssl,问题解决!
原创作品,转载请标明出处!!
版权声明:本文为Zisson_no_error原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。