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: