We are using an rich faces application on a Jboss AS 6 server. We wanted to set a sql query timeout for the same, and thus added the following tags in the oracle-ds.xml:
We had set the query time out to 1 second, just to test if it works. Even when our query takes some 10-11 seconds to execute, there is no error/ time out message ( we want to limit our query time and hence we need this error).
Kindly let us know if we are missing any necessary setting/ code.