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 18. Salesforce Driver Properties
Property
Data Source Method
Default
setAccessToken
None
setAuthenticationMethod
userIDPassword
setBulkFetchThreshold
30000 (rows)
setBulkLoadAsync
0 (bulk load operations are synchronous)
setBulkLoadBatchSize
1000 (rows)
setBulkLoadConcurrencyMode
parallel
setBulkLoadPollInterval
10 (seconds)
setBulkLoadThreshold
4000 (rows)
setCatalogOptions
2
setClientID
None
setClientSecret
None
Important: The configuration options have been deprecated. However, the driver will continue to support them until the next major release of the driver.
setConfigOptions
AuditColumns=all;
CustomSuffix=include;
KeywordConflictSuffix=;
MapSystemColumnNames=0;
NumberFieldMapping=emulateInteger;
UppercaseIdentifiers=true
setConnectionRetryCount
5
setConnectionRetryDelay
1 (second)
setConvertNull
1 (data type check is performed if column value is null)
setCreateMap
notExist
setEnableBulkFetch
true
setEnableBulkLoad
true
setEnablePKChunking
true
setFetchSize
100 (rows)
setImportStatementPool
empty string
setInitializationString
None
setInsensitiveResultSetBufferSize
2048 (KB of memory)
setJavaDoubleToString
false
setLogConfigFile
ddlogging.properties
setLoginTimeout
0 (no timeout)
setMaxPooledStatements
0 (driver’s internal prepared statement pooling is not enabled)
setPassword
None
setPKChunkSize
100000 (rows)
setProxyHost
empty string
setProxyPassword
empty string
setProxyPort
0
setProxyUser
empty string
setReadyOnly
false
setRefreshToken
None
setRegisterStatementPoolMonitorMBean
false
setSchemaMap
For Windows:
<application_data_folder>\
Local\Progress\DataDirect
\SForce_Schema\
<user_name>.config
For UNIX/Linux:
˜/progress/datadirect/
SForce_Schema/
<user_name>.config
setSecurityToken
None
setServerName
login.salesforce.com
setSpyAttributes
None
setStmtCallLimit
100 (Web service calls)
setStmtCallLimitBehavior
errorAlways
setTransactionMode
noTransactions
setUser
None
setWSCompressData
compress
setWSFetchSize
0 (maximum of 2000 rows)
setWSPoolSize
1
setWSRetryCount
0 (no retries for timed-out requests)
setWSTimeout
120 (seconds)
* AccessToken
* AuthenticationMethod
* BulkFetchThreshold
* BulkLoadAsync
* BulkLoadBatchSize
* BulkLoadConcurrencyMode
* BulkLoadPollInterval
* BulkLoadThreshold
* CatalogOptions
* ClientID
* ClientSecret
* ConfigOptions
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* CreateMap
* EnableBulkFetch
* EnableBulkLoad
* EnablePKChunking
* FetchSize
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* LogConfigFile
* LoginTimeout
* MaxPooledStatements
* Password
* PKChunkSize
* ProxyHost
* ProxyPassword
* ProxyPort
* ProxyUser
* ReadOnly
* RefreshToken
* RegisterStatementPoolMonitorMBean
* SchemaMap
* SecurityToken
* ServerName
* SpyAttributes
* StmtCallLimit
* StmtCallLimitBehavior
* TransactionMode
* User
* WSCompressData
* WSFetchSize
* WSPoolSize
* WSRetryCount
* WSTimeout