Amazon Redshift

Progress DataDirect for JDBC for Amazon Redshift

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Version 5.1.4

  • Certified with Oracle JDK 11*
    Driver version (F000258.U000115)
  • Certified with OpenJDK 11*
    Driver version (F000258.U000115)
  • Certified with OpenJDK 8 on Windows and Linux*
    Driver version (F000258.U000115)
  • Certified with Amazon Web Services API Version 2012-12-01
  • The driver has been enhanced to support connecting to a proxy server through an HTTP connection. HTTP proxy support is configurable with the new ProxyHost, ProxyPassword, ProxyPort, and ProxyUser connection properties.*
  • The driver has been enhanced to include timestamp in the Spy and JDBC packet
    logs by default. If required, you can disable the timestamp logging by
    specifying the following at connection: For Spy logs, set
    spyAttributes=(log=(file)Spy.log;timestamp=no) and for JDBC packet logs,
    set ddtdbg.ProtocolTraceShowTime=false.*
  • Interactive SQL for JDBC (JDBCISQL) is now installed with the product.
    JDBCISQL is a command-line interface that supports connecting your driver
    to a data source, executing SQL statements and retrieving results in a
    terminal. This tool provides a method to quickly test your drivers in an
    environment that does not support GUIs.*
  • The BatchMechanism connection property has been added to the driver. By setting BatchMechanism to multiRowInsert, you enable the driver to execute a single insert for all the rows contained in a parameter array. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The CryptoProtocolVersion connection property has been added to the driver. This property can be used to avoid vulnerabilities associated with SSLv3 and SSLv2, including the POODLE vulnerability.
  • Support for result set holdability has been added to the driver.
Changed Behavior
  • Java SE 7 has reached the end of its product life cycle and will no longer receive generally available security updates. As a result, the drivers will no longer support JVMs that are version Java SE 7 or earlier. Support for distributed versions of Java SE 7 and earlier will also end, including IBM SDK (Java Edition).*
  • The driver no longer registers the Statement Pool Monitor as a JMX MBean by
    default. To register the Statement Pool Monitor and manage statement pooling with
    standard JMX API calls, the new RegisterStatementPoolMonitorMBean connection
    property must be set to true.*

Version 5.1.3

GA Release Features
  • Support for Amazon Redshift API, version 2012-12-01 and later
  • Support for advanced security features, including SSL data encryption
  • Support for connection pooling
  • Support for configurable connection failover protection
  • Includes the LoginTimeout connection property which allows you to specify the amount of time the driver waits for a connection to be established before timing out the connection request
  • Includes the TransactionMode connection property which allows you to configure the driver to report that it supports transactions, even though Hive does not support transactions. This provides a workaround for applications which do not operate with a driver that reports transactions are not supported.
  • The driver provides support for the following standard SQL functionality:
    • Create Table and Create View
    • Insert
    • Drop Table and Drop View
    • Batches in HiveServer2 connections
GA Release Certifications
  • Certified with Amazon Web Services API Version 2012-12-01

Connect any application to any data source anywhere

Explore all DataDirect Connectors

A product specialist will be glad to get in touch with you

Contact Us