im using the getDataSource(request) from struts...
and i never close ( i think ) the pool
--- Dirk Verbeeck <[EMAIL PROTECTED]> wrote:
> 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]
>
>
Pedro Gon�alves de Oliveira
Yahoo! Acesso Gr�tis - Internet r�pida e gr�tis.
Instale o discador agora! http://br.acesso.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
