DBCP : Jdbc3Connection is closed

Bonjour,

J’ai utilisé API apache DBCP pour les pool des connexions.
Au démarrage tous fonction sons problème mais après le clean des sessions qui non sont pas fermer « "hibernate.dbcp.removeAbandoned" = true » j’ai le msg d’erreur

Code:

1
2
3
4
5
6
7
8
9
10
11
12
 
Caused by: java.sql.SQLException: Connection org.postgresql.jdbc3.Jdbc3Connection@20941296 is closed.
        at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
        at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:279)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
        at org.hibernate.loader.Loader.doQuery(Loader.java:661)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)

voila mes paramètre :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
<property name="hibernate.dbcp.validationQuery">select 1</property>
<property name="hibernate.dbcp.initialSize">10</property>
<property name="hibernate.dbcp.maxActive">100</property>
<property name="hibernate.dbcp.maxIdle">80</property>
<property name="hibernate.dbcp.minIdle">10</property>
<property name="hibernate.dbcp.maxWait">40000</property>
<property name="hibernate.dbcp.testOnReturn">true</property>
<property name="hibernate.dbcp.testOnBorrow">true</property>
<property name="hibernate.dbcp.testWhileIdle">true</property>
<property name="hibernate.dbcp.timeBetweenEvictionRunsMillis">420000</property>
<property name="hibernate.dbcp.minEvictableIdleTimeMillis">300000</property>
<property name="hibernate.dbcp.validationInterval">25000</property>
<property name="hibernate.dbcp.removeAbandoned">true</property>
<property name="hibernate.dbcp.removeAbandonedTimeout">50</property>
<property name="hibernate.dbcp.logAbandoned">true</property>
<property name="hibernate.dbcp.poolPreparedStatements">false</property>

Merci pour votre aide