skip to main content
DataDirect Connect Drivers : Informix Driver : Connection Properties
  
Connection Properties
This section lists the JDBC connection properties supported by the Informix driver and describes each property. The properties have the form:
property=value
You can use these connection properties with either the JDBC Driver Manager or DataDirect Connect Series for JDBC data sources unless otherwise noted.
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
The following table provides a summary of the connection properties supported by the Informix driver and their default values.
Table 33. Informix Driver Properties
Property
Default
empty string
None
empty string
2048 (rows)
2
empty string
empty string
None
5
1 (second)
1 (data type check is performed if column value is null)
None
None
None
nonAtomic
connect
false
32767 (bytes)
empty string
None
None
1000 (KB of memory)
false
1
false
0 (no timeout)
0 (driver’s internal prepared statement pooling is not enabled)
0 (driver’s internal prepared statement pooling is not enabled)
None
Varies depending on operating system
empty string
0 (query does not time out)
0 (no additional processing to determine the correct table name for each column in the result set)
None
None
true
None
This section includes the following topics:
* AccountingInfo
* AlternateServers
* ApplicationName
* BulkLoadBatchSize
* CatalogOptions
* ClientHostName
* ClientUser
* CodePageOverride
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* Database
* DatabaseName
* DBDate
* FailoverGranularity
* FailoverMode
* FailoverPreconnect
* FetchBufferSize
* ImportStatementPool
* InformixServer
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* JDBCBehavior
* LoadBalancing
* LoginTimeout
* MaxPooledStatements
* MaxStatements
* Password
* PortNumber
* ProgramID
* QueryTimeout
* ResultSetMetaDataOptions
* ServerName
* SpyAttributes
* UseDelimitedIdentifier
* User