1 Reply Latest reply: Apr 19, 2012 11:45 AM by Gennady Sigalaev RSS

    Query TImeout with ORACLE JDBC driver

      I want to halt an execution of query if an query takes more than specified time. Not only the query should be cancelled but the error should be thrown at client. I am using ORACLE 11g JDBC driver.

      I have used statement.setQueryTimeout() for the same. Moreover, my application is an OLTP system handling thousands of calls per second and one call is of 4 to 5 queries. Can anyone explain whether querytimeout will work in this case and its drawbacks if any.