Re: Pool and DBCP : Pool not Open

[Dirk Verbeeck]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]