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

Table 1. Web Service Properties
Property Characteristic
OracleServiceCloudDatabase Controls how the driver instructs the Oracle Service Cloud web service to resolve queries. Oracle Service Cloud can satisfy queries against the production or the reporting database that backs the service. This property instructs the driver to indicate against which database the queries should be resolved. The default is report.
LoginTimeout The amount of time, in seconds, that the driver waits for a connection to be established before timing out the connection request. 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. The default behavior depends on which version of Oracle Service Cloud the site is using.
StmtCallLimitBehavior Specifies the behavior of the driver when the maximum Web service call limit specified by the StmtCallLimit property is exceeded. The default is errorAlways.
WSCompressData Specifies whether the driver compresses data it sends to or receives 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. The default behavior depends on which version of Oracle Service Cloud the site is using.
WSRetryCount The number of times the driver retries a timed-out Select request. Insert, Update, and Delete requests are never retried. By default, the driver does not retry timed-out requests after an initial, unsuccessful attempt.
WSTimeout Specifies the time, in seconds, that the driver waits for a response to a Web service request. The default is 120.

See also