skip to main content
DataDirect Connect Drivers : Oracle Driver : Connection Properties
  
Connection Properties
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 43. Oracle Driver Properties
Property
Default
empty string
empty string
None
empty string
auto
false
1000 (rows)
None
2 (result sets contain synonyms)
empty string
empty string
empty string
None
serverDefault
5
1 (second)
1 (data type check is performed if column value is null)
None
None
rejected
List of all possible values
None
false
false
false
rejected
noEncryption
List of all possible values
nonAtomic
connect
false
false
empty string
empty string
-1 (automatically determined based on the width of the column being bound)
None
2048 (KB of memory)
false
1
None
None
None
false
None
0 (no timeout)
0 (driver’s internal prepared statement pooling is not enabled)
0 (driver’s internal prepared statement pooling is not enabled)
empty string
None
None
1521
empty string
0 (query does not time out)
true
0 (no additional processing to determine the correct table name for each column in the result set)
8192
false
None
None
None
None
None
true
false
empty string
None
None
None
None
None
true
2 (driver uses updated protocol)
This section includes the following topics:
* AccountingInfo
* Action
* AlternateServers
* ApplicationName
* AuthenticationMethod
* BatchPerformanceWorkaround
* BulkLoadBatchSize
* BulkLoadOptions
* CatalogOptions
* ClientHostName
* ClientID
* ClientUser
* CodePageOverride
* CommitBehavior
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* Database
* DatabaseName
* DataIntegrityLevel
* DataIntegrityTypes
* EditionName
* EnableBulkLoad
* EnableCancelTimeout
* EnableServerResultCache
* EncryptionLevel
* EncryptionMethod
* EncryptionTypes
* FailoverGranularity
* FailoverMode
* FailoverPreconnect
* FetchTSWTZasTimestamp
* HostNameInCertificate
* ImportStatementPool
* InitialColumnBufferSize
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* JDBCBehavior
* KeyPassword
* KeyStore
* KeyStorePassword
* LoadBalancing
* LoadLibraryPath
* LoginTimeout
* MaxPooledStatements
* MaxStatements
* Module
* NewPassword
* Password
* PortNumber
* ProgramID
* QueryTimeout
* ReportRecycleBin
* ResultSetMetaDataOptions
* SDUSize
* SendFloatParametersAsString
* ServerName
* ServerType
* ServiceName
* SID
* SpyAttributes
* StringParamsMustMatchCharColumns
* SupportLinks
* SysLoginRole
* TNSNamesFile
* TNSServerName
* TrustStore
* TrustStorePassword
* User
* ValidateServerCertificate
* WireProtocolMode