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:
  • 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 tables describe the connection properties by functionality.

General properties

The following table summarizes the properties that are required for connection.

Property Data Source Method Default
AuthenticationMethod getAuthenticationMethod()

setAuthenticationMethod(String)

 UserIDPassword
DatabaseName getDatabaseName()

setDatabaseName(String)

 No default value
PortNumber getPortNumber()

setPortNumber(Integer)

 21050
ServerName getServerName()

setServerName(String)

 None

UserID/Password authentication properties

The following table summarizes properties used for UserID/Password authentication method.

Property Data Source Method Default
Password getPassword()

setPassword(String)

 No default value
User getUser()

setUser(String)

 No default value

Kerberos authentication properties

The following table summarizes properties used for Kerberos authentication method.

Property Data Source Method Default
ImpersonateUser getImpersonateUser()

setImpersonateUser(String)

 No default value
LoginConfigName getLoginConfigName()

setLoginConfigName(String)

 JDBC_DRIVER_01

ServicePrincipalName

 getServicePrincipalName()

setServicePrincipalName(String)

 None

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

Data type properties

The following table summarizes connection properties which can be used to handle data types.

Table 1. Data Type Properties
Property Data Source Method Default
ConvertNull getConvertNull()

setConvertNull(Boolean)

 1
JavaDoubleToString getJavaDoubleToString()

setJavaDoubleToString(Boolean)

 false
StringDescribeType getStringDescribeType()

setStringDescribeType(String)

 varchar

Data encryption properties

The following table summarizes data encryption connection properties.

Property Data Source Method Default
CryptoProtocolVersion getCryptoProtocolVersion()

setCryptoProtocolVersion(String)

 The default is determined by the settings of the JRE.
EncryptionMethod getEncryptionMethod()

setEncryptionMethod(String)

 noEncryption
HostNameInCertificate getHostNameInCertificate()

setHostNameInCertificate(String)

 None
KeyPassword getKeyPassword()

setKeyPassword(String)

 None
KeyStore getKeyStore()

setKeyStore(String)

 None
KeyStorePassword getKeyStorePassword()

setKeyStorePassword(String)

 None
TrustStore getTrustStore()

setTrustStore(String)

 None
TrustStorePassword getTrustStorePassword()

setTrustStorePassword(String)

 None
ValidateServerCertificate getValidateServerCertificate()

setValidateServerCertificate(Boolean)

 true

Statement pooling properties

The following table summarizes statement pooling connection properties.

Table 2. Statement Pooling Properties
Property Data Source Method Default
ImportStatementPool getImportStatementPool()

setImportStatementPool(String)

 No default value
MaxPooledStatements getMaxPooledStatements()

setMaxPooledStatements(Integer)

 0
RegisterStatementPoolMonitorMBean getRegisterStatementPoolMonitorMbean()

setRegisterStatementPoolMonitorMbean(Boolean)

 false

Client information properties

The following table client information properties.

Property Data Source Method Default
AccountingInfo getAccountingInfo()

setAccountingInfo(String)

 None
ApplicationName getApplicationName()

setApplicationName(String)

 No default value
ClientHostName getClientHostName()

setClientHostName(String)

 No default value
ClientUser getClientUser()

setClientUser(String)

 No default value
ProgramID getProgramID()

setProgramID(String)

 No default value

Additional properties

The following table summarizes additional connection properties.

Property Data Source Method Default
ArrayFetchSize getArrayFetchSize()

setArrayFetchSize(Integer)

 20000 (fields)
ConnectionRetryCount getConnectionRetryCount()

setConnectionRetryCount(Integer)

 5
ConnectionRetryDelay getConnectionRetryDelay()

setConnectionRetryDelay(Integer)

 1
DefaultOrderByLimit setDefaultOrderByLimit

setDefaultOrderByLimit(Integer)

 -1
InitializationString getInitializationString()

setInitializationString(String)

 None
InsensitiveResultSetBufferSize getInsensitiveResultsetBufferSize()

setInsensitiveResultsetBufferSize(Integer)

 2048
LoginTimeout getLoginTimeout()

setLoginTimeout(Integer)

 0
RemoveColumnQualifiers getRemoveColumnQualifiers()

setRemoveColumnQualifiers(Boolean)

 false
SpyAttributes getSpyAttributes()

setSpyAttributes(String)

 None
TransactionMode getTransactionMode()

setTransactionMode(String)

 Full
UseCurrentSchema getUseCurrentSchema()

setUseCurrentSchema(Boolean)

 false