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).

Note:
  • In a JDBC data source, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").
  • The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.

The following table provides a summary of the connection properties supported by the driver, their corresponding data source methods, and their default values.

Table 1. Driver Properties
Connection String Property Data Source Method Default Value
AuthenticationMethod setAuthenticationMethod userIdPassword
ClusterNodes setClusterNodes Empty string
ConfigOptions setConfigOptions Empty string
CreateMap setCreateMap notExist
EncryptionMethod setEncryptionMethod noEncryption
FetchSize setFetchSize 100 (rows)
HostNameInCertificate setHostNameInCertificate Empty string
ImportStatementPool setImportStatementPool No default value
InitializationString setInitializationString No default value
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize 2048 (KB)
KeyPassword setKeyPassword No default value
KeyspaceName setKeyspaceName No default value
KeyStore setKeyStore No default value
KeyStorePassword setKeyStorePassword No default value
LogConfigFile setLogConfigFile ddlogging.properties
LoginConfigName setLoginConfigName JDBC_DRIVER_01
LoginTimeout setLoginTimeout 0
MaxPooledStatements setMaxPooledStatements 0
NativeFetchSize setNativeFetchSize 10000 (rows)
Password setPassword No default value
PortNumber setPortNumber 9042
ProxyHost setProxyHost No default value
ProxyPassword setProxyPassword No default value
ProxyPort setProxyPort 0
ProxyUser setProxyUser No default value
ReadConsistency setReadConsistency quorum
ReadOnly setReadOnly false
RegisterStatementPoolMonitorMBean setRegisterStatementPoolMonitorMBean false
ResultMemorySize setResultMemorySize -1
SchemaMap setSchemaMap Default value depends on environment
SecureConnectBundle

setSecureConnectBundle

UseConnInfo
ServerName setServerName No default value
ServicePrincipalName setServicePrincipalName Driver builds value based on environment
SpyAttributes setSpyAttributes No default value
TransactionMode setTransactionMode noTransactions
TrustStore setTrustStore No default value
TrustStorePassword setTrustStorePassword No default value
User setUser No default value
ValidateServerCertificate setValidateServerCertificate No default value
WriteConsistency setWriteConsistency quorum