Progress DataDirect for JDBC for Amazon Redshift

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

    For a list a list of issues resolved since general availability, refer to the fixes.

    Version 6.0.0

    Enhancements
    • The installer program has been enhanced to support Azul Zulu JRE 11. As a result of this change, the installer has ended support for some of the old operating systems. The installer supports the following operating systems after the enhancement:*
      • UNIX/Linux:
        • Any operating system on a machine using a JRE that is Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
      • Windows:
        • Windows 8.1 or higher
        • Windows Server 2012 RC2 or higher
      Important: These changes do not affect the operating system requirements of the driver.
    • The driver has been enhanced to support stored procedures.
    • The driver supports the CallEscapeBehavior connection property. It determines 
      whether the driver calls a user-defined function or a stored procedure when JDBC Call escape syntax is used in a SQL statement.
    • The driver has been enhanced to support the following data types:
       - Text maps to LONGVARCHAR
       - Time maps to TIMESTAMP
       - Time with time zone maps to TIMESTAMP
       - Timestamp with time zone maps to TIMESTAMP

    Version 5.1.4

    Certifications
    • Certified with Oracle JDK 11*
      Driver version 5.1.4.000054 (F000258.U000115)
    • Certified with OpenJDK 11*
      Driver version 5.1.4.000054 (F000258.U000115)
    • Certified with OpenJDK 8 on Windows and Linux*
      Driver version 5.1.4.000054 (F000258.U000115)
    • Certified with Amazon Web Services API Version 2012-12-01
    Enhancements
    • 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