An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
Cause: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool不知道为什么,服务器运行一段时间后,就会出现上面的异常,通常为1个星期左右,时间短一点几天就出异常了!刚启动的时候是不会出现异常的。
连接吃配置:<Resource name="jdbc/wwwPool" auth="Container"
description="DB Connection"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
factory="org.apache.naming.factory.BeanFactory"
driverClass="com.mysql.jdbc.Driver"
jdbcUrl="xxx" user="xxx"
password="xxx" initialPoolSize="3" minPoolSize="3" maxPoolSize="3"
maxIdleTime="1800" acquireIncrement="2" maxStatements="0"
idleConnectionTestPeriod="1800" acquireRetryAttempts="30"
breakAfterAcquireFailure="true" testConnectionOnCheckout="false" />
Cause: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool不知道为什么,服务器运行一段时间后,就会出现上面的异常,通常为1个星期左右,时间短一点几天就出异常了!刚启动的时候是不会出现异常的。
连接吃配置:<Resource name="jdbc/wwwPool" auth="Container"
description="DB Connection"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
factory="org.apache.naming.factory.BeanFactory"
driverClass="com.mysql.jdbc.Driver"
jdbcUrl="xxx" user="xxx"
password="xxx" initialPoolSize="3" minPoolSize="3" maxPoolSize="3"
maxIdleTime="1800" acquireIncrement="2" maxStatements="0"
idleConnectionTestPeriod="1800" acquireRetryAttempts="30"
breakAfterAcquireFailure="true" testConnectionOnCheckout="false" />
A ResourcePool could not acquire a resource from its primary factory or source求解!!!
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<!-- 指定连接数据库的JDBC驱动 -->
<property name="driverClass">
<value>com.mysql.jdbc.Driver</value>
</property>
<!-- 连接数据库所用的URL -->
<property name="jdbcUrl">
<value>jdbc:mysql://localhost:3306/fujian_db</value>
</property>
<!-- 连接数据库的用户名 -->
<property name="user">
<value>root</value>
</property>
<!-- 连接数据库的密码 -->
<property name="password">
<value>123</value>
</property>
<!-- 设置数据库连接池的最大连接数 -->
<property name="maxPoolSize">
<value>40</value>
</property>
<!-- 设置数据库连接池的最小连接数 -->
<property name="minPoolSize">
<value>2</value>
</property>
<!-- 设置数据库连接池的初始化连接数 -->
<property name="initialPoolSize">
<value>2</value>
</property>
<!-- 设置数据库连接池的连接的最大空闲时间,单位为秒 -->
<property name="maxIdleTime">
<value>20</value>
</property>
</bean>
请问这个是什么意思