[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: ORA-02396: exceeded maximum idle time, please connect ag

[jaikiran]

"ejsdeveloper" wrote : When the application is idle for several hours, the next request throws the following error: ORA-02396: exceeded maximum idle time, please connect again.
  | 
  | The DBAs state that there is no idle timeout on the database.
  | 
  | 


Since the error message (ORA-02396) is from the database, the database server is probably set for idle timeout.
anonymous wrote : 
  | I set the local-tx-datasource to <idle-timeout-minutes>0</idle-timeout-minutes>, but the app is still getting the idle time error. 

The idle-timeout-minutes is the time after which a thread cleans up any idle connections in the pool. Setting it to 0 i think is going to disable it. I would suggest to set it to around 20 minutes or any other appropriate value.


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4188360#4188360

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4188360