The following table summarizes Web service connection properties, including those related to timeouts.

Table 1. Web Service Properties
Property Characteristic
LoginTimeout The amount of time, in seconds, that the driver waits for a connection to be established before timing out the connection request.

If set to 0, the driver does not time out a connection request.

If set to x, the driver waits for the specified number of seconds before returning control to the application and throwing a timeout exception.

The default is 0 (no timeout).
StmtCallLimit Specifies the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.

If set to 0, there is no limit.

If set to x, the driver uses this value to set the maximum number of Web service calls on a single connection that can be made when executing a SQL statement. This limit can be overridden by changing the STMT_CALL_LIMIT session attribute using the ALTER SESSION statement.

The default is 100 (Web service calls).
StmtCallLimitBehavior Specifies the behavior of the driver when the maximum Web service call limit specified by the StmtCallLimit property is exceeded.

If set to errorAlways, the driver generates an exception if the maximum Web service call limit is exceed.

If set to returnResults, the driver returns any partial results it received prior to the call limit being exceeded. The driver generates a warning that not all of the results were fetched.

The default is errorAlways.
WSCompressData Specifies whether the driver compresses data it sends to or receives from the Web server.

If set to none, the driver sends and receives uncompressed data to and from the Web server.

If set to compress, the driver sends and receives compressed data to and from the Web server.

The default is compress.
WSFetchSize Specifies the number of rows of data the driver attempts to fetch for each JDBC call.

If set to 0, the driver attempts to fetch up to a maximum of 2000 rows. This value typically provides the maximum throughput.

If set to x, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than 2000 can reduce the response time for returning the initial data. Consider using a smaller WSFetch size for interactive applications only.
WSPoolSize Specifies the maximum number of Salesforce sessions the driver uses. This allows the driver to have multiple web service requests active when multiple ODBC connections are open, thereby improving throughput and performance.

The default is 1.

WSRetryCount The number of times the driver retries a timed-out Select request. Insert, Update, and Delete requests are never retried.

If set to 0, the driver does not retry timed-out requests after the initial unsuccessful attempt.

If set to x, the driver retries the timed-out request the specified number of times.

The default is 0.

WSTimeout Specifies the time, in seconds, that the driver waits for a response to a Web service request.

If set to 0, the driver waits indefinitely for a response; there is no timeout.

If set to x, the driver uses the value as the default timeout for any statement created by the connection.

The default is 120.

See also