[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: ORA-02396: exceeded maximum idle time, please connect ag
jaikiran
do-not-reply at jboss.com
Tue Nov 11 02:50:54 EST 2008
"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
More information about the jboss-user
mailing list