Can I force a request to time out after a predetermined time, like 5 seconds?
Article ID: KB0081956
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?
Resolution
You can configure a data source with a request timeout interval. However, be aware that:
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".
- 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".
Issue/Introduction
Can I force a request to time out after a predetermined time, like 5 seconds?
Additional Information
Feedback
Yes
No
Powered by
