This discussion is archived
6 Replies Latest reply: Apr 17, 2013 8:33 AM by SteveFelts RSS

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

969921 Newbie
Currently Being Moderated
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.

Steve.

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points