问题描述
<bean id="DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" abstract="false" singleton="true" lazy-init="default" autowire="default" dependency-check="default" destroy-method="close"> <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property> <property name="jdbcUrl"><value>jdbc:oracle:thin:@192.168.130.132:1521:orcl</value></property> <property name="user" value="root as sysdba"></property> <property name="password" value="root"></property> <property name="maxPoolSize" value="40"></property> <property name="minPoolSize" value="10"></property> <property name="initialPoolSize" value="30"></property> </bean>这是spring的配置，使用是出现下列错误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)而用<bean id="dataSource"class="org.apache.commons.dbcp.BasicDataSource"><property name="driverClassName"value="oracle.jdbc.driver.OracleDriver"></property><property name="url"value="jdbc:oracle:thin:@192.168.130.132:1521:orcl"> </property><property name="username" value="root"> </property><property name="password" value="root"> </property></bean>这样的配置就没有问题，不知道用c3p0问题补充：恩我来用dbcp来配置一下看看
解决方案
我一直用dbcp 的。具体不太清楚，不过，我用dbcp时导包了。 你用c3p0导包了吗
解决方案二：
有时不导包，编译时不报错