Can I force a request to time out after a predetermined time, like 5 seconds?

Can I force a request to time out after a predetermined time, like 5 seconds?

book

Article ID: KB0081956

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.0 and higher

Description

Can I force a request to time out after a predetermined time, like 5 seconds?

Issue/Introduction

Can I force a request to time out after a predetermined time, like 5 seconds?

Resolution

You can configure a data source with a request timeout interval. However, be aware that:
  • All requests against that data source will time out after the interval.
  • The requests will time out even if not all data has been returned from the back-end database server as yet.

To configure the data source with a timeout interval:

(1)   Open Studio
(2)   Navigate to the data source and click on the data source's Advanced panel
(3)   Set the value of Execution Timeout(s) to the desired interval.

Below is an example of configuring an Oracle data source with timeout of 2 seconds, and then attempting to run a request that needs 10 seconds to complete. The request aborts after 2 seconds, with a message "ORA-01013: user requested cancel of current operation".
         
 

Additional Information

User-added image