The "Pool not open" Exception is thrown when the pool has been closed,
either directly or indirectly, close() on the pool or datasource.
Once the close method has been called the pool/PoolingDataSource
cannot be used anymore and has to be recreated/initialized.
Are you using the JNDI way of obtaining a datasource from tomcat or
are you creating one yourself?
-- Dirk
Pedro Gonçalves wrote:
> Hi,
>
> I have an application that uses dbcp 1.2.1, pool 1.2,
> tomcat 5 and mysql...
> in the middle of process the following erro occurs:
>
> java.lang.IllegalStateException: Pool not open
> at
> org.apache.commons.pool.BaseObjectPool.assertOpen(BaseObjectPool.java:78)
> at
> org.apache.commons.pool.impl.GenericObjectPool.returnObject(GenericObjectPool.java:853)
> at
> org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:80)
> at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
>
> and my data source configuration:
>
> <set-property property="maxActive" value="20"/>
> <set-property property="testOnBorrow" value="true"/>
> <set-property property="testOnReturn" value="false"/>
> <set-property property="validationQuery" value="SELECT
> 1"/>
> <set-property property="removeAbandoned"
> value="false"/>
> <set-property property="maxCount" value="20"/>
> <set-property property="minCount" value="5"/>
> <set-property property="timeBetweenEvictionRunsMillis"
> value="600000"/>
> <set-property property="minEvictableIdleTimeMillis"
> value="600000"/>
> <set-property property="maxIdle" value="2"/>
> <set-property property="minIdle" value="1"/>
> <set-property property="maxWait" value="-1"/>
> <set-property property="testWhileIdle" value="true"/>
>
> anything wrong?
>
> thanks...
>
>
> Pedro Gonçalves de Oliveira
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
|