Progress DataDirect for JDBC for Amazon Redshift

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

    Refer to the following resources for additional information:

    • Product Compatibility Guide: Provides the latest data source and platform support information. 
    • Fixes: Describes the issues resolved since general availability.  

    Version 6.0.0

    • 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. For details, refer to CallEscapeBehavior.
    • 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
      For details, refer to Data types.

    Version 5.1.4

      • 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
      • 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
      • 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

      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