问题描述
系统登录后只操作两下，就不能操作报错信息：Causedby:java.sql.SQLException:Connectionscouldnotbeacquiredfromtheunderlyingdatabase![Cause:com.mchange.v2.resourcepool.CannotAcquireResourceException:AResourcePoolcouldnotacquirearesourcefromitsprimaryfactoryorsource.atcom.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)atcom.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)atcom.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)atcom.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
配置文件：database.driver=oracle.jdbc.driver.OracleDriverdatabase.url=jdbc:oracle:thin:@132.35.224.165:1521:dwtest1database.username=mampdatabase.password=mamp001database.initialPoolSize=3database.acquireIncrement=3database.minPoolSize=3database.maxPoolSize=100database.maxIdleTime=10database.encryptType=0hibernate.dialect=org.hibernate.dialect.Oracle10gDialect#hibernate.dialect=org.hibernate.dialect.MySQL5Dialect#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialecthibernate.show_sql=truehibernate.hbm2ddl.auto=updatehibernate.jdbc.batch_size=20
<?xmlversion="1.0"encoding="UTF-8"?><beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:context="http://www.springframework.org/schema/context"xmlns:jdbc="http://www.springframework.org/schema/jdbc"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.2.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.2.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.2.xsdhttp://www.springframework.org/schema/jdbchttp://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.2.xsd"><beanid="internalDataSource"class="com.bonc.commons.jdbc.datasource.EncryptPooledDataSource"destroy-method="close"><propertyname="driverClass"><value>${database.driver}</value></property><propertyname="jdbcUrl"><value>${database.url}</value></property><propertyname="user"><value>${database.username}</value></property><propertyname="password"><value>${database.password}</value></property><propertyname="initialPoolSize"><value>${database.initialPoolSize}</value></property><propertyname="acquireIncrement"><value>${database.acquireIncrement}</value></property><propertyname="minPoolSize"><value>${database.minPoolSize}</value></property><propertyname="maxPoolSize"><value>${database.maxPoolSize}</value></property><propertyname="maxIdleTime"><value>${database.maxIdleTime}</value></property><propertyname="encryptType"><value>${database.encryptType}</value></property></bean><!--tomcatJNDI配置方式配置，默认JNDI名字为default，如果修改JNDI名字，请修改本配置的jndiName属性--><!--<beanid="internalDataSource"class="org.springframework.jndi.JndiObjectFactoryBean"><propertyname="jndiName"value="java:comp/env/default"/></bean>--><beanid="dataSource"class="com.bonc.commons.jdbc.datasource.SingleDataSource"><propertyname="internalDataSource"ref="internalDataSource"/></bean><!--当使用oracle9i时,需配置为启用一下lobHandler配置，同时注释掉默认配置org.springframework.jdbc.support.lob.DefaultLobHandler--><!--<beanid="jdbcExtractor"class="org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor"/><beanid="lobHandler"class="org.springframework.jdbc.support.lob.OracleLobHandler"lazy-init="true"><propertyname="nativeJdbcExtractor"ref="jdbcExtractor"/></bean>--><beanid="lobHandler"class="org.springframework.jdbc.support.lob.DefaultLobHandler"lazy-init="true"></bean></beans>
请问是什么问题？谢谢