The following table summarizes additional connection properties.

Table 1. Additional Properties
Property Characteristic
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 Cloudera Impala 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 (second).
DefaultOrderByLimit Specifies the maximum number of rows returned when a SQL statement containing an ORDER BY clause is executed. Cloudera Impala 1.3 requires statements containing the ORDER BY clause to limit the number of rows returned. This option allows these statements to return a result set without specifying a limit in the application.

If set to -1 (disabled), there is no default limit to the number of rows returned by a statement containing an ORDER BY clause.

If set to x, the number of rows returned by a SQL statement containing an ORDER BY clause are limited to the specified number of rows for the session.

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

LoginTimeout Specifies 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.
Password Specifies a password that is used to connect to the database.
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 (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. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to throw an exception indicating that no transaction is started. Metadata indicates that the driver supports transactions and the READ UNCOMMITTED transaction isolation level.

If set to noTransactions, the data source and the driver do not support transactions. Metadata indicates that the driver does 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.
User Specifies the user name that is used to connect to the database.

See also