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.
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.
You could write a simple service that does a query every so often to keep the connection refreshed.
But there must be timeout either on the database (a default one, or perhaps in the JDBC driver) because the error message (ORA-02396) is an Oracle error message - JBossAS would never generate an Oracle error. If it is the driver, there should be a configuration option that you can set to change the driver timeout.