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:

User ID/password authentication properties

The following table summarizes the connection properties required to connect to a service when using user ID/password authentication.

Table 1. Required properties
Property Data Source Method Default
AuthenticationMethod

getAuthenticationMethod()

setAuthenticationMethod(String)

 userIDPassword
LoginHost

getLoginHost()

setLoginHost(String)

 Empty string
Password getPassword()

setPassword(String)

 No default value
ServerName

getServerName()

setServerName(String)

 No default value
User

getUser()

setUser(String)

 No default value

Failover properties

The following table summarizes the connection properties used for configuring failover.

Table 2. Failover Properties
Property Data Source Method Default
ConnectionRetryCount getConnectionRetryCount()

setConnectionRetryCount(Integer)

 5
ConnectionRetryDelay getConnectionRetryDelay()

setConnectionRetryDelay(Integer)

 1

Proxy server properties

The following table summarizes the proxy server connection properties.

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

Statement pooling properties

The following table summarizes statement pooling connection properties.

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

setImportStatementPool(String)

 No default value
MaxPooledStatements getMaxPooledStatements()

setMaxPooledStatements(Integer)

 0
RegisterStatementPoolMonitorMBean getRegisterStatementPoolMonitor Mbean()

setRegisterStatementPoolMonitor Mbean(Boolean)

 false

Web service properties

The following table summarizes the web service connection properties.

Table 5. Web Service Properties
Property Data Source Method Default
StmtCallLimit getStmtCallLimit()

setStmtCallLimit(Integer)

 -1
StmtCallLimitBehavior getStmtCallLimitBehavior()

setStmtCallLimitBehavior(String)

 errorAlways
WSCompressData

getWSCompressData()

setWSCompressData(String)

 compress
WSFetchSize

getWSFetchSize()

setWSFetchSize(Integer)

 0
WSPoolSize

getWsPoolSize()

setWsPoolSize(Integer)

 1
WSRetryCount

getWSRetryCount()

setWSRetryCount(Integer)

 5
WSTimeout

getWSTimeout()

setWSTimeout(Integer)

 120

Additional properties

The following table summarizes additional connection properties.

Table 6. Additional Properties
Property Data Source Method Default
AuditColumns

getAuditColumns()

setAuditColumns(String)

 All
ConvertNull

getConvertNull()

setConvertNull(Boolean)

 true
CreateMap

getCreateMap()

setCreateMap(String)

 Session
CustomSuffix

getCustomSuffix()

setCustomSuffix(String)

 Strip
DebugRecord

getDebugRecord()

setDebugRecord(String)

No default value
EnableAccessRequestHeader

getEnableAccessRequest Header()

setEnableAccessRequest Header(Boolean)

 true
EnablePagingWithOrderByID

getEnablePagingWithOrder ById()

setEnablePagingWithOrder ById(Boolean)

 true
FetchSize

getFetchSize()

setFetchSize(Integer)

 100
InitializationString

getInitializationString()

setInitializationString(String)

 No default value
InsensitiveResultSetBufferSize

getInsensitiveResultset BufferSize()

setInsensitiveResultset BufferSize(Integer)

 2048
JavaDoubleToString

getJavaDoubleToString()

setJavaDoubleToString(Boolean)

 No default value
KeywordConflictSuffix

getKeywordConflictSuffix()

setKeywordConflictSuffix(String)

 No default value
LogConfigFile

getLogConfigFile()

setLogConfigFile(String)

 ddlogging.properties
LoginTimeout

getLoginTimeout()

setLoginTimeout(Integer)

 0
ManagedObjects

getManagedObjects()

setManagedObjects(String)

 Empty string
MapCustomNamedIDFields

getMapCustomNamedIdFields()

setMapCustomNamedIdFields(Boolean)

 true
MapSystemColumnNames

getMapSystemColumnNames()

setMapSystemColumnNames(Boolean)

 false
NamedIDBehavior

getNamedIdBehavior()

setNamedIdBehavior(String)

 All
OracleServiceCloudDatabase

getOracleServiceCloudDatabase()

setOracleServiceCloudDatabase(String)

 report
ReadOnly

getReadOnly()

setReadOnly(Boolean)

 true
SchemaMap

getSchemaMap()

setSchemaMap(String)
  • For Windows platforms
    • User data source: <user_profile>\AppData\ Local\Progress\DataDirect\ <driver>_Schema\<user_name> .config
    • System data source: C:\Users\Default\AppData\ Local\Progress\DataDirect\ <driver>_Schema\<user_name> .config
  • For UNIX/Linux
    • ~/progress/datadirect/ <driver>_schema/<user_name> .config
SOAPAppIDString

getSoapAppidString()

setSoapAppidString(String)

 DataDirect_JDBC
SpyAttributes

getSpyAttributes()

setSpyAttributes(String)

 No default value
TransactionMode

getTransactionMode()

setTransactionMode(String)

 NoTransactions
UppercaseIdentifiers

getUppercaseIdentifiers()

setUppercaseIdentifiers(Boolean)

 true