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.

The default is 20000 fields.

ArrayInsertSize Specifies the number of fields the driver uses to calculate the maximum number of rows sent in a packet when executing a multi-row insert. In most scenarios, the default setting for ArrayInsertSize provides the ideal driver behavior; however, you may need to reduce the value specified if you encounter the following:
  • Performance or memory issues when inserting large numbers of rows that contain large values.
  • The following error when inserting a large number of rows when using Apache Knox: HTTP/1.1 500 Server Error.

The default is 20000 fields.

BatchMechanism

Determines the mechanism that is used to execute batch operations.

If set to nativeBatch, the Hive native batch mechanism is used to execute batch operations, and an insert statement is executed for each row contained in a parameter array.

If set to multiRowInsert, the driver attempts to execute a single insert statement for all the rows contained in a parameter array. If the size of the insert statement exceeds the available buffer memory of the server, the driver executes multiple statements. This behavior provides substantial performance gains for batch inserts.

The default is multiRowInsert.
CatalogMode Specifies whether the driver uses native catalog functions to retrieve information returned by DatabaseMetaData functions.

If set to mixed, the driver uses a combination of native catalog functions and driver-discovered information to retrieve catalog information. Select this option for the optimal balance of performance and accuracy.

If set to native, the driver uses native catalog functions to retrieve information returned by DatabaseMetaData functions. This setting provides the best performance, but at the expense of less-accurate catalog information.

The default is mixed.

ConnectionRetryCount

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

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.

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. The default is 1.

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 (second).

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 (disabled), the driver does not modify the request.

The default is false (disabled).

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. Metadata indicates that the driver does not support transactions.

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.