The following table is an alphabetical list of connection properties with their default values. Each property is hyperlinked to its full description.

Note: The data type listed in each description is the Java data type used for the property value in a JDBC data source.
Table 1. Connection Properties with Defaults
Property Default
ConfigOptions 
AuditColumns=all;
MapCustomNamedIDFields=1;
MapSystemColumnNames=0;
UppercaseIdentifiers=true
ConvertNull 1 (data type check is performed if column value is null)
CreateDB notExist
DatabaseName user ID specified for the connection
EnableAccessRequestHeader true
EnablePagingWithOrderById true
FetchSize 100 (rows)
ImportStatementPool empty string
InitializationString none
InsensitiveResultSetBufferSize 2048 (KB of memory)
InterfaceName empty string
JavaDoubleToString false
LogConfigFile ddlogging.properties
LoginHost none
LoginTimeout 0 (no timeout)
ManagedObjects none
MaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
OracleServiceCloudDatabase report
Password none
ProxyHost empty string
ProxyPassword empty string
ProxyPort 0
ProxyUser empty string
RefreshDirtyCache 1
SpyAttributes none
StmtCallLimit -1
StmtCallLimitBehavior errorAlways
TransactionMode noTransactions
User none
WSCompressData compress
WSFetchSize 0
WSRetryCount 0 (no retries for timed-out requests)
WSTimeout 120 (seconds)