Connection Property Descriptions

This section lists the JDBC connection properties supported by the driver and describes each property. The properties have the form:

property=value

You can use these connection properties with either the JDBC Driver Manager or Progress DataDirect data sources unless otherwise noted.

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 refers to 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 and their default values.

Table 16. Amazon Redshift Driver Properties
Property	Default
AccountingInfo	None
ApplicationName	empty string
BatchMechanism	MultiRowInsert
BulkLoadBatchSize	1000 (rows)
CatalogOptions	2
ClientHostName	empty string
ClientUser	empty string
ConnectionRetryCount	5
ConnectionRetryDelay	1 (second)
ConvertNull	1 (data type check is performed if column value is null)
CryptoProtocolVersion	TLSv1.2,TLSv1.1,TLSv1
DatabaseName	None
EnableCancelTimeout	false
EncryptionMethod	noEncryption
HostNameInCertificate	empty string
ImportStatementPool	empty string
InitializationString	None
InsensitiveResultSetBufferSize	2048 (KB of memory)
JavaDoubleToString	false
KeyPassword	None
KeyStore	None
KeyStorePassword	None
LoginTimeout	0 (no timeout)
MaxNumericPrecision	1,073,741,823
MaxNumericScale	1000
MaxPooledStatements	0 (driver’s internal prepared statement pooling is not enabled)
MaxVarcharSize	4096
Password	None
PortNumber	5439
ProgramID	empty string
QueryTimeout	0 (query does not time out)
ResultSetMetaDataOptions	0 (no additional processing to determine the correct table name for each column in the result set)
ServerName	None
SpyAttributes	None
SupportsCatalogs	false
TransactionErrorBehavior	RollbackTransaction
TrustStore	None
TrustStorePassword	None
User	None
ValidateServerCertificate	true
VarcharClobThreshold	32768

In this section: