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:

Basic connection properties

The following table summarizes connection properties which are required to connect to a Aha! data source.

Table 1. Required Properties
Property Data Source Method Default
ServerName getServerName()

setServerName(String)

 No default value
Password getProxyPassword()

setProxyPassword(String)

 No default value
User getUser()

setUser(String)

 No default value

URL parameter authentication properties

The following table summarizes connection properties used for URL parameter authentication.

Table 2. URL parameter authentication properties
Property Data Source Method Default
AuthenticationMethod getAuthenticationMethod()

setAuthenticationMethod(String)

 Basic
SecurityToken getSecurityToken()

setSecurityToken(String)

 No default value

OAuth 2.0 properties

The following table summarizes properties used for OAuth 2.0 authentication. The OAuth 2.0 properties you must specify depend on the grant type used in your environment. If you are unsure of the grant type or its requirements, contact your system administrator. For details on supported grant types, see OAuth 2.0 authentication.

Table 3. OAuth 2.0 properties
Property Data Source Method Default
AccessToken getAccessToken()

setAccessToken(String)

 No default value
AuthenticationMethod getAuthenticationMethod()

setAuthenticationMethod(String)

 Basic
ClientID getClientId()

setClientId(String)

 No default value
ClientSecret getClientSecret()

setClientSecret(String)

 No default value
OAuthCode getOauthCode()

setOauthCode(String)

 No default value
RedirectURI getOauthRedirUri()

setOauthRedirUri(String)

 No default value

Mapping properties

The following table summarizes connection properties involved in mapping the Aha! data model to a SQL model.

Property Data Source Method Default
CreateMap getCreateMap()

setCreateMap(String)

 Session
RefreshSchema getRefreshSchema()

setRefreshSchema(Boolean)

 false
SchemaMap getSchemaMap()

setSchemaMap(String)

 Default depends on the environment

Proxy server properties

The following table summarizes proxy server connection properties.

Table 4. Proxy Server 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

Web service properties

The following table summarizes Web service connection properties, including those related to timeouts.

Table 5. Web Service Properties
Property Data Source Method Default
LoginTimeout getLoginTimeout()

setLoginTimeout(Integer)

 0 (no timeout)
StmtCallLimit getStmtCallLimit()

setStmtCallLimit(Integer)

 0 (no limit)
StmtCallLimitBehavior getStmtCallLimitBehavior()

setStmtCallLimitBehavior(String)

 errorAlways
WSFetchSize getWsFetchSize()

setWsFetchSize(Integer)

 2000
WSPoolSize getWsPoolSize()

setWsPoolSize(Integer)

 1
WSRetryCount getWsRetryCount()

setWsRetryCount(Integer)

 5
WSTimeout getWsTimeout()

setWsTimeout(Integer)

 120

Data type properties

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

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

setConvertNull(Boolean)

 true
JDBCBehavior getJdbcBehavior()

setJdbcBehavior(Integer)

 1 (data types described using JDBC 3.0-equivalent data types)

Timeout properties

The following table summarizes timeout connection properties.

Table 7. Timeout Properties
Property Data Source Method Default
LoginTimeout getLoginTimeout()

setLoginTimeout(Integer)

 0 (no timeout)
QueryTimeout getQueryTimeout()

setQueryTimeout(Integer)

 0 (no timeout)
WSRetryCount getWsRetryCount()

setWsRetryCount(Integer)

 5
WSTimeout getWsTimeout()

setWsTimeout(Integer)

 120 (seconds)

Statement pooling properties

The following table summarizes statement pooling connection properties.

Table 8. 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

Additional properties

The following table summarizes additional connection properties.

Table 9. Additional Properties
Property Data Source Method Default
ConnectionRetryCount

getConnectionRetryCount()

setConnectionRetryCount(Integer)

 5
ConnectionRetryDelay getConnectionRetryDelay()

setConnectionRetryDelay(Integer)

 1
DebugRecord getDebugRecord()

setDebugRecord(String)

 No default value
FetchSize getFetchSize()

setFetchSize(Integer)

 100 (rows)
InitializationString getInitializationString()

setInitializationString(String)

 No default value
InsensitiveResultSetBufferSize getInsensitiveResultsetBufferSize()

setInsensitiveResultsetBufferSize(Integer)

 2048 (KB of memory)
LogConfigFile getLogConfigFile()

setLogConfigFile(String)

 ddlogging.properties
ReadAhead getReadAheadThreads()

setReadAheadThreads(Integer)

 0
SpyAttributes getSpyAttributes()

setSpyAttributes(String)

 No default value