You can use connection properties to customize the driver for your environment. This section organizes connection properties according to functionality. You can use connection properties with either the JDBC DriverManager or a JDBC data source. For a DriverManager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setproperty(value).

Note:
  • In a JDBC data source, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").
  • The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.

The following tables describe the connection properties by functionality.

General properties

The following table summarizes connection properties required to connect to a database.

Property Data Source Method Default
DatabaseName setDatabaseName

getDatabaseName

 No default value
InformixServer setInformixServer

getInformixServer

 No default value
PortNumber setPortNumber

getPortNumber

 No default value
ServerName setServerName

getServerName

 No default value

User ID/password authentication properties

The following table summarizes the connection properties required for user ID/password authentication.

Property Data Source Method Default
User setUser

getUser

 No default value
Password setPassword

getPassword

 No default value

Bulk load properties

The following table contains the only connection property that affects how bulk load works with the driver.

Property Data Source Method Default
BulkLoadBatchSize setBulkLoadBatchSize

getBulkLoadBatchSize

 1000

Failover properties

The following table summarizes the connection properties used for configuring failover.

Property Data Source Method Default
AlternateServers setAlternateServers

getAlternateServers

 No default value
ConnectionRetryCount setConnectionRetryCount

getConnectionRetryCount

 5
ConnectionRetryDelay setConnectionRetryDelay

getConnectionRetryDelay

 1 (second)
FailoverGranularity setFailoverGranularity

getFailoverGranularity

 nonAtomic
FailoverMode setFailoverMode

getFailoverMode

 connect
FailoverPreconnect setFailoverPreconnect

getFailoverPreconnect

 false
LoadBalancing setLoadBalancing

getLoadBalancing

 false

Timeout properties

The following table summarizes timeout connection properties.

Property Data Source Method Default
LoginTimeout setLoginTimeout

getLoginTimeout

 0
QueryTimeout setQueryTimeout

getQueryTimeout

 0

Client information properties

The following table summarizes connection properties that can be used to return client information.

Property Data Source Method Default
AccountingInfo setAccountingInfo

getAccountingInfo

 No default value
ApplicationName setApplicationName

getApplicationName

 No default value
ClientHostName setClientHostName

getClientHostName

 No default value
ClientUser setClientUser

getClientUser

 No default value
ProgramID setProgramID

getProgramID

 No default value

Statement pooling properties

The following table summarizes statement pooling connection properties.

Property Data Source Method Default
ImportStatementPool setImportStatementPool

getImportStatementPool

 No default value
MaxPooledStatements setMaxPooledStatements

getMaxPooledStatements

 0
RegisterStatementPoolMonitorMBean setRegisterStatementPoolMonitorMBean

getRegisterStatementPoolMonitorMBean

 false

Additional properties

The following table summarizes additional connection properties.

Property Data Source Method Default
CatalogOptions setCatalogOptions

getCatalogOptions

 2
CodePageOverride setCodePageOverride

getCodePageOverride

 No default value
ConvertNull setConvertNull

getConvertNull

 1
DBDate setDBDate

getDBDate

 No default value
FetchBufferSize setFetchBufferSize

getFetchBufferSize

 32767
InitializationString setInitializationString

getInitializationString

 No default value
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize

getInsensitiveResultSetBufferSize

 2048
JavaDoubleToString setJavaDoubleToString

getJavaDoubleToString

 false
JDBCBehavior setJDBCBehavior

getJDBCBehavior

 1
ResultSetMetaDataOptions setResultSetMetaDataOptions

getResultSetMetaDataOptions

 0
SpyAttributes setSpyAttributes

getSpyAttributes

 No default value
UseDelimitedIdentifier setUseDelimitedIdentifier

getUseDelimitedIdentifier

 true