Hello friends of the forum ...
I am developing a Web application with Java + Hibernate and Oracle BD. Everything goes well. The problem is when I leave for a good time (2 or 3 hours) without doing anything that I get the following error:

[WARN] SQL Error: 17002, SQLState: null
[ERROR] Excepción de E/S: Connection timed out
[INFO] ERROR LOG
exception.getMessage() = could not execute query
exception.getMessage() = [Ljava.lang.StackTraceElement;@1fbafbb
exception.getCause() = java.sql.SQLException: Excepción de E/S: Connection timed out
exception.fillInStackTrace() = org.hibernate.exception.GenericJDBCException: could not execute query


and when I do run, I get this error:

[WARN] SQL Error: 17008, SQLState: null
[ERROR] Connection closed
[INFO] ERROR LOG
exception.getMessage () = could not execute query
exception.getMessage () = [Ljava.lang.StackTraceElement; @ e01873
exception.getCause () = java.sql.SQLException: Connection closed
exception.fillInStackTrace () = org.hibernate.exception.GenericJDBCException: could not execute query


My configuration of my hibernate.cfg.xml file is:

<? xml version = "1.0" encoding = "UTF-8"?>
<! Doctype hibernate-configuration PUBLIC
"- / / Hibernate / Hibernate Configuration DTD 3.0 / / EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.bytecode.use_reflection_optimizer"> false </ property>
<property name="hibernate.connection.driver_class"> oracle.jd bc.driver.OracleDriver </ property>
<property name="hibernate.connection.password"> password </ property>
<property name="hibernate.connection.url"> jdbc: oracle: thin: @ Host: 1521: DBXXXX </ property>
<property name="hibernate.connection.username"> username </ property>
<property name="hibernate.dialect"> org.hibernate.dialect.Ora cle9Dialect </ property>
<property name="current_session_context_class"> thread </ property>
</ session-factory>
</ hibernate-configuration>



please help!


Att. Javi

Hello,
connections have timeouts, so you probably want to use a connection pool.
Most applications servers have good connection pools, but you should use a DataSource in that case and not encode your connection options in your hibernate configuration.

If you don't use an application server you may want to configure C3p0,
look at hibernate docs
http://www.hibernate.org/214.html
or the c3p0 website
http://sourceforge.net/projects/c3p0
in the c3p0 package you'll find a good explanation for alla parameters, and some additional info especially for Oracle.

Actually if you are using Tomcat it would be much easier to use JBoss instead.

Is this a web based application, or a stand-alone Java application?