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

如题，本人从mysql数据库把里面的内容成功导入到sqlserver2005里但是启动tomcat后会提示错误 ERROR org.hibernate.util.JDBCExceptionReporter - Connections could not be acquired from the underlying database，输入项目地址则会报500 错误信息如题！
spring配置文件如下：
<?xml version="1.0" encoding="UTF-8"?>
xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"
default-lazy-init="true">

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="locations">
        <list>
            <value>/WEB-INF/config/jdbc.properties</value>
        </list>
    </property>
</bean>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    <property name="driverClass" value="${jdbc.driverClassName}" />
    <property name="jdbcUrl" value="${jdbc.url}" />
    <property name="user" value="${jdbc.username}" />
    <property name="password" value="${jdbc.password}" />
    <property name="autoCommitOnClose" value="true"/>
    <!-- <property name="checkoutTimeout" value="${cpool.checkoutTimeout}"/>-->
    <property name="initialPoolSize" value="${cpool.minPoolSize}"/>
    <property name="minPoolSize" value="${cpool.minPoolSize}"/>
    <property name="maxPoolSize" value="${cpool.maxPoolSize}"/>
    <property name="maxIdleTime" value="${cpool.maxIdleTime}"/>
    <property name="acquireIncrement" value="${cpool.acquireIncrement}"/>
    <property name="maxIdleTimeExcessConnections" value="${cpool.maxIdleTimeExcessConnections}"/>
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>  
    <property name="mappingLocations">
        <list>
            <value>classpath*:/com/jeecms/core/entity/hbm/*.hbm.xml</value>
            <value>classpath*:/com/jeecms/cms/entity/main/hbm/*.hbm.xml</value>
            <value>classpath*:/com/jeecms/cms/entity/assist/hbm/*.hbm.xml</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <value>
        hibernate.dialect=org.hibernate.dialect.SQLServerDialect
        hibernate.show_sql=false
        hibernate.format_sql=false
        hibernate.query.substitutions=true 1, false 0
        hibernate.jdbc.batch_size=20
        hibernate.cache.use_query_cache=true
        </value>
    </property>
    <property name="entityInterceptor">   
        <ref local="treeInterceptor"/>
    </property>
    <property name="cacheProvider">
        <ref local="cacheProvider"/>
    </property>
    <property name="lobHandler">
        <ref bean="lobHandler" />
    </property>
</bean>
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true"/>

<bean id="cacheProvider" class="com.jeecms.common.hibernate3.SpringEhCacheProvider">
    <property name="configLocation">
        <value>classpath:ehcache-hibernate.xml</value>
    </property>
    <property name="diskStoreLocation">
        <value>/WEB-INF/cache/hibernate</value>
    </property>
</bean>
<bean id="treeInterceptor" class="com.jeecms.common.hibernate3.TreeIntercptor"/>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>
<context:annotation-config/>
<tx:annotation-driven transaction-manager="transactionManager" />

配置文件如下：
jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDrive
jdbc.url=jdbc:sqlserver://192.168.1.1:1433/jeecms_2012?characterEncoding=UTF-8
jdbc.username=sa
jdbc.password=xmlrwy808
cpool.minPoolSize=10
cpool.maxPoolSize=20
cpool.maxIdleTime=7200
cpool.maxIdleTimeExcessConnections=1800
cpool.acquireIncrement=10

jar也加过了就是启动tomcat会提示org.hibernate.util.JDBCExceptionReporter - 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.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:555)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy14.getListFromCache(Unknown Source)
at com.jeecms.cms.web.FrontContextInterceptor.preHandle(FrontContextInterceptor.java:35)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:781)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Unknown Source)
求解答谢谢
两个配置文件在附件里了！

写回答
好问题 0 提建议
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
iteye_5246 2012-07-26 20:54
关注
一般这类问题，
1.连接字符串
2.配置文件错误，例如：多了个空格
仔细看完发现，mysql数据库换sqlserver
sqlserver数据库的 url错了
仔细看你自己的
jdbc:sqlserver://192.168.1.1:1433/jeecms_2012?characterEncoding=UTF-8
正确的是
jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=jeecms_2012;

也就是你配置文件url写错了正确如下：

jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDrive
jdbc.url=jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=jeecms_2012;
jdbc.username=sa
jdbc.password=xmlrwy808
cpool.minPoolSize=10
cpool.maxPoolSize=20
cpool.maxIdleTime=7200
cpool.maxIdleTimeExcessConnections=1800
cpool.acquireIncrement=10

如果还有错误，请留言

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

ssm整合中出现的问题 java spring 有问必答
2021-05-24 14:27

回答 3 已采纳 c3p0配置的问题，先看看这篇能不能解决。https://blog.csdn.net/WebSpider_1/article/details/107050587?utm_source=app&app_
c3p0连接mysql8报错 java mysql
2022-08-22 16:03

回答 2 已采纳参考文章：https://blog.csdn.net/ly2708169628/article/details/117791091https://blog.csdn.net/naumy/article
ssm数据库连接失败，找了几天没有用，有大佬吗？Error querying database. Could not。。。 java maven mysql tomcat
2019-11-22 10:44

回答 7 已采纳第一：检查mysql-connector-java.jar包版本，是不是8.0.11版本的或者8.0版本的，是的话改成5.0.x版本的。第二：jdbc.url=jdbc:mysql://local
A ResourcePool could not acquire a resource from its primary factory or source
2021-04-26 11:32

想当厨子的码农的博客 A ResourcePool could not acquire a resource from its primary factory or source 我使用的数据库是MySql5.7版本的四月 26, 2021 11:30:50 上午 org.apache.catalina.core.StandardWrapperValve invoke 严重: ...
用c3p0链接mysql总是出现Unknown system variable 'query_cache_size' java mysql
2020-02-25 16:13

回答 3 已采纳好歹配置信息发错来，你这个错误是数据库链接配置有错误。发出来，看看就知道了
tomcat 404 问题，萌新完全措手无助！ eclipse
2018-12-03 03:29

回答 5 已采纳谢谢各位大神。。。所以不是路径配置问题咯
tomcat 404问题，console出的问题有关于mysql数据库连接问题，账号密码错误等问题。萌新求帮助！！ mysql tomcat 数据库
2018-12-04 03:46

回答 3 已采纳你先看看数据库密码对不对，然后把数据库配置截图发出来 ``` #数据库连接配置 spring.datasource.url=jdbc:mysql://localhost/yunbian
A ResourcePool could not acquire a resource from its primary factory or source.
2021-11-06 20:53

有上进心的阿龙的博客 While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: ...
哪位大神帮我解决一下eclipse运行突然报404，好像是spring配置文件有问题 eclipse jar java spring tomcat
2019-07-28 15:28

回答 3 已采纳 1、eclipse中配置好tomcat服务器后，启动tomcat查看控制台信息显示启动成功，但访问tomcat首页报404异常 2、而从tomcat/bin目录中启动后，就能够正常访问首
数据库连接错误 hibernate spring struts
2012-07-30 11:02

回答 1 已采纳 Cannot open connection。数据库连接错， 1.确定数据库服务打开 2.使用数据库是否存在
struts2 spring2 hibernate3 +oracle10G用c3p0出错 hibernate
2008-10-17 11:22

回答 2 已采纳我一直用dbcp 的。具体不太清楚，不过，我用dbcp时导包了。你用c3p0导包了吗
A ResourcePool could not acquire a resource from its primary factory or source异常解决
2020-05-12 16:04

一一哥Sun的博客 A ResourcePool could not acquire a resource from its primary factory or source异常解决一. 异常问题我在给别人做项目的时候，我自己本地连接的数据库是5.7，用的mysql-connector-java的驱动包是5.x版本的，...
【已解决】A ResourcePool could not acquire a resource from its primary factory or source
2022-01-05 13:45

KEY的航行日记的博客 A ResourcePool could not acquire a resource from its primary factory or source No timezone mapping entry for 'UTC; 首先在CSDN搜索了一番 CSDN文章：数据库连接错误集锦然后，发现我的没有错，但还是报错 ...
处理 A ResourcePool could not acquire a resource from its primary factory or source.
2018-03-04 10:32

500万一根油条的博客遇到 A ResourcePool could not acquire a resource from its primary factory or source.这个问题，花了很多时间去查找，解决，报错如下：org.hibernate.exception.GenericJDBCException: Could not open ...
数据库连接异常（A ResourcePool could not acquire a resource from its primary factory or source.）
2020-07-03 18:52

naumy的博客（A ResourcePool could not acquire a resource from its primary factory or source.）生为小白的我总结以下五种常见发生这种异常信息的类型，先检查数据库是否启动了，不过MySQL数据库一般都会启动，哈哈！！ ...
c3p0报：A ResourcePool could not acquire a resource from its primary factory or source
2020-06-16 21:13

好菜哦的博客如题：出现该问题的原因。 1.数据库配置信息有误，连库四要素，检查是否有问题。 <... <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/my?serverTimezone=GMT%2B8"/>...property name="user" ...
【数据库】 A ResourcePool could not acquire a resource from its primary factory or source.
2019-08-28 16:16

小烽努力变强的博客 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.等报错的解决
2019-07-10 08:39

三年级小朋友的博客 com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at ...
数据库连接错误集锦A ResourcePool could not acquire a resource from its primary factory or source
2017-08-03 14:36

oldbig_lin的博客今天在测试一个项目时出现A ResourcePool could not acquire a resource from its primary factory or source错误，百度了一下，可能是以下几个原因 1，驱动配置有误：driver=com.mysql.jdbc.Dri
使用c3p0连接mysql数据库报错A ResourcePool could not acquire a resource from its primary factory or source.
2022-12-02 08:14

抚琴弄心弦的博客使用c3p0连接mysql数据库报错A ResourcePool could not acquire a resource from its primary factory or source.
没有解决我的问题, 去提问

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

1条回答 默认 最新

也就是你配置文件url写错了正确如下：

1条回答默认最新