You can use connection properties to customize the driver for your environment. This section lists the connection properties supported by the driver and describes each property. You can use these connection properties with either the JDBC DriverManager or a JDBC DataSource. 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 table provides a summary of the connection properties supported by the driver, their corresponding data source methods, and their default values.

Table 1. Driver properties
Connection String Property Data Source Method Default Value
BulkActivityPageSize setBulkActivityPageSize 50000 (rows)
BulkPageSize setBulkPageSize 5000 (rows)
BulkTimeout setBulkTimeout 1800 (seconds)
BulkTopThreshold setBulkTopThreshold 1000 (rows)
Company setCompany No default value
ConfigOptions setConfigOptions 
CheckBoxAsText=0;
KeywordConflictSuffix=
CreateMap setCreateMap notExist
FailOnIncompleteData setFailOnIncompleteData 0
LogConfigFile setLogConfigFile ddlogging.properties
Password setPassword No default value
ProxyHost setProxyHost No default value
ProxyPassword setProxyPassword No default value
ProxyPort setProxyPort No default value
ProxyUser setProxyUser No default value
SchemaMap setSchemaMap Default value depends on environment
SpyAttributes setSpyAttributes No default value
User setUser No default value
WSFetchSize setWSFetchSize 1000 (rows)
WSRetryCount setWSRetryCount 0
WSTimeout setWSTimeout 120 (seconds)