系统使用一段时间之后，数据库连接超时问题排查：sql.jdbc.exceptions.jdbc4.CommunicationsException Communications link failure

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

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

​	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
​	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
​	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
​	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
​	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
​	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
​	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
​	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4914)
​	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
​	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
​	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
​	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
​	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
​	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
​	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
​	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
​	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
​	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
​	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
​	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
​	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
​	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
​	at java.sql.DriverManager.getConnection(DriverManager.java:664)
​	at java.sql.DriverManager.getConnection(DriverManager.java:247)

解决方法：

对于数据库使用5.7以上版本的

useSSL=false

对于数据库使用5.7以下的版本的使用 比如5.6.44x
useSSL=true

 useSSL=false和true的区别:

 SSL(Secure Sockets Layer 安全套接字协议)，在mysql进行连接的时候,如果mysql的版本是5.7之后的版本必须要加上useSSL=false,mysql5.7以及之前的版本则不用进行添加useSSL=false，会默认为false，一般情况下都是使用useSSL=false，尤其是在将项目部署到linux上时，一定要使用useSSL=false！！！，useSSL=true是进行安全验证，一般通过证书或者令牌什么的，useSSL=false就是通过账号密码进行连接，通常使用useSSL=false！！！