skip to main content
Connection property descriptions
  

Try DataDirect Drivers Now

Connection property descriptions

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 DriverManager or a JDBC DataSource. 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). Connection property names are case-insensitive. For example, Password is the same as password.
Note: In a JDBC DataSource, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
The following table provides a summary of the connection properties supported by the driver, their corresponding data source methods, and their default values.
Table 22. Autonomous REST Connector Properties
Property
Data Source Method
Default
setAccessToken
None
setAuthenticationMethod
None
Note: The driver defaults to Custom when it discovers an entry for a custom authentication request in the input REST file.
setAuthHeader
Authorization
setAuthParam
None
setClientID
None
setClientSecret
None
setConfig
None
setConvertNull
1 (data type check is performed if column value is null)
setCreateMap
session
setCryptoProtocolVersion
None
setCustomAuthParams
None
setDebugRecord
None
setEncryptionMethod
noEncryption
setFetchSize
100 (rows)
setHostNameInCertificate
Empty string
setImportStatementPool
Empty string
setInsensitiveResultSetBufferSize
2048 (KB of memory)
setKeyPassword
None
setKeyStore
None
setKeyStorePassword
None
setLogConfigFile
ddlogging.properties
setLoginTimeout
0 (no timeout)
setLogoffURI
None
setMaxPooledStatements
0 (driver’s internal prepared statement pooling is not enabled)
setAuthCode
None
setPassword
None
setPortNumber
When SSL encryption is enabled:
80
When SSL encryption is disabled:
443
setProxyHost
Empty string
setProxyPassword
Empty string
setProxyPort
0
setProxyUser
Empty string
setReadAhead
0
setRedirectURI
None
setRefreshDirtyCache
1
setRefreshSchema
true
setRegisterStatementPoolMonitorMBean
false
setRefreshToken
None
setSample
None
setSchemaMap
For Windows:
<application_data_folder>\
Local\Progress\DataDirect
\AutoREST_Schema\
For UNIX/Linux:
~/progress/datadirect/
AutoREST_Schema/
setScope
None
setSecurityToken
None
setServerName
None
setSpyAttributes
None
setStmtCallLimit
0 (no limit)
setStmtCallLimitBehavior
errorAlways
setTable
None
setTokenURI
None
setTrustStore
None
setTrustStorePassword
None
setUser
None
setValidateServerCertificate
true
setWSFetchSize
0 (maximum number of rows as set by the maximumPageSize property. The default maximum is 10,000 rows.)
setWSPoolSize
1
setWSRetryCount
5
setWSTimeout
120 (seconds)
* AccessToken
* AuthenticationMethod
* AuthHeader
* AuthParam
* ClientID
* ClientSecret
* Config
* ConvertNull
* CreateMap
* CryptoProtocolVersion
* CustomAuthParams
* DebugRecord
* EncryptionMethod
* FetchSize
* HostNameInCertificate
* ImportStatementPool
* InsensitiveResultSetBufferSize
* JDBCBehavior
* KeyPassword
* KeyStore
* KeyStorePassword
* LogConfigFile
* LoginTimeout
* LogoffURI
* MaxPooledStatements
* OAuthCode
* Password
* PortNumber
* ProxyHost
* ProxyPassword
* ProxyPort
* ProxyUser
* ReadAhead
* RedirectURI
* RefreshDirtyCache
* RefreshSchema
* RefreshToken
* RegisterStatementPoolMonitorMBean
* Sample
* SchemaMap
* Scope
* SecurityToken
* ServerName
* SpyAttributes
* StmtCallLimit
* StmtCallLimitBehavior
* Table
* TokenURI
* TrustStore
* TrustStorePassword
* User
* ValidateServerCertificate
* WSFetchSize
* WSPoolSize
* WSRetryCount
* WSTimeout