Connection property descriptions

Table 19. 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	None
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
FailoverGranularity	setFailoverGranularity	nonAtomic
FailoverMode	setFailoverMode	connect
FailoverPreconnect	setFailoverPreconnect	false
FetchTSWTZasTimestamp	setFetchTSWTZasTimestamp	false
GSSCredential	setGSSCredential	Null
HostNameInCertificate	setHostNameInCertificate	Empty string
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
LDAPDistinguishedName	setLDAPDistinguishedName	None
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
Password	setPassword	None
PortNumber	setPortNumber	1521
ProgramID	setProgramID	Empty string
QueryTimeout	setQueryTimeout	0 (query does not time out)
RandomGenerator	setRandomGenerator	secureRandom
RegisterStatementPoolMonitorMBean	setRegisterStatementPoolMonitorMBean	false
ReportRecycleBin	setReportRecycleBin	true
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