Configuring a connection for JDBC driver version 2.1 for Amazon Redshift

You can use a JDBC driver version 2.1 connection to connect to your Amazon Redshift cluster from many third-party SQL client tools. The Amazon Redshift Python connector provides an open source solution. You can browse the source code, request enhancements, report issues, and provide contributions.

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

Topics

• Download the Amazon Redshift JDBC driver, version 2.1
• Installing the Amazon Redshift JDBC driver, version 2.1
• Referencing the JDBC driver libraries
• Registering the driver class
• Getting the JDBC URL
• Building the connection URL
• Configuring TCP keepalives for your JDBC connection
• Configuring your JDBC connection with Apache Maven
• Configuring authentication and SSL
• Configuring logging
• Converting data types
• Using prepared statement support
• Differences between the 2.1 and 1.x versions of the JDBC driver
• Creating initialization (.ini) files for JDBC driver version 2.1
• Options for JDBC driver version 2.1 configuration
• Previous versions of JDBC driver version 2.1

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.