Failed to obtain JDBC Connection； nested exception is java.sql.SQLException: Connections could not b

最新推荐文章于 2024-03-05 09:57:09 发布
最新推荐文章于 2024-03-05 09:57:09 发布
阅读量2.3k 收藏 1
点赞数
文章标签： sql java 搭建ssm
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zaq977684/article/details/120965440
版权

一、搭建ssm项目时插入数据出现错误

java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source)
	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:85)
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2120)
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2143)
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
	... 11 more


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 java.sql.SQLException: Connections could not be acquired from the underlying database!
### The error may exist in file [E:\background\ssm-crud\target\classes\mapper\DepartmentMapper.xml]
### The error may involve com.atguigu.crud.dao.DepartmentMapper.insert
### The error occurred while executing an update
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy23.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
	at com.sun.proxy.$Proxy24.insert(Unknown Source)
	at com.atguigu.crud.test.MapperTest.testCRUD(MapperTest.java:41)
	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.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)
	at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
	at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
	at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
	at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
	at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
### The error may exist in file [E:\background\ssm-crud\target\classes\mapper\DepartmentMapper.xml]
### The error may involve com.atguigu.crud.dao.DepartmentMapper.insert
### The error occurred while executing an update
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	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:433)
	... 37 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
	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)
	... 43 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
	... 51 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 55 more

解决方案：

url加上：useJDBCCompliantTimezoneShift=true&serverTimezone=UTC

注意：

根据版本配置datasource

当connector版本小于6.0 ：

jdbc.driverClass=com.mysql.jdbc.Driver

大于6.0版本：

jdbc.driverClass=com.mysql.cj.jdbc.Driver

