Connection property descriptions

Table 18. Connection properties
Property	Data source method	Default
AccountingInfo	setAccountingInfo	Empty string
AEKeyCacheTTL	setAEKeyCacheTTL	7200
AEKeystoreClientSecret	setAEKeystoreClientSecret	None
AEKeystoreLocation	setAEKeystoreLocation	None
AEKeystorePrincipalId	setAEKeystorePrincipalId	None
AEKeystoreSecret	setAEKeystoreSecret	Empty string
AlternateServers	setAlternateServers	None
AlwaysReportTriggerResults	setAlwaysReportTriggerResults	false
ApplicationIntent	setApplicationIntent	ReadWrite
ApplicationName	setApplicationName	Empty string
AuthenticationMethod	setAuthenticationMethod	auto
BulkLoadBatchSize	setBulkLoadBatchSize	1000 (rows)
BulkLoadOptions	setBulkLoadOptions	2
CatalogOptions	setCatalogOptions	0
ClientHostName	setClientHostName	Empty string
ClientUser	setClientUser	Empty string
ColumnEncryption	setColumnEncryption	Disabled
CodePageOverride	setCodePageOverride	None
ConnectionRetryCount	setConnectionRetryCount	5
ConnectionRetryDelay	setConnectionRetryDelay	1 (second)
ConvertNull	setConvertNull	1 (data type check is performed if column value is null)
CryptoProtocolVersion	setCryptoProtocolVersion	None
DatabaseName	setDatabaseName	None
DateTimeInputParameterType	setDateTimeInputParameterType	auto
DateTimeOutputParameterType	setDateTimeOutputParameterType	auto
DescribeInputParameters	setDescribeInputParameters	noDescribe
DescribeOutputParameters	setDescribeOutputParameters	noDescribe
Domain	setDomain	None
EnableBulkLoad	setEnableBulkLoad	false
EnableCancelTimeout	setEnableCancelTimeout	false
EncryptionMethod	setEncryptionMethod	noEncryption
FailoverGranularity	setFailoverGranularity	nonAtomic
FailoverMode	setFailoverMode	connect
FailoverPreconnect	setFailoverPreconnect	false
FetchTSWTZAsTimestamp	setFetchTSWTZAsTimestamp	false
FetchTWFSasTime	setFetchTWFSasTime	false
GSSCredential	setGSSCredential	Null
HostNameInCertificate	setHostNameInCertificate	Empty string
ImportStatementPool	setImportStatementPool	Empty string
InitializationString	setInitializationString	None
InsensitiveResultSetBufferSize	setInsensitiveResultSetBufferSize	2048 (KB)
JavaDoubleToString	setJavaDoubleToString	false
JDBCBehavior	setJDBCBehavior	1
LoadBalancing	setLoadBalancing	false
LoginConfigName	setLoginConfigName	JDBC_DRIVER_01
LoginTimeout	setLoginTimeout	0 (no timeout)
LongDataCacheSize	setLongDataCacheSize	2048 (KB)
MaxPooledStatements	setMaxPooledStatements	0 (driver’s internal prepared statement pooling is not enabled)
MultiSubnetFailover	setMultiSubnetFailover	false
NetAddress	setNetAddress	000000000000
PacketSize	setPackeSize	-1 (maximum packet size accepted by the database server)
Password	setPassword	None
PortNumber	setPortNumber	1433
ProgramID	setProgramID	Empty string
QueryTimeout	setQueryTimeout	0 (query does not time out)
RegisterStatementPoolMonitorMBean	setRegisterStatementPoolMonitorMBean	false
ResultSetMetaDataOptions	setResultSetMetaDataOptions	0 (no additional processing to determine the correct table name for each column in the result set)
SelectMethod	setSelectMethod	direct
ServerName	setServerName	None
ServicePrincipalName	setServicePrincipalName	Driver builds value based on environment
SnapshotSerializable	setSnapshotSerializable	false
SpyAttributes	setSpyAttributes	None
StringInputParameterType	setStringInputParameter	nvarchar
StringOutputParameterType	setStringOutputParameter	nvarchar
SuppressConnectionWarnings	setSuppressConnectionWarnings	false
TransactionMode	setTransactionMode	implicit
TruncateFractionalSeconds	setTruncateFractionalSeconds	true
TrustStore	setTrustStore	None
TrustStorePassword	setTrustStorePassword	None
User	setUser	None
UseServerSideUpdatableCursors	setUseServerSideUpdatableCursors	false
ValidateServerCertificate	setValidateServerCertificate	true
XATransactionGroup	setXATransactionGroup	None
XMLDescribeType	setXMLDescribeType	None