0 Replies Latest reply on Dec 12, 2011 11:36 PM by its_me

    Query Time out in Jboss AS 6

    its_me

      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.............