Connections could not be acquired from the underlying database! Tomcat服务器启动速度异常

最新推荐文章于 2023-10-22 20:09:43 发布
最新推荐文章于 2023-10-22 20:09:43 发布
阅读量1.2k 收藏
点赞数
分类专栏： 数据库 后端研发 文章标签： spring和Hibernate的整合
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sinat_36203404/article/details/78320399
版权
16:35:46,899 ERROR JDBCExceptionReporter:234 - Connections could not be acquired from the underlying database!
16:36:16,557 ERROR JDBCExceptionReporter:234 - Connections could not be acquired from the underlying database!
16:36:16,559 ERROR SchemaUpdate:175 - could not get database metadata
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.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:863)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:782)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:188)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1545)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1483)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:589)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
    at com.OA.officeAuto.SpringTest.<init>(SpringTest.java:16)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at org.junit.runners.BlockJUnit4ClassRunner.createTest(BlockJUnit4ClassRunner.java:209)
    at org.junit.runners.BlockJUnit4ClassRunner$1.runReflectiveCall(BlockJUnit4ClassRunner.java:258)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
    at org.junit.runners.BlockJUnit4ClassRunner.methodBlock(BlockJUnit4ClassRunner.java:255)
    at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
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)
    ... 46 more
16:36:16,564 ERROR SchemaUpdate:222 - could not complete schema update
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.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:863)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:782)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:188)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1545)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1483)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:589)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
    at com.OA.officeAuto.SpringTest.<init>(SpringTest.java:16)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at org.junit.runners.BlockJUnit4ClassRunner.createTest(BlockJUnit4ClassRunner.java:209)
    at org.junit.runners.BlockJUnit4ClassRunner$1.runReflectiveCall(BlockJUnit4ClassRunner.java:258)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
    at org.junit.runners.BlockJUnit4ClassRunner.methodBlock(BlockJUnit4ClassRunner.java:255)
    at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
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)
    ... 46 more

org.hibernate.impl.SessionFactoryImpl@349319d9


这是我对sessionFactory的测试，看似也能输出结果，但是在其过程中会报出异常


其原因是你的properties中的文件有一项username的换个其他的名字，原因可能是JVM在运行过程中可能无法识别。

换个其他的名字。

接下来的解决办法是经常发生的原因：

1、驱动配置有误：driver=com.mysql.jdbc.Driver
2、数据库连接地址有误：url=jdbc:mysql://localhost:3306/test?3useUnicode=true&characterEncoding=utf8
3、密码或帐号有误：username=root
      password=root

4、数据库未启动或无权访问





小丑的自我修养
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
新手解决Connections could not be acquired from the underlying database!Java代码上传到服务器连接不上数据库
weixin_45325148的博客
08-11 1733
本人刚入门Java，最近在开发一个项目，由于项目中有些问题需要与客户沟通。就想着把程序先上传到服务器上，先是上传到我之前用的服务器，服务器没有配置Java 环境。我自己配置好环境后把编译后代码上传上去，运行成功 但是在登陆时登录不了，错误代码Connections could not be acquired from the underlying database! 网上找了很多资料都说是: 1，驱动配置有误； 2，数据库连接地址有误； 3，密码或帐号有误； 4，数据库未启动或无权访问； 5，项目未引入对
异常——Connections could not be acquired from the underlying database!
ljinshuo的博客
07-15 498
Exception in thread “main” java.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! at cn.jjs.dao.Dao.findByProvince(Dao.java:46) at cn.jjs.da...
连接数据库出现：Connections could not be acquired from the underlying database
weixin_30849591的博客
10-17 1098
　　通常情况下，我们连接数据库时不会有大问题，今天遇到“Connections could not be acquired from the underlying database”，大意是不能连接当前所配置的数据库。出现这种问题,一般是配置参数有误。 　　因为我的数据库使用的是oracle数据库，前一段时间都是没有问题的，今天出现问题，程序配置对我来说是没有变化，最近几天的访问人数没...
No appropriate protocol(Connections could not be acquired from the underlying database! ）报错解决
最新发布
m0_57176999的博客
10-22 851
No appropriate protocol(Connections could not be acquired from the underlying database! ）报错解决
!解决：Connections could not be acquired from the underlying database!
hehyyoulan的博客
01-19 2083
阅读更多 og4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested excep...
有关数据库连接的问题
06-09
关于myeclipes链接sql server 的问题
Tomcat服务器响应过慢解决方案
09-29
【Tomcat服务器响应过慢解决方案】是一个常见的性能优化问题，主要关注如何提升服务器处理请求的速度。以下是一些详细的分析和解决方法： 1. **分析思路**： - **排除本机原因**：首先检查访问服务器的本地网络...
TOMCAT架构服务器优化指南
06-20
《TOMCAT架构服务器优化指南》是一本深入探讨TOMCAT服务器优化的专业书籍，由刘光瑞撰写，并由人民邮电出版社出版。该书聚焦于如何提升TOMCAT服务器的性能，确保系统的稳定性和高效运行。TOMCAT作为一款广泛应用的...
Tomcat maxConnections、maxThreads、acceptCount 图解
01-22
图解 Tomcat maxConnections、maxThreads、acceptCount
connections:https
03-09
连接数connections的主要目标是connections符合DBI的软件包与RStudio IDE的“集成在一起。 ， ， 和将R连接到这些数据库，但不提供与Connections窗格的直接集成。 connections读取connections的配置并创建与RStudio...
Notes（一）：Connections could not be acquired from the underlying database!
qq_35241558的博客
10-03 133
Notes（一）：Connections could not be acquired from the underlying database!自定义持久层框架问题问题：解决方式： 自定义持久层框架问题 问题： 连接数据库时，出现：Connections could not be acquired from the underlying database! 解决方式： 1. 驱动配置有误： mysql 5.0 配置：com.mysql.jdbc.Driver mysql 8.0 配置：com.mysql.
MaxwellBootstrapUtility - Connections could not be acquired from the underlying database
m0_37759590的博客
09-27 564
ERROR MaxwellBootstrapUtility - Connections could not be acquired from the underlying database!Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
【maxwell】maxwell连接不上mysql的问题解决
haveneric的博客
07-27 3112
maxwell连接mysql问题的解决
Connections could not be acquired from the underlying database @FDDLC
LiuXingchang的博客
10-11 1291
问题描述：Connections could not be acquired from the underlying database 解决方案：我在网上看了不少回答，这个问题本质上是数据库没连上导致的。 如果你以前能连上，就这次连不上，且数据库也没改过。那么，问题的范围又可以进一步缩小：你只需要考虑driver、url、username和password的事了。 为了让问题简化，你可以去粘以前成功时这几项的配置。当然，你需要考虑上次和这次不一致的地方。如果经过不断的修改，错误消失了。就以这个不.
解决：Connections could not be acquired from the underlying database!
LYGCSDN_的博客
07-10 1511
解决：Connections could not be acquired from the underlying database!
解决Connections could not be acquired from the underlying database!的问题
热门推荐
幻的博客
08-07 1万+
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! 做Spring+Mybatis的项目，报错 jdbc.properies: driver=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:330
spring整合mybaits时Connections could not be acquired from the underlying database!异常解决
Saltwater_leo的专栏
12-14 2674
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="ht
java.sql.SQLException: Connections could not be acquired from the underlying database!
08-08
java.sql.SQLException: Connections could not be acquired from the underlying database!这个错误通常是由于数据库连接池无法获取连接引起的。根据引用和引用的描述，这个错误可能由于配置文件中的问题导致。你...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值