[JDBC] Oracle JDBC Driver Properties

Oracle JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
oracle.jdbc.RetainV9LongBindBehavior	null	false		false
user	null	false		null
database	null	false		null
autoCommit	null	false		true
protocol	null	false		null
oracle.jdbc.StreamChunkSize	null	false		16384
SetFloatAndDoubleUseBinary	null	false		false
oracle.jdbc.ocinativelibrary	null	false		null
v$session.terminal	null	false		unknown
v$session.machine	null	false		null
v$session.osuser	null	false		null
v$session.program	null	false		JDBC Thin Client
v$session.process	null	false		1234
v$session.iname	null	false		jdbc_ttc_impl
v$session.ename	null	false		null
oracle.net.profile	null	false		null
oracle.net.authentication_services	null	false		null
oracle.net.kerberos5_mutual_authentication	null	false		null
oracle.net.kerberos5_cc_name	null	false		null
oracle.net.encryption_client	null	false		null
oracle.net.encryption_types_client	null	false		null
oracle.net.crypto_checksum_client	null	false		null
oracle.net.crypto_checksum_types_client	null	false		null
oracle.net.crypto_seed	null	false		null
oracle.jdbc.TcpNoDelay	null	false		false
oracle.jdbc.ReadTimeout	null	false		null
oracle.net.CONNECT_TIMEOUT	null	false		null
oracle.net.disableOob	null	false		false
oracle.net.useZeroCopyIO	null	false		true
oracle.jdbc.use1900AsYearForTime	null	false		false
oracle.jdbc.timestampTzInGmt	null	false		true
oracle.jdbc.timezoneAsRegion	null	false		true
oracle.net.ssl_server_dn_match	null	false		null
oracle.net.ssl_version	null	false		null
oracle.net.ssl_cipher_suites	null	false		null
javax.net.ssl.keyStore	null	false		null
javax.net.ssl.keyStoreType	null	false		null
javax.net.ssl.keyStorePassword	null	false		null
javax.net.ssl.trustStore	null	false		null
javax.net.ssl.trustStoreType	null	false		null
javax.net.ssl.trustStorePassword	null	false		null
ssl.keyManagerFactory.algorithm	null	false		null
ssl.trustManagerFactory.algorithm	null	false		null
oracle.net.oldSyntax	null	false		null
java.naming.factory.initial	null	false		null
java.naming.provider.url	null	false		null
java.naming.security.authentication	null	false		null
java.naming.security.principal	null	false		null
java.naming.security.credentials	null	false		null
oracle.net.wallet_location	null	false		null
oracle.net.wallet_password	null	false		null
oracle.jdbc.proxyClientName	null	false		null
oracle.jdbc.useNio	null	false		false
JDBCDriverCharSetId	null	false		null
oracle.jdbc.editionName	null	false		null
internal_logon	null	false		null
oracle.jdbc.createDescriptorUseCurrentSchemaForSchemaName	null	false		false
OCISvcCtxHandle	null	false		0
OCIEnvHandle	null	false		0
OCIErrHandle	null	false		0
prelim_auth	null	false		false
OCINewPassword	null	false		null
defaultExecuteBatch	null	false		1
defaultRowPrefetch	null	false		10
oracle.jdbc.defaultLobPrefetchSize	null	false		4000
remarksReporting	null	false		false
includeSynonyms	null	false		false
restrictGetTables	null	false		false
AccumulateBatchResult	null	false		true
useFetchSizeWithLongColumn	null	false		false
processEscapes	null	false		true
fixedString	null	false		false
defaultNChar	null	false		false
RessourceManagerId	null	false		0000
disableDefineColumnType	null	false		false
oracle.jdbc.convertNcharLiterals	null	false		false
oracle.jdbc.J2EE13Compliant	null	false		false
oracle.jdbc.mapDateToTimestamp	null	false		true
oracle.jdbc.useThreadLocalBufferCache	null	false		false
oracle.jdbc.driverNameAttribute	null	false		null
oracle.jdbc.maxCachedBufferSize	null	false		30
oracle.jdbc.implicitStatementCacheSize	null	false		0
oracle.jdbc.LobStreamPosStandardCompliant	null	false		true
password	null	false		null
server	null	false		null
oracle.jdbc.commitOption	null	false		null