I’m using Hibernate + C3P0 reading an Oracle database in a Tomcat 9 environment. Is it possible to automatically reconnect jdbc sessions when they have been closed due to inactive timeout?. What parameters should be set to persistence.xml?
I've this parameters among others:
- property name="hibernate.c3p0.timeout" value="300000"
- property name="hibernate.c3p0.idle_test_period" value="120"
The error showed is: ERROR SqlExceptionHelper ORA-02396: ha excedido el tiempo máximo de inactividad, vuelva a conectarse
I've an error in my application when navigator remains unatended for a while. Then I need restart my application for reconect to de database. I want to evit that.