Hibernate version: 2.1.6

Hi all,

I am using Hibernate with c3p0 as Db Connection Pooling manager. Oracle database server in my company downs at midnight every day to backup data. How can I confirgure hibernate/c3p0 to auto-reconnect if database server down?

Thanks.

http://www.hibernate.org/214.html

<property name="c3p0.idle_test_period">100</property> <!-- seconds -->

if your db is down at t, c0p3 will be able to reconnect at t + 100s

Be carefull, if your db is down more than 100s, your app is dead.

Go and see last version of c3p0, there are new features like "i want to test every x seconds and y times, after that my app will condirer the db as definitly dead".