skip to main content
Connection Property Descriptions
  

Try DataDirect Drivers Now

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). Connection property names are case-insensitive. For example, Password is the same as password.
Note: In a JDBC data source, string values must be enclosed in double quotation marks, for example, setKeyspaceName("MyKS").
Note: The data type listed in each of the connection property descriptions is the Java data type used for the property value in a JDBC data source.
The following table provides a summary of the connection properties supported by the driver, their corresponding data source methods, and their default values.
Table 26. Driver Properties
Connection String Property
Data Source Method
Default Value
setAuthenticationMethod
userIdPassword
setCreateMap
notExist
setEncryptionMethod
noEncryption
setFetchSize
100 (rows)
setHostNameInCertificate
Empty string
setImportStatementPool
No default value
setInitializationString
No default value
setInsensitiveResultSetBufferSize
2048 (KB)
setKeyPassword
No default value
setKeyspaceName
No default value
setKeyStore
No default value
setKeyStorePassword
No default value
setLogConfigFile
ddlogging.properties
setLoginConfigName
JDBC_DRIVER_01
setLoginTimeout
0
setMaxPooledStatements
0
setNativeFetchSize
10000 (rows)
setPassword
No default value
setPortNumber
9042
setReadConsistency
quorum
setReadOnly
true
setRegisterStatementPoolMonitorMBean
false
setResultMemorySize
-1
setSchemaMap
For Windows:
application_data_folder\
Local\Progress\DataDirect\
Cassandra_Schema\servername.config
For UNIX/Linux:
˜/progress/datadirect/
cassandra_schema/
servername.config
setServerName
No default value
setServicePrincipalName
Driver builds value based on environment
setSpyAttributes
No default value
setTransactionMode
noTransactions
setTrustStore
No default value
setTrustStorePassword
No default value
setUser
No default value
setValidateServerCertificate
No default value
setWriteConsistency
quorum
* AuthenticationMethod
* CreateMap
* EncryptionMethod
* FetchSize
* HostNameInCertificate
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* KeyPassword
* KeyspaceName
* KeyStore
* KeyStorePassword
* LogConfigFile
* LoginConfigName
* LoginTimeout
* MaxPooledStatements
* NativeFetchSize
* Password
* PortNumber
* ReadConsistency
* ReadOnly
* RegisterStatementPoolMonitorMBean
* ResultMemorySize
* SchemaMap
* ServerName
* ServicePrincipalName
* SpyAttributes
* TransactionMode
* TrustStore
* TrustStorePassword
* User
* ValidateServerCertificate
* WriteConsistency