CannotGetJdbcConnectionException：Failed to obtain JDBC Connection

最新推荐文章于 2024-05-23 14:34:59 发布
最新推荐文章于 2024-05-23 14:34:59 发布
阅读量1.8k 收藏
点赞数
分类专栏： Java后端
原文链接：https://blog.csdn.net/gwd1154978352/article/details/83242578
版权

异常如下：


 
 
  1. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Exception 
     
     in thread 
     
     "pool-3-thread-2" org.mybatis.spring.MyBatisSystemException: nested exception 
     
     is org.apache.ibatis.exceptions.PersistenceException: 
    
    
    
   
   
  2. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     ### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    
    
   
   
  3. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
     
    
    
    
   
   
  4. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     The last packet successfully received 
     
     from the server was 
     
     1,
     
     610 milliseconds ago.  The last packet sent successfully to the server was 
     
     1,
     
     583 milliseconds ago.
    
    
    
   
   
  5. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    
    
   
   
  6. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
     
    
    
    
   
   
  7. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     The last packet successfully received 
     
     from the server was 
     
     1,
     
     610 milliseconds ago.  The last packet sent successfully to the server was 
     
     1,
     
     583 milliseconds ago.
    
    
    
   
   
  8. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:
     
     77)
    
    
    
   
   
  9. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:
     
     446)
    
    
    
   
   
  10. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.sun.proxy.$Proxy59.insert(Unknown Source)
    
    
    
   
   
  11. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:
     
     278)
    
    
    
   
   
  12. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:
     
     58)
    
    
    
   
   
  13. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:
     
     59)
    
    
    
   
   
  14. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.sun.proxy.$Proxy68.insertSelectiveList(Unknown Source)
    
    
    
   
   
  15. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.gwd.movie.service.impl.AnalyzeMovieHtmlServiceImpl.getView(AnalyzeMovieHtmlServiceImpl.java:
     
     111)
    
    
    
   
   
  16. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.gwd.movie.service.impl.AnalyzeMovieHtmlServiceImpl.getDoc(AnalyzeMovieHtmlServiceImpl.java:
     
     127)
    
    
    
   
   
  17. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.gwd.movie.service.impl.AnalyzeMovieHtmlServiceImpl.getTitleDetailUrl(AnalyzeMovieHtmlServiceImpl.java:
     
     214)
    
    
    
   
   
  18. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.gwd.movie.service.impl.AnalyzeMovieHtmlServiceImpl$
     
     1.run(AnalyzeMovieHtmlServiceImpl.java:
     
     189)
    
    
    
   
   
  19. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    
    
    
   
   
  20. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    
    
    
   
   
  21. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.lang.Thread.run(Unknown Source)
    
    
    
   
   
  22. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Caused by: org.apache.ibatis.exceptions.PersistenceException: 
    
    
    
   
   
  23. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     ### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    
    
   
   
  24. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
     
    
    
    
   
   
  25. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     The last packet successfully received 
     
     from the server was 
     
     1,
     
     610 milliseconds ago.  The last packet sent successfully to the server was 
     
     1,
     
     583 milliseconds ago.
    
    
    
   
   
  26. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    
    
   
   
  27. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
     
    
    
    
   
   
  28. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     The last packet successfully received 
     
     from the server was 
     
     1,
     
     610 milliseconds ago.  The last packet sent successfully to the server was 
     
     1,
     
     583 milliseconds ago.
    
    
    
   
   
  29. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:
     
     30)
    
    
    
   
   
  30. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:
     
     200)
    
    
    
   
   
  31. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:
     
     185)
    
    
    
   
   
  32. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
    
    
   
   
  33. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    
    
    
   
   
  34. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    
    
    
   
   
  35. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.lang.reflect.Method.invoke(Unknown Source)
    
    
    
   
   
  36. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:
     
     433)
    
    
    
   
   
  37. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	... 
     
     12 more
    
    
    
   
   
  38. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception 
     
     is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    
    
   
   
  39. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
     
    
    
    
   
   
  40. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     The last packet successfully received 
     
     from the server was 
     
     1,
     
     610 milliseconds ago.  The last packet sent successfully to the server was 
     
     1,
     
     583 milliseconds ago.
    
    
    
   
   
  41. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:
     
     81)
    
    
    
   
   
  42. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:
     
     82)
    
    
    
   
   
  43. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:
     
     68)
    
    
    
   
   
  44. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:
     
     338)
    
    
    
   
   
  45. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:
     
     84)
    
    
    
   
   
  46. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:
     
     49)
    
    
    
   
   
  47. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:
     
     117)
    
    
    
   
   
  48. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:
     
     76)
    
    
    
   
   
  49. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:
     
     198)
    
    
    
   
   
  50. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	... 
     
     18 more
    
    
    
   
   
  51. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    
    
   
   
  52. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
     
    
    
    
   
   
  53. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     The last packet successfully received 
     
     from the server was 
     
     1,
     
     610 milliseconds ago.  The last packet sent successfully to the server was 
     
     1,
     
     583 milliseconds ago.
    
    
    
   
   
  54. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
    
    
   
   
  55. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    
    
    
   
   
  56. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    
    
    
   
   
  57. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    
    
    
   
   
  58. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.Util.handleNewInstance(Util.java:
     
     425)
    
    
    
   
   
  59. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:
     
     990)
    
    
    
   
   
  60. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:
     
     201)
    
    
    
   
   
  61. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:
     
     4914)
    
    
    
   
   
  62. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:
     
     1663)
    
    
    
   
   
  63. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:
     
     1224)
    
    
    
   
   
  64. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:
     
     2199)
    
    
    
   
   
  65. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:
     
     2230)
    
    
    
   
   
  66. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:
     
     2025)
    
    
    
   
   
  67. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:
     
     778)
    
    
    
   
   
  68. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:
     
     47)
    
    
    
   
   
  69. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
    
    
   
   
  70. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    
    
    
   
   
  71. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    
    
    
   
   
  72. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    
    
    
   
   
  73. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.Util.handleNewInstance(Util.java:
     
     425)
    
    
    
   
   
  74. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:
     
     386)
    
    
    
   
   
  75. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:
     
     330)
    
    
    
   
   
  76. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:
     
     1408)
    
    
    
   
   
  77. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:
     
     1464)
    
    
    
   
   
  78. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:
     
     684)
    
    
    
   
   
  79. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:
     
     991)
    
    
    
   
   
  80. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:
     
     987)
    
    
    
   
   
  81. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:
     
     103)
    
    
    
   
   
  82. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:
     
     151)
    
    
    
   
   
  83. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:
     
     115)
    
    
    
   
   
  84. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:
     
     78)
    
    
    
   
   
  85. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	... 
     
     26 more
    
    
    
   
   
  86. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Caused by: javax.net.ssl.SSLException: java.lang.SecurityException: JCE cannot authenticate the provider SunJCE
    
    
    
   
   
  87. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.Alerts.getSSLException(Unknown Source)
    
    
    
   
   
  88. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
    
    
    
   
   
  89. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
    
    
    
   
   
  90. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.handleException(Unknown Source)
    
    
    
   
   
  91. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    
    
    
   
   
  92. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    
    
    
   
   
  93. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:
     
     186)
    
    
    
   
   
  94. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	... 
     
     50 more
    
    
    
   
   
  95. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Caused by: java.lang.SecurityException: JCE cannot authenticate the provider SunJCE
    
    
    
   
   
  96. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at javax.crypto.Cipher.getInstance(Cipher.java:
     
     657)
    
    
    
   
   
  97. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature$Delegate.newInstance(Unknown Source)
    
    
    
   
   
  98. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature$Delegate.chooseProvider(Unknown Source)
    
    
    
   
   
  99. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature$Delegate.engineInitVerify(Unknown Source)
    
    
    
   
   
  100. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature.initVerify(Unknown Source)
    
    
    
   
   
  101. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.RSASignature.engineInitVerify(Unknown Source)
    
    
    
   
   
  102. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature$Delegate.init(Unknown Source)
    
    
    
   
   
  103. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature$Delegate.chooseProvider(Unknown Source)
    
    
    
   
   
  104. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature$Delegate.engineInitVerify(Unknown Source)
    
    
    
   
   
  105. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at java.security.Signature.initVerify(Unknown Source)
    
    
    
   
   
  106. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.HandshakeMessage$DH_ServerKeyExchange.<init>(Unknown Source)
    
    
    
   
   
  107. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source)
    
    
    
   
   
  108. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.Handshaker.processLoop(Unknown Source)
    
    
    
   
   
  109. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.Handshaker.process_record(Unknown Source)
    
    
    
   
   
  110. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
    
    
    
   
   
  111. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
    
    
    
   
   
  112. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	... 
     
     53 more
    
    
    
   
   
  113. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Caused by: java.util.jar.JarException: Class 
     
     is on the bootclasspath
    
    
    
   
   
  114. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at javax.crypto.JarVerifier.verify(JarVerifier.java:
     
     286)
    
    
    
   
   
  115. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at javax.crypto.JceSecurity.verifyProviderJar(JceSecurity.java:
     
     164)
    
    
    
   
   
  116. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at javax.crypto.JceSecurity.getVerificationResult(JceSecurity.java:
     
     190)
    
    
    
   
   
  117. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	at javax.crypto.Cipher.getInstance(Cipher.java:
     
     653)
    
    
    
   
   
  118. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     	... 
     
     68 more
    
    
    
   
   
  119. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Sun Oct 
     
     21 
     
     16:
     
     25:
     
     41 CST 
     
     2018 WARN: Establishing SSL connection without serve
     
     r's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance 
     
     with existing applications 
     
     not using SSL the verifyServerCertificate property 
     
     is set to 
     
     'false'. You need either to explicitly disable SSL by setting useSSL=false, 
     
     or set useSSL=true 
     
     and provide truststore 
     
     for server certificate verification.
    
    
    
   
   
  120. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Sun Oct 
     
     21 
     
     16:
     
     25:
     
     42 CST 
     
     2018 WARN: Establishing SSL connection without serve
     
     r's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance 
     
     with existing applications 
     
     not using SSL the verifyServerCertificate property 
     
     is set to 
     
     'false'. You need either to explicitly disable SSL by setting useSSL=false, 
     
     or set useSSL=true 
     
     and provide truststore 
     
     for server certificate verification.
    
    
    
   
   
  121. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Sun Oct 
     
     21 
     
     16:
     
     25:
     
     42 CST 
     
     2018 WARN: Establishing SSL connection without serve
     
     r's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance 
     
     with existing applications 
     
     not using SSL the verifyServerCertificate property 
     
     is set to 
     
     'false'. You need either to explicitly disable SSL by setting useSSL=false, 
     
     or set useSSL=true 
     
     and provide truststore 
     
     for server certificate verification.
    
    
    
   
   
  122. 
   
   
    
    
    
    
   
   
    
   
   
    
    
    
    
     
     Sun Oct 
     
     21 
     
     16:
     
     25:
     
     42 CST 
     
     2018 WARN: Establishing SSL connection without serve
     
     r's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance 
     
     with existing applications 
     
     not using SSL the verifyServerCertificate property 
     
     is set to 
     
     'false'. You need either to explicitly disable SSL by setting useSSL=false, 
     
     or set useSSL=true 
     
     and provide truststore 
     
     for server certificate verification.

 

