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: Connection property names are case-insensitive. For example, Password is the same as password.
Note: In a JDBC data source, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").

The following tables describe the connection properties by functionality.

Authentication properties

The following table summarizes properties used for Basic and Bearer Token authentication methods.

Property Data Source Method Default
ServerName getServerName()

setServerName(String)

 No default value
AuthenticationMethod getAuthenticationMethod()

setAuthenticationMethod(String)

 Basic
Password getPassword()

setPassword(String)

 No default value
SecurityToken getSecurityToken()

setSecurityToken(String)

 No default value
User getUser()

setUser(String)

 No default value

Proxy server properties

The following table summarizes proxy server connection properties.

Property Data Source Method Default
ProxyHost getProxyHost()

setProxyHost(String)

 No default value
ProxyPassword getProxyPassword()

setProxyPassword(String)

 No default value
ProxyPort getProxyPort()

setProxyPort(Integer)

 0 which means the default is determined by the ProxyHost property.

For HTTP URLs: 80

For HTTPS URLs: 443
ProxyUser getProxyUser()

setProxyUser(String)

 No default value

Timeout properties

The following table summarizes timeout connection properties.

Property Data Source Method Default
WSRetryCount getWsRetryCount()

setWsRetryCount(Integer)

 5
WSTimeout getWsTimeout()

setWsTimeout(Integer)

 120 (seconds)

Additional properties

The following table summarizes additional connection properties.

Property Data Source Method Default
DebugRecord getDebugRecord()

setDebugRecord(String)

 0 (Disabled)
DefaultQueryOptions getDefaultQueryOptions()

setDefaultQueryOptions(String)

 No default value
FetchSize getFetchSize()

setFetchSize(Integer)

 100 (rows)
LogConfigFile getLogConfigFile()

setLogConfigFile(String)

 ddlogging.properties
ReadAhead getReadAheadThreads()

setReadAheadThreads(Integer)

 5
SpyAttributes getSpyAttributes()

setSpyAttributes(String)

 No default value
StmtCallLimit getStmtCallLimit()

setStmtCallLimit(Integer)

 0
StmtCallLimitBehavior getStmtCallLimitBehavior()

setStmtCallLimitBehavior(String)

 ErrorAlways