Timeouts

The driver supports the LoginTimeout, WSTimeout, and WSRetryCount connection properties. The LoginTimeout property specifies the amount of time, in seconds, that the driver waits for a connection to be established before timing out the connection request. In contrast, the WSTimeout property specifies the time, in seconds, that the driver waits for a response to a Web service request. The WSTimeout property can be used in conjunction with the WSRetryCount property. The WSRetryCount connection property can be used to retry select queries that have timed out.

Most remote data sources impose a limit on the duration of active sessions, meaning a session can fail with a session timeout error if the session extends past the limit. This is particularly true when connection pooling is used. The driver automatically attempts to re-establish a new session if the driver receives a session timeout error from a data source. The driver uses the initial server name, remote user ID, and remote password to re-establish the session. If the attempt fails, the driver returns an error indicating that the session timed out and the attempt to re-establish the session failed.

You can configure the driver to never time out while waiting for a response to a Web service request or to wait for a specified interval before timing out by setting the WSTimeout connection property. For fetch requests, you can configure the driver to retry the request a specified number of times by setting the WSRetryCount connection property. If subsequent attempts to retry a request fail, the driver returns an error indicating that the service request timed out and the subsequent requests failed.