skip to main content
DataDirect Connect XE Drivers : Salesforce Driver : Connection Properties
  
Connection Properties
This section lists the connection properties supported by the Salesforce driver and describes each property. The properties have the form:
property=value
You can use these connection properties with either the JDBC Driver Manager or Salesforce driver data sources unless otherwise noted.
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such
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 Salesforce driver and their default values.
Table 87. Salesforce Driver Properties
Property
Default
0 (bulk load operations are synchronous)
1000 (rows)
parallel
10 (seconds)
4000 (rows)
2
AuditColumns=all;CustomSuffix=strip;
MapSystemColumnNames=1;
NumberFieldMapping=emulateInteger;
UppercaseIdentifiers=true
5
1 (second)
1 (data type check is performed if column value is null)
notExist
User ID specified for the connection
User ID specified for the connection
false
100 (rows)
empty string
None
2048 (KB of memory)
false
ddlogging.properties
0 (no timeout)
0 (driver’s internal prepared statement pooling is not enabled)
0 (driver’s internal prepared statement pooling is not enabled)
None
empty string
empty string
0
empty string
false
1
false
None
login.salesforce.com
20 (Web service calls)
errorAlways
noTransactions
None
compress
0 (maximum of 2000 rows)
0 (no retries for timed-out requests)
120 (seconds)
This section includes the following topics:
* BulkLoadAsync
* BulkLoadBatchSize
* BulkLoadConcurrencyMode
* BulkLoadPollInterval
* BulkLoadThreshold
* CatalogOptions
* ConfigOptions
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* CreateDB
* Database
* DatabaseName
* EnableBulkLoad
* FetchSize
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* LogConfigFile
* LoginTimeout
* MaxPooledStatements
* MaxStatements
* Password
* ProxyHost
* ProxyPassword
* ProxyPort
* ProxyUser
* ReadOnly
* RefreshDirtyCache
* RefreshSchema
* SecurityToken
* ServerName
* StmtCallLimit
* StmtCallLimitBehavior
* TransactionMode
* User
* WSCompressData
* WSFetchSize
* WSRetryCount
* WSTimeout