Hi,

I've encountered a problem which I can't seem to resolve or find the source of it...
My version of hibernate: 3.2. I'm using the C3P0 connection pool (hbm config file attached).
When I create a session factory with my hibernate.cfg.xml config file and the DB (mysql Ver 14.12 Distrib 5.0.45, for Win32) is up and running, all works fine.
But, when the DB is down (service is stopped and no connections from the console can be made), a loop of repeated exceptions is printed to the console (never stops):


I've noticed another thing which I cannot explain:
When I remove the C3P0 configurations from the file, I do not get the loop of repeated exception as above. A session factory and a session are created (session.isConnected() returns true!), no exceptions are thrown and no warnings are printed to the console.

My questions:
1) How can I resolve the endless exceptions loop? (first problem)
2) When I'm not using the C3P0 connections pool, why is a session created with no errors?

I believe that I'm missing something here, but can't tell what.


This is my hbm file:

<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="hibernate.connection.url">
jdbc:mysql://localhost/nswdb
</property>
<property name="hibernate.connection.username">nswuser</property>
<property name="hibernate.connection.password">1234</property>
<property name="hibernate.connection.pool_size">10</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

<property name="hibernate.hbm2ddl.auto">update</property>



<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">50</property>



<!-- Mapping files -->
<mapping resource="NSWUser.hbm.xml"/>
<mapping resource="NSWPerson.hbm.xml"/>
<mapping resource="NSWGroup.hbm.xml"/>
<mapping resource="NSWBackToSmokingReason.hbm.xml"/>
<mapping resource="NSWOrganization.hbm.xml"/>
<mapping resource="NSWStopSmokingReason.hbm.xml"/>
<mapping resource="NSWMedication.hbm.xml"/>
<mapping resource="NSWMethod.hbm.xml"/>
<mapping resource="NSWSession.hbm.xml"/>
<mapping resource="NSWPatientInSession.hbm.xml" />

</session-factory>
</hibernate-configuration>


This is how I create a session:



Help & explanations appreciated!

Hi,

Anyone?