0 Replies Latest reply: Dec 12, 2011 11:36 PM by Its Me RSS

Query Time out in Jboss AS 6

Its Me Newbie

Hello,

 

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:

 

<set-tx-query-timeout></set-tx-query-timeout>

                    <query-timeout>1</query-timeout>

 

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.

 

Thanks and Regards,

Nid.............