A ResourcePool could not acquire a resource from its primary factory or source

最新推荐文章于 2022-01-05 13:45:03 发布
最新推荐文章于 2022-01-05 13:45:03 发布
阅读量335 收藏
点赞数
分类专栏： spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiaoxiamimm/article/details/113788640
版权
本文介绍了在整合Spring、Spring MVC与MyBatis的项目中，遇到的Spring Transaction无法创建交易和C3P0连接池资源获取失败的异常，通过详细分析和解决步骤，帮助开发者避免此类问题。
摘要由CSDN通过智能技术生成 
10-Feb-2021 13:27:47.697 严重 [http-nio-8080-exec-4] org.apache.catalina.core.StandardWrapperValve.invoke 在路径为/itheima_ssm_war_exploded的上下文中，Servlet[DispatcherServlet]的Servlet.service（）引发了具有根本原因的异常Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	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)
		at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
		at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:262)
		at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
		at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:474)
		at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:289)
		at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
		at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
		at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
		at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
		at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
		at com.sun.proxy.$Proxy19.save(Unknown Source)

如果遇到这个情况，请大家自己再建立项目，这个应该跟配置文件的头信息不一样有关，我是导入别人的项目才会出现这样的情况，我后面自己建立项目就不会有这样的情况了

小主早安
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
A ResourcePool could not acquire a resource from its primary factory or source.
有上进心的阿龙
11-06 976
D:\install\jdk18\corretto-1.8.0_302\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 “-javaagent:D:\install\JetBrains\IntelliJ IDEA 2021.2.2\lib\idea_rt.jar=56331:D:\install\JetBrains\IntelliJ IDEA 2021.2.2\bin” -Dfile.encoding=UTF-8 -classpath “D:\
数据库连接错误集锦A ResourcePool could not acquire a resource from its primary factory or source
热门推荐
oldbig_lin的博客
08-03 5万+
在github上fork别人的项目到本地，测试时首先要创建数据库，然后修改数据库配置的信息（密码等） 今天在测试一个项目时出现A ResourcePool could not acquire a resource from its primary factory or source错误，百度了一下，可能是以下几个原因 1，驱动配置有误：driver=com.mysql.jdbc.Dri
【数据库】 A ResourcePool could not acquire a resource from its primary factory or source.
zzf_forgot的博客
08-28 792
我在链接数据库的时候报了这个错误，具体错误截图如下： Could not open JDBC Connection for transaction; 总之就是连接数据库的时候出现了问题： 解决步骤： 1.检查db.properties文件各个参数是否书写正确； 2.检查该文件的KV对是否有空格（这个细节非常坑！） 一定要用鼠标检查每一行是否有多出空格！ ...
关于A ResourcePool could not acquire a resource from its primary factory or source.等报错的解决
weixin_43234165的博客
07-10 1055
JAVAWeb项目发布到服务器时，控制台报错如下： 严重: Servlet.service() for servlet [springmvc] in context with path [/Atcrowdfunding-main] threw exception [Request processing failed; nested exception is org.springframework...
A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
最新发布
07-27
引用\[1\]和\[2\]中提到了一个错误信息，即"A ResourcePool could not acquire a resource from its primary factory or source"。这个错误通常是由于数据库连接池无法从其主要工厂或源获取连接而引起的。引用\[3\]...
Connections could not be acquired from the underlying database
无知人生，记录点滴
12-27 4万+
严重: StandardWrapper.Throwableorg.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections co
解决：Connections could not be acquired from the underlying database!
regimental的专栏
01-25 709
公司老项目连接EnterpriseDB （edb）数据库，因为是老项目，开发环境是： 1，jdk6 2，spring3 3，连接edb 接手后项目启动报错如下： org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; ...
使用c3p0连接池连接数据库时出现：Connections could not be acquired from the underlying database!
gaohanjie123的博客
05-10 1271
当使用c3p0连接数据库时，配置信息都没有错误，但是出现了如下情况： 下列信息中有一行是java.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! 也就是连接数据库失败 D:\sofeware\JDK8\JDK8installer\bin\java.exe -ea -Didea.test.cyclic.buffer.size=104
A ResourcePool could not acquire a resource from its primary factory or source异常解决
一一哥
05-12 2551
A ResourcePool could not acquire a resource from its primary factory or source异常解决 一. 异常问题 我在给别人做项目的时候，我自己本地连接的数据库是5.7，用的mysql-connector-java的驱动包是5.x版本的，然后对方的环境中mysql是8.0. 结果在启动程序后，在用户登录，第一次连接数据库时，就产生了如下异常信息： ...... A ResourcePool could not acquire ..
处理 A ResourcePool could not acquire a resource from its primary factory or source.
y15201653575的博客
03-04 4469
遇到 A ResourcePool could not acquire a resource from its primary factory or source.这个问题，花了很多时间去查找，解决，报错如下：org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.excep...
数据库连接错误（A ResourcePool could not acquire a resource from its primary factory or sour）
漫
05-22 9610
一：控制台报出的错误提示：A ResourcePool could not acquire a resource from its primary factory or sour 二：产生原因：数据库连接配置有误，密码有空格导致的，（因为密码是我粘贴过来的） 三：解决方案：逐一排查，用户名，密码，URL和Driver,发现密码的value后有空格，再次仔细粘贴，登录系统成功！
【已解决】A ResourcePool could not acquire a resource from its primary factory or source
记录学习的历程
01-05 1554
报错异常 A ResourcePool could not acquire a resource from its primary factory or source No timezone mapping entry for 'UTC; 首先在CSDN搜索了一番 CSDN文章：数据库连接错误集锦 然后，发现我的没有错，但还是报错 后来才明白，我之前把“mysql-connector-java-5.0.30-bin.jar”换到了更高的版本“mysql-connector-java-5.1.30-b.
数据库连接异常（A ResourcePool could not acquire a resource from its primary factory or source.）
naumy的博客
07-03 4369
数据库连接异常 （A ResourcePool could not acquire a resource from its primary factory or source.） 生为小白的我总结以下五种常见发生这种异常信息的类型，先检查数据库是否启动了，不过MySQL数据库一般都会启动，哈哈！！ 1.mysql的驱动包 与数据库的版本不一致 驱动下载链接: https://dev.mysql.com/downloads/. 比如我用的MySQL数据库是8.0.17版本，那么我的连接驱动最好也用8.0的
解决：CannotAcquireResourceException: A ResourcePool could notacquire a resource from its primary fa......
weixin_34268843的博客
07-18 715
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! Caused by: com.mchange.v2.resourcepool.CannotAcquireReso...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值