Hello gurus -

I cannot seem to find the right combination of c3p0 properties to get my Hibernate session factory to resurrect after an Oracle instance controlled by other folks gets bounced. Below are the relevant portions of my .cfg.xml file.

<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.idle_test_period">30</property>
<property name="c3p0.max_size">100</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.min_size">5</property>
<property name="c3p0.timeout">45</property>
<property name="c3p0.acquireRetryAttempts">100</property>
<property name="c3p0.testConnectionsOnCheckout">true</property>

I'm pretty sure this is the problem area, I only get problems on Mondays after the Oracle machine gets toggled on Sunday night, and a bounce of my application server 'fixes' the problem. As I don't have write access to the machine in question, I cannot utilize some of the techniques involving creating a test table for checking the connection against.

Alternatively, can someone point me to some examples wherein I could build something to manually tell Hibernate to reset the configuration and reset its SessionFactory? I think this would probably do the trick and I could have something available to trigger this without too much trouble.

Thanks a lot.

brian