Idle time Closed Connection

jagadishsuri · **Joined:** Fri Jan 09, 2009 5:26 am **Posts:** 5

Hi,

The following is the exception that i get when i use hibernate 3.0 to connect to Oracle 10G using the ojdbc14.jar.

i get this error when i run my eclipse plugin based application on windows vista. This happens when i keep the system idle for prolonged hours apprx 8 hours or more. But the same is not reproduced when i keep it idle on the windows xp system.

The Oracle server is present on another system which is a windows XP system but not on the same system where iam running the appliation.

So i need to know whether it is the Vista problem or the hibernate problem.

org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at <exceptions trace from the code>

Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1439)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
... 9 more

Thanks
Jagadish Suri

Madan_Prabhu · **Posted:** Fri Jan 09, 2009 5:59 am

set timeout property as u want in hibernate.cfg.xml.

Madan_Prabhu · **Posted:** Fri Jan 09, 2009 6:00 am

set timeout property as u want in hibernate.cfg.xml.

it's not a problem, connection r closed after some time if it is in ideal .

jagadishsuri · **Joined:** Fri Jan 09, 2009 5:26 am **Posts:** 5

if its a problem with the hibernate then why is it not occuring with xp but rather happening only on vista system?

Madan_Prabhu · **Posted:** Fri Jan 09, 2009 6:25 am

it's all abt ur misconfiguration in connection pool cp3 in hibernate.

jagadishsuri · **Joined:** Fri Jan 09, 2009 5:26 am **Posts:** 5

.....

Thanks
jagadish suri

mmerder · **Posted:** Fri Jan 09, 2009 6:46 am

It seems to me that this is a vista problem. See here.

You can reconfigure session idle time like this.

jagadishsuri · **Joined:** Fri Jan 09, 2009 5:26 am **Posts:** 5

Not quite sure whether this applies to the hibernate and db problem. but any way thanks for your reply.

jagadishsuri · **Joined:** Fri Jan 09, 2009 5:26 am **Posts:** 5

The timeout property did not solve the problem. how do we make sure that the connections are reinitialized after a certain idle time? or when they are dropped?