A service deployed in the server docker reported the following error when connecting to the database:
I have searched a lot of information on the Internet, but I can’t solve it by trying various ways,
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.
The specific error information is as follows:
ERROR com.alibaba.druid.pool.DruidDataSource – create connection SQLException, url: jdbc:mysql ://10.10.20.16:3306/acs?& amp; 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.
Cause of error:
It may be due to the different versions of JDK. This error message is probably caused by the SSL protocol of MySQL
solution: I tried to remove SSLv3 from java.security in jdk-8 on my local machine and restart the service, but I still couldn’t solve it
finally, add this to the MySQL connection string in the service configuration; Usessl = false, that is, disable SSL, problem solved
Read More:
- com.alibaba.druid.pool.DruidDataSource error Warning: init datasource error
- [Solved] javax.management.InstanceNotFoundException: com.alibaba.druid:type=DruidDataSourceStat
- How to Solve ERROR – unregister mbean error javax.management.InstanceNotFoundException: com.alibaba.druid:type=
- Calling Dubbo Service reported the following error (com.alibaba.dubbo.remoting.RemotingException) Causes and Solutions
- Request processing failed; nested exception is com.alibaba.fastjson.JSONException: can not cast to J
- [Solved] fastjson Error: com.alibaba.fastjson.JSONObject cannot be cast to xxxx
- Spring Boot Druid Error: discard long time none received connection
- Gradle Package Project Lombok Not Working: No serializer found for class com.qbb.User and no properties discovered to create BeanSerializer……
- JMeter JDBC Error: No pool found named: ‘test‘ [How to Solve]
- [Solved] Jmeter Connect Database Error: Cannot create PoolableConnectionFactory
- [Solved] jedis Error: Could not get a resource from the pool
- [Solved] Error: failed to create deliver client: orderer client failed to connect to orderer.example.com:7050
- [Solved] Consul Error: github.com/boltdb/bolt github.com/boltdb/bolt github.com/hashicorp/raft-boltdb
- [Solved] Druid register MBean error: ERROR [com.alibaba.druid.stat.DruidDataSourceStatManager]
- AN ERROR MESSAGE APPEARS WHEN TOMCAT DEPLOYS A NEW PROJECT: INVALID BYTE TAG IN CONSTANT POOL: 15
- cannot create windows service for mysql. error:0 [How to Solve]
- How to Fix Error when integrating spring cloud openfeign with spring cloud Alibaba
- [Solved] ArcGIS Error: Failed to create the site. One or more server machines could not be stopped
- NPM install -g create-react-app [How to Solve]
- Error Report of Yarn Create UMI