Bonjour,
J'utilisa la pool : c3p0. J'ai ce message d'erreur.
Je ne vois pas la source de mon problème.
Merci d'avance

Hibernate version:3

Hibernate.cfg.xml:
<hibernate-configuration>

<session-factory>

<!-- ~*~~*~~*~*~~*~*~ paramètres de connexions ~*~*~*~*~*~~*~*~*~ -->

<property name="use_outer_join">false</property>

<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>

<property name="hibernate.cglib.use_reflection_optimizer">true</property>

<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>

<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.idle_test_period">100</property>

<property name="c3p0.max_size">100</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.min_size">10</property>
<property name="c3p0.timeout">100</property>

<property name="hibernate.connection.username">suivi</property>
<property name="hibernate.connection.password">suivi</property>
<property name="show_sql">true</property>
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<property name="hibernate.connection.pool_size">40</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@???.???.???.???:1521:myDB</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>

<property name="hibernate.cache.use_minimal_puts">true</property>

<property name="hibernate.cache.use_query_cache">true</property>


<!-- ~*~~*~~*~*~~*~*~ listes de fichiers .hbm.xml ~*~*~*~*~*~~*~*~*~ -->

<mapping resource="com/persistence/pojos/Tab.hbm.xml"></mapping>
</session-factory>

</hibernate-configuration>

Full stack trace of any exception that occurs:
com.mchange.v2.c3p0.impl.NewPooledConnection@c03da9 invalidated by Exception: java.sql.SQLException: Instruction fermée
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6390)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:576)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:2291)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getTables(NewProxyDatabaseMetaData.java:2827)
at com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:71)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:141)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:126)
at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1227)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
c3p0: An idle resource is broken and will be purged.
c3p0 [broken resource]: java.sql.SQLException: Connection is invalid
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:176)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:126)
at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1227)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
15 sept. 2005 16:10:59 org.apache.catalina.core.ApplicationContext log



Name and version of the database you are using: Oracle8i

Bonjour,

Ne doit-on pas utiliser c3p0 en le préfixant par hibernate ?

exemple fournit dans la référence hibernate :
"hibernate.c3p0.min_size=5
hibernate.c3p0.max_size=20
hibernate.c3p0.timeout=1800
hibernate.c3p0.max_statements=50"

Xavier

c gentil
je ne pense pas :
http://www.hibernate.org/214.html

ok, qui croire alors :-D

je regarde en //

Bon courage,

Xavier