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 1. Salesforce Driver Properties
Property Default
BulkLoadAsync 0 (bulk load operations are synchronous)
BulkLoadBatchSize 1000 (rows)
BulkLoadConcurrencyMode parallel
BulkLoadPollInterval 10 (seconds)
BulkLoadThreshold 4000 (rows)
CatalogOptions 2
ConfigOptions 
AuditColumns=none;CustomSuffix=strip;
KeywordConflictSuffix=;MapSystemColumnNames=1;
NumberFieldMapping=emulateInteger;
UppercaseIdentifiers=true
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1 (data type check is performed if column value is null)
CreateDB notExist
Database User ID specified for the connection
DatabaseName User ID specified for the connection
EnableBulkLoad false
FetchSize 100 (rows)
ImportStatementPool empty string
InitializationString None
InsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString false
LogConfigFile ddlogging.properties
LoginTimeout 0 (no timeout)
MaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxStatements 0 (driver’s internal prepared statement pooling is not enabled)
Password None
ProxyHost empty string
ProxyPassword empty string
ProxyPort 0
ProxyUser empty string
ReadOnly false
RefreshDirtyCache 1
RefreshSchema false
RegisterStatementPoolMonitorMBean false
SecurityToken None
ServerName login.salesforce.com
StmtCallLimit 20 (Web service calls)
StmtCallLimitBehavior errorAlways
TransactionMode noTransactions
User None
WSCompressData compress
WSFetchSize 0 (maximum of 2000 rows)
WSRetryCount 0 (no retries for timed-out requests)
WSTimeout 120 (seconds)