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".