Connection Property Descriptions

You can use connection properties to customize the driver for your environment. This section lists the connection properties supported by the driver and describes each property. You can use these connection properties with either the JDBC Driver Manager or a JDBC data source. For a Driver Manager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setproperty(value).

Table 20. Connection Properties
Property	Data Source Method	Default
AccountingInfo	setAccountingInfo	empty string
ApplicationName	setApplicationName	empty string
ArrayFetchSize	setArrayFetchSize	20000 (cells)
AuthenticationMethod	setAuthenticationMethod	userIdPassword
BinaryDescribeType	setBinaryDescribeType	varbinary
ClientHostName	setClientHostName	empty string
ClientUser	setClientUser	empty string
ConnectionRetryCount	setConnectionRetryCount	5
ConnectionRetryDelay	setConnectionRetryDelay	1 (second)
ConvertNull	setConvertNull	1
CookieName	setCookieName	hive.server2.auth
CryptoProtocolVersion	setCryptoProtocolVersion	None
DatabaseName	setDatabaseName	The default database
EnableCookieAuthentication	setEnableCookieAuthentication	true
EncryptionMethod	setEncryptionMethod	noEncryption
HostNameInCertificate	setHostNameInCertificate	empty string
HTTPPath	setHTTPPath	cliservice
ImportStatementPool	setImportStatementPool	empty string
InitializationString	setInitializationString	None
InsensitiveResultSetBufferSize	setInsensitiveResultSetBufferSize	2048
JavaDoubleToString	setJavaDoubleToString	false
KeyPassword	setKeyPassword	None
KeyStore	setKeyStore	None
KeyStorePassword	setKeyStorePassword	None
LoginTimeout	setLoginTimeout	0
MaxBinarySize	setMaxBinarySize	2147483647
MaxPooledStatements	setMaxPooledStatements	None
Password	setPassword	None
PortNumber	setPortNumber	10000
ProgramID	setProgramID	empty string
RegisterStatementPoolMonitorMBean	setRegisterStatementPoolMonitorMBean	false
RemoveColumnQualifiers	setRemoveColumnQualifiers	false
ServerName	setServerName	None
ServicePrincipalName	setServicePrincipalName	None
SpyAttributes	setSpyAttributes	None
StringDescribeType	setStringDescribeType	varchar
TransactionMode	setTransactionMode	noTransactions
TransportMode	setTransportMode	binary
TrustStore	setTrustStore	None
TrustStorePassword	setTrustStorePassword	None
UseCurrentSchema	setUseCurrentSchema	false (results are not restricted to the tables and views in the current schema)
User	setUser	None
ValidateServerCertificate	setValidateServerCertificate	true