飞雪金灵
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
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 password: YES) spring boot中使用mybatis连接mysql数据库时报如上错误，确认配置文件中的密码没问题，但是一直报错，最后在密码上加双引号解决 ———————————————— 版权声明
Failed to obtain JDBC Connection； nested exception，数据库连接问题
m0_52466163的博客
05-26 2953
可能原因：applicationContext文件中引用了jdbc.properties的配置。将applicationContext中的引用改为值。
Failed to obtain JDBC Connection； nested exception is java.sql.SQLTransientConnectionException: mas
最新发布
weixin_73330164的博客
03-05 1880
数据库连接池超载：如果您的应用程序同时向数据库发起大量的连接请求，可能会导致数据库连接池超载。数据库连接配置错误：您可能在应用程序的数据库连接配置中使用了错误的连接信息。请检查您的连接字符串、用户名和密码等连接配置，确保它们是正确的。防火墙或网络问题：防火墙或网络配置可能导致应用程序无法与数据库建立连接。您可以检查防火墙规则和网络设置，确保应用程序可以访问数据库服务器。数据库故障或缓慢：数据库服务器可能发生故障或者出现性能问题。您可以检查数据库服务器的状态，确保它正常运行，并且没有任何网络或性能问题。
外网无法访问HDFS org.apache.hadoop.hdfs.BlockMissingException: Could not obtain block
01-09
1、遇到问题 今天使用自己的电脑，使用外网操作阿里云服务器上的HDFS。 报错  org.apache.hadoop.hdfs.BlockMissingException: Could not obtain block 2、百度结果 参考 https://blog.csdn.net/xiaozhaoshigedasb/article/details/88999595  防火墙记得关掉； 查看DataNode是否启动； 有些数据块是损坏了，可以命令查看 阿里云防火墙已经关闭了 使用 jps 查看本地本地 datanode 启动没问题 使用 hadoop fsck /weblog/log.
dbcp 连接池不合理的锁导致连接耗尽解决方案
01-20
dbcp 连接池不合理的锁导致连接耗尽解决方案 应用报错,表象来看是连接池爆满了。 org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.springframework.jdbc.dataso
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
Failed to obtain JDBC Connection； nested exception is java.sql.SQLException: The server time zone va
张晨光老师的播客
08-29 9489
如果以上方法都无法解决问题，建议参考数据库和驱动程序的官方文档，或者联系相关的技术支持以获取更具体的帮助。使用时区偏移：如果你确定服务器和客户端的时区存在偏差，你可以在客户端代码中使用时区偏移来调整时间。确认 JDBC 驱动程序：确保你使用的 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)
Bug解决：获取JDBC连接失败；嵌套异常是java.sql.SQLException:无法从底层数据库获取连接
lufeia的博客
05-29 1万+
问题描述 Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database! 简单来说就是jdbc连接数据库的时候发生错误了 解决方法 因为这里的连接池用的是c3p0的连接池，properties文件里的参数名不能和连接池的这个参数名一样，否则就报错 代码 连接池 <bean id=
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server time zone va
12-17 9782
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionE...
java.lang.IllegalStateException: OutputStream already obtain
05-17
NULL 博文链接：https://anminer.iteye.com/blog/845067
spring3 + mybatis + maven：junit测试错误
weixin_30301449的博客
06-03 114
org.springframework.beans.factory.BeanDefinitionStoreException: Failed to read candidate component class: file [G:\workspaces\workspace_gmq\springmvc.demo\target\classes\com\gmq\service\impl\UserServi...
SpringMVC笔记（一）-----------原理理解及注解开发
GOV_D的博客
10-31 129
文章目录原理理解dispatchServletdispatchServlet原理代码理解注解开发 原理理解 dispatchServlet dispatchServlet原理 上图为springmvc较为完整的一个流程图，实现表示springmvc框架提供的技术，不需要开发者实现，虚线需要开发者实现 代码理解 1.一个呈现信息的页面 2.web.xml中注册dispatchservlet /只会拦截路径，不会拦截页面（如.jsp.html这些就不会拦截） /*会拦截路径和页面.
京东大牛深入浅出剖析Spring MVC源码与实战应用，带你玩转Java Web
资料免费分享，点击名片
12-11 818
本章将对前面所分析的内容进行总结和回顾。首先总结一下Spring MVC的运行原理，然后通过实际跟踪一个请求 来回顾整个处理过程。第21章总结第22章异步请求。
Failed to obtain JDBC Connection； nested exception is com.mysql.cj.jdbc.exceptions.
qq_44827847的博客
10-07 4312
jdbc连接报错
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException:
weixin_47056195的博客
03-15 1万+
一、 异常信息：Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sq
springboot集成oracle
qq_43583850的博客
03-13 1063
1.pom.xml文件 com.oracle ojdbc8 12.2.0.1 2.下载ojdbc8.jar 3.cmd执行 mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc8 -Dversion=12.2.0.1 -Dpackaging=jar -Dfile=C:/ojdbc8.jar ...
Failed to obtain JDBC Connection； nested exception is java.sql.SQLException: Connections could not
热门推荐
康师傅没有眼泪
05-12 5万+
学习慕课上的一个项目，使用的是Spring+Mybatis+c3po 学习搭建框架。 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: org.sprin...
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: interrupt
08-10
引用和提到了解决"Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: interrupt"错误的方法。根据引用中的建议，可以尝试在database.properties文件中的jdbc.url属性中删除"useSSL=true"或将其改为"useSSL=false"。这种方法可能解决该错误。另外，引用还提到了在jdbc.url中添加"useJDBCCompliantTimezoneShift=true&serverTimezone=UTC"的方法来解决类似的问题。根据这些引用的建议，你可以尝试修改数据库配置文件中的相关设置来解决这个问题。123 #### 引用[.reference_title] - *1* [Failed to obtain JDBC Connection； nested exception is java.sql.SQLException: interrupt (xxl-job)](https://blog.csdn.net/hawinlolo/article/details/112951099)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item] - *2* [Failed to obtain JDBC Connection... nested exception is java.sql.SQLException: Connections could not b](https://blog.csdn.net/qq_50754735/article/details/118965074)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item] - *3* [报错： Failed to obtain JDBC ... nested exception is java.sql.SQLException: The server time....](https://blog.csdn.net/weixin_45678130/article/details/113941434)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item] [ .reference_list ]

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值