解决方案：

原

spring.datasource.url=jdbc:mysql://xx.xx.xx.xx/XX?characterEncoding=UTF-8

加上&useSSL=false

spring.datasource.url=jdbc:mysql:/xx.xx.xx.xx/XX?characterEncoding=UTF-8&useSSL=false

 

MainJay
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
dbcp 连接池不合理的锁导致连接耗尽解决方案
01-20
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a ...
SpringBoot数据访问CannotGetJdbcConnectionException: Failed to obtain JDBC Connection异常的解决方式。
Tec_Xie的博客
08-16 1万+
今天在学习SpingBoot2数据访问，在整合JDBC访问mysql数据库测试时出现了以下异常。 项目能够正常启动，但就是测试的时候出现无法与JDBC连接。 org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'root'@...
Failed to obtain JDBC Connection； nested exception is java.sql.SQLException
magic_818的博客
02-04 1万+
Failed to obtain JDBC Connection； nested exception is java.sql.SQLException
mysql连接获取超时问题初探
最新发布
05-23 255
如果是因为定时任务锁表，那可能后面几天 （19号，20号...）都应该报错才是，但只有18日报错，不能理解。这个表的数据量也比较大，删除任务针对13天前的数据进行删除 （有时20-50w左右的数据量）。但分析报错的sql发现都是操作的同一个表，有定时任务对表的删除，有新请求对表的写入、更新。需要在看下操作系统级别的日志 （/var/log/message）---未完待续...在看对应目录下的日志文件，发现5月18日凌晨有异常关闭，为什么关闭了？
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection；
Ethereal的博客
10-27 2万+
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection；的原因分析以及解决方法。连接Mysql数据库时在 url 后面加上 useSSL=false 的作用。
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
热门推荐
just_coming_here的博客
03-20 4万+
完整报错 Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000,...
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not b
ShiXinXin_Harbour的博客
09-23 2万+
报错信息: Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlyi...
Springboot+MySQL，出现Could not get JDBC Connection
12-14
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO) ...
spring boot整合mybatis连接不上数据库
12-14
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using ...
mybatis连接MySQL8出现的问题解决方法
08-26
之前MyBatis自动生成的代码都是正常的，但是在测试类中使用Connection进行连接测试并查询数据库时，也是能够正常查询到数据的。 解决方法 解决这个问题的关键是升级mysql-connect-java版本。从MySQL5.1.6升级到...
Apache Commons DbUtils 1.6 API
05-21
通过`DbUtils.rethrowCannotGetJdbcConnectionException()`方法，DbUtils将JDBC连接问题封装为`CannotGetJdbcConnectionException`，这有助于快速识别和解决问题。 8. **兼容性**： Apache Commons DbUtils 1.6 ...
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested
lijiahao2000的博客
03-11 1万+
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Un...
Failed to obtain JDBC Connection； nested exception is com.mysql.cj.jdbc.exceptions.
qq_44827847的博客
10-07 5718
jdbc连接报错
Failed to obtain JDBC Connection； nested exception is java.sql.SQLException: Access denied for user
qq_45950279的博客
08-06 3万+
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user root @ localhost (using password: YES)
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection； nested
weixin_55229531的博客
06-07 1万+
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30015ms.
Failed to obtain JDBC Connection； nested exception is java.sql.SQLException: The server time zone va
张晨光老师的播客
08-29 1万+
如果以上方法都无法解决问题，建议参考数据库和驱动程序的官方文档，或者联系相关的技术支持以获取更具体的帮助。使用时区偏移：如果你确定服务器和客户端的时区存在偏差，你可以在客户端代码中使用时区偏移来调整时间。确认 JDBC 驱动程序：确保你使用的 JDBC 驱动程序与数据库版本兼容，并且正确配置。检查配置文件或代码：检查你的配置文件或代码，确保连接字符串中的时区设置正确。检查系统时区设置：确保你的系统时区设置正确。在运行数据库连接的应用程序或服务所在的操作系统中，检查系统时区设置。
记一次MySQL创建数据库连接时提示数据库超时问题
Huiger1234的博客
04-25 7929
首先看一下报错信息： Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConne..
Failed to obtain JDBC Connection； nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsExc
RavenWE的博客
11-22 1万+
报错： Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback. Mon Nov 22 22:40:40 CST 2021 There was an unexpected error (type=Internal Server Error, status=500). nested exception is org.apache..
CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
09-10
这个异常通常表示无法获取到 JDBC 连接。这个问题可能由以下几个原因引起： 1. 数据库连接配置错误：请确保数据库连接的 URL、用户名和密码是正确的，并且数据库服务是启动的。可以尝试通过命令行或其他工具测试...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值