User guide

DescriptionDefault
Value
Matching
Postgr-
eSQL Op-
tion Ex-
ists?
JDBC Option
The amount of logging information output by the driver.
By default, no logging is performed. Information will be
output to the location specified by the LogStream or
LogValue option in the driver manager. The following
values are possible:
• 2 (DEBUG)—Log a lot of detailed information.
• 1 (INFO)—Log fewer details.
Note
Only use this property if you are
troubleshooting problems with a driver, be-
cause it can affect performance.
Yesloglevel
The password to use to connect to the Amazon Redshift
server.
YesPWD
The number of seconds to wait during socket read op-
erations before timing out. If an operation takes longer
than this threshold, then the connection is closed.
When this property is set to the default value of 0,
connections do not time out.
0YessocketTimeout
A value that determines whether to use an SSL connec-
tion. The following values are possible:
• true—Use SSL.
• false—Don't use SSL.
falseYesssl
The factory to use for an SSL connection without a
server certificate.The following values are possible:
• com.amazon.redshift.ssl.NonValidating-
Factory
• org.postgresql.ssl.NonValidatingFactory
YessslFactory
A value that determines whether TCP keepalives are
enabled.The following values are possible:
• true—Enable TCP keepalives.
• false—Disable TCP keepalives.
trueYestcpKeepAlive
The threshold for minutes of inactivity before initiating
a TCP keepalive transmission.
5NoTCP-
KeepAliveMinutes
API Version 2012-12-01
143
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift