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

"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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...