This section lists the JDBC connection properties supported by the Oracle 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 DataDirect Connect Series for JDBC 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 Oracle driver and their default values.

Table 1. Oracle Driver Properties
Property Default
AccountingInfo empty string
Action empty string
AlternateServers None
ApplicationName empty string
AuthenticationMethod 
auto
BatchPerformanceWorkaround 
false
BulkLoadBatchSize 1000 (rows)
BulkLoadOptions 0 (the bulk load operation continues even if a value that can cause an index to be invalidated is loaded)
CatalogOptions 2 (result sets contain synonyms)
ClientHostName empty string
ClientID empty string
ClientUser empty string
CodePageOverride None
CommitBehavior serverDefault
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1 (data type check is performed if column value is null)
CryptoProtocolVersion

No default value
Database None
DatabaseName None
DataIntegrityLevel rejected
DataIntegrityTypes List of all possible values
EditionName None
EnableBulkLoad false
EnableCancelTimeout false
EnableServerResultCache false
EncryptionLevel rejected
EncryptionMethod noEncryption
EncryptionTypes List of all possible values
FailoverGranularity nonAtomic
FailoverMode connect
FailoverPreconnect false
FetchTSWTZasTimestamp false
HostNameInCertificate empty string
ImportStatementPool empty string
InitialColumnBufferSize -1 (automatically determined based on the width of the column being bound)
InitializationString None
InsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString false
JDBCBehavior 1
KeyPassword None
KeyStore None
KeyStorePassword None
LoadBalancing false
LoadLibraryPath None
LOBPrefetchSize 4000
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)
Module empty string
NewPassword None
Password None
PortNumber 1521
ProgramID empty string
QueryTimeout 0 (query does not time out)
RandomGenerator secureRandom
RegisterStatementPoolMonitorMBean false
ReportRecycleBin true
ResultSetMetaDataOptions 0 (no additional processing to determine the correct table name for each column in the result set)
SDUSize 8192
SecureRandomAlgorithm None
SendFloatParametersAsString false
ServerName None
ServerType None
ServiceName None
SID None
SpyAttributes None
StringParamsMustMatchCharColumns true
SupportBinaryXML false
SupportLinks false
SysLoginRole empty string
TNSNamesFile None
TNSServerName None
TrustStore None
TrustStorePassword None
User None
ValidateServerCertificate true
WireProtocolMode 2 (driver uses updated protocol)