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 Driver Manager or a JDBC data source. For a Driver Manager 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
ConfigOptions setConfigOptions APIVersion=latest
CreateMap setCreateMap notExist
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
ServerName setServerName No default value
SpyAttributes setSpyAttributes No default value
User setUser No default value
WSFetchSize setWSFetchSize 100 (rows)
WSRetryCount setWSRetryCount 0
WSTimeout setWSTimeout 120 (seconds)