6 Replies Latest reply on Apr 17, 2013 3:33 PM by Steve Felts-Oracle

    JDBC / JTA Timeouts : How to set a timeout on the fetching of a query ?

      Hi !

      I'm working on an Application running on Weblogic Server 11g. This app executes a query on an Oracle 11g database ...

      The problem is that this query returns millions of records ... and the app fetches the results during tens of minutes.

      We would like to set a timeout, wich will abandon the transaction, hang the database connection, destroy the socket ... or anything else ...

      This timeout will prevent the thread to become in STUCK state and stucking the weblogic managed server.

      Is this possible ?

      Thank's for your answers.


      Edited by: 966918 on 10 avr. 2013 07:18