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

小灰灰 2022-10-22 15:55 222阅读 0赞

**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.  
    at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~\[HikariCP-3.4.5.jar:na\]  
    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~\[HikariCP-3.4.5.jar:na\]  
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~\[HikariCP-3.4.5.jar:na\]  
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) \[HikariCP-3.4.5.jar:na\]  
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) \[HikariCP-3.4.5.jar:na\]  
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) \[HikariCP-3.4.5.jar:na\]  
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) \[HikariCP-3.4.5.jar:na\]  
    at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158) \[spring-jdbc-5.3.4.jar:5.3.4\]  
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116) \[spring-jdbc-5.3.4.jar:5.3.4\]  
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) \[spring-jdbc-5.3.4.jar:5.3.4\]  
    at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) \[mybatis-spring-2.0.2.jar:2.0.2\]  
    at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) \[mybatis-spring-2.0.2.jar:2.0.2\]  
    at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336) \[mybatis-3.5.2.jar:3.5.2\]  
    at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:93) \[mybatis-plus-core-3.2.0.jar:3.2.0\]  
    at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:53) \[mybatis-plus-core-3.2.0.jar:3.2.0\]  
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) \[mybatis-3.5.2.jar:3.5.2\]  
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) \[mybatis-3.5.2.jar:3.5.2\]  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) \[mybatis-3.5.2.jar:3.5.2\]  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) \[mybatis-3.5.2.jar:3.5.2\]  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~\[na:1.8.0\_231\]  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~\[na:1.8.0\_231\]  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~\[na:1.8.0\_231\]  
    at java.lang.reflect.Method.invoke(Method.java:498) ~\[na:1.8.0\_231\]  
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) \[mybatis-spring-2.0.2.jar:2.0.2\]  
    at com.sun.proxy.$Proxy67.insert(Unknown Source) \[na:na\]  
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271) \[mybatis-spring-2.0.2.jar:2.0.2\]  
    at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58) \[mybatis-plus-core-3.2.0.jar:3.2.0\]  
    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61) \[mybatis-plus-core-3.2.0.jar:3.2.0\]  
    at com.sun.proxy.$Proxy71.insert(Unknown Source) \[na:na\]  
    at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.save(ServiceImpl.java:104) \[mybatis-plus-extension-3.2.0.jar:3.2.0\]  
    at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl$$FastClassBySpringCGLIB$$76535273.invoke(<generated>) \[mybatis-plus-extension-3.2.0.jar:3.2.0\]  
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) \[spring-core-5.3.4.jar:5.3.4\]  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) \[spring-aop-5.3.4.jar:5.3.4\]  
    at com.zxf.gulimall.product.service.impl.BrandServiceImpl$$EnhancerBySpringCGLIB$$cc4e1475.save(<generated>) \[classes/:na\]  
    at com.zxf.gulimall.product.GulimallProductApplicationTests.contextLoads(GulimallProductApplicationTests.java:21) \[test-classes/:na\]  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~\[na:1.8.0\_231\]  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~\[na:1.8.0\_231\]  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~\[na:1.8.0\_231\]  
    at java.lang.reflect.Method.invoke(Method.java:498) ~\[na:1.8.0\_231\]  
    at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:688) \[junit-platform-commons-1.7.1.jar:1.7.1\]  
    at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) \[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) \[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149) \[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140) \[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84) \[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:210) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:206) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:131) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:65) ~\[junit-jupiter-engine-5.7.1.jar:5.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at java.util.ArrayList.forEach(ArrayList.java:1257) ~\[na:1.8.0\_231\]  
    at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at java.util.ArrayList.forEach(ArrayList.java:1257) ~\[na:1.8.0\_231\]  
    at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51) ~\[junit-platform-engine-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:108) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:96) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:75) ~\[junit-platform-launcher-1.7.1.jar:1.7.1\]  
    at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:69) ~\[junit5-rt.jar:na\]  
    at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47) ~\[junit-rt.jar:na\]  
    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242) ~\[junit-rt.jar:na\]  
    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70) ~\[junit-rt.jar:na\]  
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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.  
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~\[na:1.8.0\_231\]  
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~\[na:1.8.0\_231\]  
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~\[na:1.8.0\_231\]  
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~\[na:1.8.0\_231\]  
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:342) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:167) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1350) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    ... 103 common frames omitted  
Caused by: javax.net.ssl.SSLException: Unsupported record version Unknown-0.0  
    at sun.security.ssl.InputRecord.checkRecordVersion(InputRecord.java:552) ~\[na:1.8.0\_231\]  
    at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:565) ~\[na:1.8.0\_231\]  
    at sun.security.ssl.InputRecord.read(InputRecord.java:529) ~\[na:1.8.0\_231\]  
    at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975) ~\[na:1.8.0\_231\]  
    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367) ~\[na:1.8.0\_231\]  
    at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395) ~\[na:1.8.0\_231\]  
    at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379) ~\[na:1.8.0\_231\]  
    at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:317) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:97) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:333) ~\[mysql-connector-java-8.0.23.jar:8.0.23\]  
    ... 108 common frames omitted

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:   
\#\#\# Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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 error may exist in com/zxf/gulimall/product/dao/BrandDao.java (best guess)  
\#\#\# The error may involve com.zxf.gulimall.product.dao.BrandDao.insert  
\#\#\# The error occurred while executing an update  
\#\#\# Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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.

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)  
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)  
    at com.sun.proxy.$Proxy67.insert(Unknown Source)  
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)  
    at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58)  
    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)  
    at com.sun.proxy.$Proxy71.insert(Unknown Source)  
    at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.save(ServiceImpl.java:104)  
    at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl$$FastClassBySpringCGLIB$$76535273.invoke(<generated>)  
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)  
    at com.zxf.gulimall.product.service.impl.BrandServiceImpl$$EnhancerBySpringCGLIB$$cc4e1475.save(<generated>)  
    at com.zxf.gulimall.product.GulimallProductApplicationTests.contextLoads(GulimallProductApplicationTests.java:21)  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
    at java.lang.reflect.Method.invoke(Method.java:498)  
    at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:688)  
    at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)  
    at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)  
    at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)  
    at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)  
    at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)  
    at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)  
    at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)  
    at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)  
    at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:210)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:206)  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:131)  
    at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:65)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)  
    at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)  
    at java.util.ArrayList.forEach(ArrayList.java:1257)  
    at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)  
    at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)  
    at java.util.ArrayList.forEach(ArrayList.java:1257)  
    at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)  
    at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)  
    at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)  
    at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)  
    at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)  
    at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)  
    at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:108)  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88)  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54)  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67)  
    at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52)  
    at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:96)  
    at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:75)  
    at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:69)  
    at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)  
    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)  
    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)  
Caused by: org.apache.ibatis.exceptions.PersistenceException:   
\#\#\# Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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.  
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
    at java.lang.reflect.Method.invoke(Method.java:498)  
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)  
    ... 76 more  
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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.  
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)  
    at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)  
    at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)  
    at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)  
    at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:93)  
    at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:53)  
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)  
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)  
    ... 82 more  
Caused by: 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.  
    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.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)  
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)  
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)  
    at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)  
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:342)  
    at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:167)  
    at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1350)  
    at com.mysql.cj.NativeSession.connect(NativeSession.java:157)  
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953)  
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)  
    ... 103 more  
Caused by: javax.net.ssl.SSLException: Unsupported record version Unknown-0.0  
    at sun.security.ssl.InputRecord.checkRecordVersion(InputRecord.java:552)  
    at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:565)  
    at sun.security.ssl.InputRecord.read(InputRecord.java:529)  
    at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)  
    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)  
    at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395)  
    at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379)  
    at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:317)  
    at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188)  
    at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:97)  
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:333)  
    ... 108 more

解决办法

就是在你的url地址加上

?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai

数据库链接配置

spring:
      datasource:
        #MySQL配置
        driverClassName: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.0.216:3306/it_3px?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
        username: root
        password: abc123456