The Web Service tab allows you to specify additional datasource settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.

Figure 1. Web Service tab

The Web Service Tab of the ODBC Oracle Service Cloud Driver Setup dialog box

On this tab, provide values for any of the options in the following table; then, click Apply. The table provides links to descriptions of the connection options.

Connection Options: Web Service Description
Compress Data Specifies whether the driver compresses data it sends to or receives from the web server.

If set to 0 - none, the driver sends and receives uncompressed data to and from the web server.

If set to 1 - compress, the driver sends and receives compressed data to and from the web server.

Default: 1 - compress
Statement Call Limit Specifies the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.

Default: -1
Statement Call Limit Behavior Specifies the behavior of the driver when the maximum Web service call limit specified by the Statement Call Limit option is exceeded.

If set to 1 - ErrorAlways, the driver returns an error if the maximum Web service call limit is exceed.

If set to 2 - 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.

Default: 1- ErrorAlways
WSFetchSize Specifies the number of rows of data the driver attempts to fetch for each ODBC call.

Default: 0
WSRetry Count 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 (number of retries), the driver retries the timed-out request the specified number of times.

Default: 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.

If a Select request times out and WSRetryCount (WSRC) is set to retry timed-out requests, the driver retries the request the specified number of times.

Default: 120 (seconds)

If you finished configuring your driver, proceed to Step 6 in "Data source configuration through a GUI." Optionally, you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:

  • General tab allows you to configure options that are required for creating a data source.
  • SQL Engine tab allows you to configure the SQL Engine's behavior.
  • Advanced behavior allows you to configure advanced behavior.
  • Pooling tab allows you to configure connection pooling behavior.