Hello,
We are using Hibernate 3 to handle transactions with an Oracle 9i database located on a server somewhere in the country.
After a few hours during the night, the connection goes idle and closes, hence we get the following errors

2006-12-30 17:04:36,753 [Thread-2953] WARN - (JDBCExceptionReporter.java:logExceptions:71)- SQL Error: 17002, SQLState: null
2006-12-30 17:04:36,754 [Thread-2953] ERROR - (JDBCExceptionReporter.java:logExceptions:72)- Io exception: Connection reset

Is there anyway we can fix this at our application end i.e, in the Hibernate config or is it an Oracle problem because we didnt see this problem previously when we were using HSQLDB.

which connection pool you are using. Try using commons-dbcp, that can be configured to detect if the connection is live.
http://jakarta.apache.org/commons/dbcp/ ... ation.html

Hi, we are using a default config. i.e, the default hibernate.cfg.xml. Our Parameters are shown below.
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@ORACLEDATABASEURL</property>
<property name="hibernate.connection.username">username</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.connection.pool_size">10</property>
<property name="show_sql">false</property>

<property name="current_session_context_class">thread</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>

Is it not possible to set the required parameter in the default

Hello, does anyone know if a solution would be to put the autoReconnect value in the url, i.e
ORACLEDATABASEURL?autoReconnect=true