User guide

JDBC Driver Configuration Options
To control the behavior of the Amazon Redshift JDBC driver, you can append the configuration options
described in the following table to the JDBC URL .
DescriptionDefault
Value
Matching
Postgr-
eSQL Op-
tion Ex-
ists?
JDBC Option
The authentication mechanism to use.The following
values are possible:
• DISABLE—Establish a non-SSL connection.
• ALLOW—Attempt to establish a non-SSL connection.
If the connection fails, then attempt an SSL connec-
tion.
• REQUIRE—Establish an SSL connection.
• PREFER—Attempt to establish an SSL connection.
If the connection fails, then attempt a non-SSL con-
nection.
DISABLENoAuthMech
The number of rows to hold in memory. After one row
is discarded, another row is loaded in its place.
0NoBlockin-
gRowsMode
The minimum severity level of a message that the client
will process.The following values are possible, in order
from lowest to highest severity:
• DEBUG
• INFO
• NOTICE
• WARNING
• LOG
• ERROR
NOTICENoFilterLevel
The number of seconds to wait before timing out when
connecting to the server. If establishing the connection
takes longer than this threshold, then the connection
is aborted.
When this property is set to the default value of 0,
connections do not time out.
0YesloginTimeout
API Version 2012-12-01
142
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift