I'm using hibernate 2 for connect web application in oracle9ias and oracle 9 database.

When the application this inactive during a period of time, the application loses the connectivity with the database.

I have proven to modify the configuration file adding:

hibernate.connection.autoReconnect: true
hibernate.connection.autoReconnectForPools: true hibernate.connection.is-connection-validation-required: true


But it has not given result.
Some suggestion?

Thank you very much.

Use the c3p0 connection pool instead of the default hibernate connection pool which is not suitable for production use and commonly breaks after a period of inactivity.

Thank you!!!

The application run OK with c3p0, stoping and starting database.

1000 gracias :D

Feel free to thank me with a credit.

Done ;)

Hi,

Can you advice me on what is the configuration that I need to do in order to run application that uses Hibernate 3.1.3 in Oracle9i Internet application server that connects to Oracle9i database.

Please advise.
Thank you.