The following table summarizes additional connection properties.

Table 1. Additional Properties
Property Characteristic

ArrayFetchSize

Specifies the number of fields the driver uses to calculate the maximum number of rows for a fetch. When executing a fetch, the driver divides the ArrayFetchSize value by the number of columns in a particular table to determine the number of rows to retrieve. By determining the fetch size based on the number of fields, the driver can avoid out of memory errors when fetching from tables containing a large number of columns while continuing to provide improved performance when fetching from tables containing a small number of columns.

If set to -x, the driver overrides any settings on the statement level and uses the number of fields specified by the absolute value of -x to calculate the number of rows to retrieve.

If set to x, the driver uses the number of fields specified by the value of x to calculate the number of rows to retrieve. However, the driver will not override settings, such as setFetchSize(), on the statement level.

The default is 20000.

ConnectionRetryCount

Specifies the number of times the driver retries connection attempts to the server until a successful connection is established. .

If set to 0, the driver does not try to reconnect after the initial unsuccessful attempt.

If set to x, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an exception that is generated by the last server to which it tried to connect.

The default is 5.

ConnectionRetryDelay

Specifies the number of seconds the driver waits between connection retry attempts when ConnectionRetryCount is set to a positive integer.

If set to 0, the driver does not delay between retries.

If set to x, the driver waits between connection retry attempts the specified number of seconds.

The default is 1.

InitializationString

Specifies one or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver throws an exception indicating which SQL command or commands failed.

InsensitiveResultSetBufferSize

Determines the amount of memory used by the driver to cache insensitive result set data.

If set to -1, the driver caches insensitive result set data in memory.

If set to 0, the driver caches insensitive result set data in memory, up to a maximum of 2 MB.

If set to x, the driver caches insensitive result set data in memory and uses this value to set the size (in KB) of the memory buffer for caching insensitive result set data.

The default is 2048.

RemoveColumnQualifiers

Specifies whether the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers.

If set to true (enabled), the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers.

If set to false, the driver does not modify the request.

The default is false.

SpyAttributes

Enables DataDirect Spy to log detailed information about calls issued by the driver on behalf of the application. DataDirect Spy is not enabled by default.

TransactionMode

Specifies how the driver handles manual transactions.

If set to ignore, the data source does not support transactions and the driver always operates in auto-commit mode.

If set to noTransactions, the data source and the driver do not support transactions.

The default is noTransactions.

UseCurrentSchema

Specifies whether results are restricted to the tables and views in the current schema if a call is made without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables and views in the current schema improves performance of calls that do not specify a schema.

If set to true, the results that are returned from getTables() and getColumns() methods are restricted to the tables and views in the current schema.

If set to false, the results that are returned from getTables() and getColumns() methods are not restricted.

The default is false.