Configuring a connection for JDBC driver version 2.0 for Amazon Redshift - Amazon Redshift

Configuring a connection for JDBC driver version 2.0 for Amazon Redshift

You can use a JDBC driver version 2.0 connection to connect to your Amazon Redshift cluster from many third-party SQL client tools. To do this, you download a JDBC driver.

To use a JDBC connection, refer to the following sections.

Configuring TCP keepalives for your JDBC connection

By default, the Amazon Redshift JDBC driver is configured to use TCP keepalives to prevent connections from timing out. You can specify when the driver starts sending keepalive packets or turn off the feature by setting the relevant properties in the connection URL. For more information about the syntax of the connection URL, see Building the connection URL.

Property Description

TCPKeepAliveMinutes

To specify when the driver sends keepalive packets, set the number of minutes of inactivity before the driver starts sending TCP keepalive packets.

TCPKeepAlive

To turn off TCP keepalives, set this property to FALSE.