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 data source. 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).

Note:
  • In a JDBC data source, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").
  • The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.

The following table provides a summary of the connection properties supported by the driver, their corresponding data source methods, and their default values.

Table 1. Oracle Driver Properties
Property Data source method Default
AccountingInfo setAccountingInfo Empty string
Action setAction Empty string
AlternateServers setAlternateServers None
ApplicationName setApplicationName Empty string
AuthenticationMethod setAuthenticationMethod auto
BatchMechanism setBatchMechanism None
BulkLoadBatchSize setBulkLoadBatchSize 1000 (rows)
BulkLoadOptions setBulkLoadOptions 0 (the bulk load operation continues even if a value that can cause an index to be invalidated is loaded)
CatalogOptions setCatalogOptions 2 (result sets contain synonyms)
ClientHostName setClientHostName Empty string
ClientID setClientID Empty string
ClientUser setClientUser Empty string
CodePageOverride setCodePageOverride None
CommitBehavior setCommitBehavior serverDefault
ConnectionRetryCount setConnectionRetryCount 5
ConnectionRetryDelay setConnectionRetryDelay 1 (second)
ConvertNull setConvertNull 1 (data type check is performed if column value is null)
CryptoProtocolVersion setCryptoProtocolVersion

No default value
Database setDatabase None
DatabaseName setDatabaseName None
DataIntegrityLevel setDataIntegrityLevel accepted
DataIntegrityTypes setDataIntegrityTypes List of all possible values
EditionName setEditionName None
EnableBulkLoad setEnableBulkLoad false
EnableCancelTimeout setEnableCancelTimeout false
EnableServerResultCache setEnableServerResultCache false
EncryptionLevel setEncryptionLevel accepted
EncryptionMethod setEncryptionMethod noEncryption
EncryptionTypes setEncryptionTypes List of all possible values
EntraAccessToken setEntraAccessToken None
FailoverGranularity setFailoverGranularity nonAtomic
FailoverMode setFailoverMode connect
FailoverPreconnect setFailoverPreconnect false
FetchTSWTZasTimestamp setFetchTSWTZasTimestamp false
GSSCredential setGSSCredential Null
HostNameInCertificate setHostNameInCertificate Empty string
ImpersonateUser setImpersonateUser None
ImpersonateUserPassword setImpersonateUserPassword None
ImportStatementPool setImportStatementPool Empty string
InitialColumnBufferSize setInitialColumnBufferSize -1 (automatically determined based on the width of the column being bound)
InitializationString setInitializationString None
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString setJavaDoubleToString false
JDBCBehavior setJDBCBehavior 1
KeyPassword setKeyPassword None
KeyStore setKeyStore None
KeyStorePassword setKeyStorePassword None
LDAPCryptoProtocolVersion setLDAPCryptoProtocolVersion None
LDAPDistinguishedName setLDAPDistinguishedName None
LDAPEncryptionMethod setLDAPEncryptionMethod noEncryption
LDAPHostNameInCertificate setLDAPHostNameInCertificate None
LDAPKeyPassword setLDAPKeyPassword None
LDAPKeyStore setLDAPKeyStore None
LDAPKeyStorePassword setLDAPKeyStorePassword None
LDAPLoginTimeout setLDAPLoginTimeout 0
LDAPPassword setLDAPPassword None
LDAPQueryTimeout setLDAPQueryTimeout 0
LDAPTrustStore setLDAPTrustStore None
LDAPTrustStorePassword setLDAPTrustStorePassword None
LDAPUser setLDAPUser None
LDAPValidateServerCertificate setLDAPValidateServerCertificate true
LoadBalancing setLoadBalancing false
LoadLibraryPath setLoadLibraryPath None
LOBPrefetchSize setLOBPrefetchSize 4000
LoginTimeout setLoginTimeout 0 (no timeout)
MaxPooledStatements setMaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxStatements setMaxStatements 0 (driver’s internal prepared statement pooling is not enabled)
Module setModule Empty string
NewPassword setNewPassword None
PadNumberFieldsToScale setPadNumberFieldsToScale true
Password setPassword None
PortNumber setPortNumber Database server:1521

LDAP server (unencrypted): 389

LDAP server (encrypted): 636
ProgramID setProgramID Empty string
ProxyHost setProxyHost Empty string
ProxyPassword setProxyPassword Empty string
ProxyPort setProxyPort 0
ProxyUser setProxyUser Empty string
QueryTimeout setQueryTimeout 0 (query does not time out)
RandomGenerator setRandomGenerator secureRandom
RegisterStatementPoolMonitorMBean setRegisterStatementPoolMonitorMBean false
ResultSetMetaDataOptions setResultSetMetaDataOptions 0 (no additional processing to determine the correct table name for each column in the result set)
SDUSize setSDUSize 16384
SecureRandomAlgorithm setSecureRandomAlgorithm None
SendFloatParametersAsString setSendFloatParametersAsString false
ServerName setServerName None
ServerType setServerType None
ServiceName setServiceName None
SID setSID None
SpyAttributes setSpyAttributes None
StringParamsMustMatchCharColumns setStringParamsMustMatchCharColumns true
SupportBinaryXML setSupportBinaryXML false
SupportLinks setSupportLinks false
SysLoginRole setSysLoginRole Empty string
TNSNamesFile setTNSNamesFile None
TNSServerName setTNSServerName None
TrustStore setTrustStore None
TrustStorePassword setTrustStorePassword None
User setUser None
ValidateServerCertificate setValidateServerCertificate true