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: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property 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 for Amazon Redshift and their default values.

Table 1. Amazon Redshift Driver Properties
Property Data Source Method Default
AccountingInfo setAccountingInfo None
ApplicationName setApplicationName empty string
BatchMechanism setBatchMechanism MultiRowInsert
BulkLoadBatchSize setBulkLoadBatchSize 1000 (rows)
CatalogOptions setCatalogOptions 2
ClientHostName setClientHostName empty string
ClientUser setClientUser empty string
ConnectionRetryCount setConnectionRetryCount 5
ConnectionRetryDelay setConnectionRetryDelay 1 (second)
ConvertNull setConvertNull 1 (data type check is performed if column value is null)
CryptoProtocolVersion setCryptoProtocolVersion TLSv1.2,TLSv1.1,TLSv1
DatabaseName setDatabaseName None
EnableCancelTimeout setEnableCancelTimeout false
EncryptionMethod setEncryptionMethod noEncryption
ExtendedColumnMetadata setExtendedColumnMetadata false
HostNameInCertificate setHostNameInCertificate empty string
ImportStatementPool setImportStatementPool empty string
InitializationString setInitializationString None
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString setJavaDoubleToString false
KeyPassword setKeyPassword None
KeyStore setKeyStore None
KeyStorePassword setKeyStorePassword None
LoginTimeout setLoginTimeout 0 (no timeout)
MaxNumericPrecision setMaxNumericPrecision 1,073,741,823
MaxNumericScale setMaxNumericScale 1000
MaxPooledStatements setMaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxVarcharSize setMaxVarcharSize 4096
Password setPassword None
PortNumber setPortNumber 5439
ProgramID setProgramID empty string
ProxyHost setProxyHost empty string
ProxyPassword setProxyPassword empty string
ProxyPort setProxyPort

0

ProxyUser setProxyUser empty string
QueryTimeout setQueryTimeout 0 (query does not time out)
ResultSetMetaDataOptions setResultSetMetaDataOptions 0 (no additional processing to determine the correct table name for each column in the result set)
ServerName setServerName None
SpyAttributes setSpyAttributes None
SupportsCatalogs setSupportsCatalogs false
TransactionErrorBehavior setTransactionErrorBehavior RollbackTransaction
TrustStore setTrustStore None
TrustStorePassword setTrustStorePassword None
User setUser None
ValidateServerCertificate setValidateServerCertificate true
VarcharClobThreshold setVarcharClobThreshold 32768