I'm evaluating Hibernate as a potential JPA solution for a custom application. We would like the application to automatically reconnect cleanly in the case where our Oracle 11g database is restarted.

For the sample application I wrote, I get a "recv failed" error when the application attempts to contact the restarted database. If I use c3p0 as follows:

props.put("hibernate.c3p0.min_size", "1");
props.put("hibernate.c3p0.max_size", "10");
props.put("hibernate.c3p0.timeout", "300");
props.put("hibernate.c3p0.max_statements", "50");
props.put("hibernate.c3p0.idle_test_period", "3000");
props.put("hibernate.c3p0.validate", "true");

I instead get socket errors, but still no reconnection.

Rather than play guessing games, is there a straightforward way to get hibernate to automatically reconnect?

Thanks,
John

Hi,
it appears "idleConnectionTestPeriod" is missing, also you should select an appropriate connection testing strategy.
You'll find all details well explained in the docs included in the c3p0 package:
http://sourceforge.net/project/showfiles.php?group_id=25357
Also the docs contain some more suggestions for Oracle.

BTW this is meant for a standalone app right?
When deploying in an application server as JBoss you don't need to use c3p0 and can enable very smart behavior just setting some options in the datasource definition.

also "validate" is deprecated.