Progress DataDirect for JDBC for Greenplum

    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

      ENHANCEMENTS
      • The driver has been enhanced to support the TLSv1.3 cryptographic protocol. You can configure the cryptographic protocols used by the driver using the CryptoProtocolVersion connection property. The TLSv1.3 protocol requires Java SE 11 or higher*.
      • The driver has been enhanced to support the following types of data types:
        • Geometric types
        • Network address types
        • Monetary types
        • Date/time types
        • Range types
        For details, refer to Data types.
      • The driver has been enhanced to support the TXID_SNAPSHOT data type. For details, refer to Data types.
      • 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 driver has been enhanced to support a customized version of the Greenplum COPY command. It provides an additional keyword, LOCALFILE, to allow you to copy data from or to standard file-system files that are stored anywhere on your network, not just on the database server. For details, refer to Using COPY command.
      • The PrepareThreshold connection property has been added to the driver. This property determines the number of PreparedStatement executions that must occur before the driver begins using server-side prepared statements. For details, refer to PrepareThreshold.
      • Support for the Kerberos authentication protocol has been added with the following   connection properties: AuthenticationMethod and ServicePrincipalName. For details, refer to AuthenticationMethod and ServicePrincipalName.
      CHANGED BEHAVIOR
      • The installer program now requires you to install a JRE that is Java SE 11 or higher before running the installer. In earlier versions, the JRE used by the installer program was included in the product. However, to avoid potential security vulnerabilities, the installer program no longer includes a JRE. Instead, the installer program uses the JRE in your environment to allow for the most secure version of a JRE to be used.*
        Note: This change does not affect the JVM requirements for the driver. For the latest driver requirements, refer to the Product Compatibility Guide.
        Available: July 3, 2024
      • The driver does no longer supports access to Pivotal HAWQ.
      • The default value for the SupportsCatalogs connection property has been changed to true. For details, refer to SupportsCatalogs.
      • Added the RegisterStatementPoolMonitorMBean connection property. Note that the
        driver no longer registers the Statement Pool Monitor as a JMX MBean by default.
        You must set RegisterStatementPoolMonitorMBean to true to register the Statement Pool Monitor and manage statement pooling with standard JMX API calls. For details, refer to RegisterStatementPoolMonitorMBean.

      Version 5.1.4

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

      Version 5.1.2

        ENHANCEMENTS
        • Added SSL support for Greenplum 4.2, incorporating eight additional connection properties
        • Added SupportsCatalogs connection property, which enables driver support for catalog calls
        • Added four connection properties to handle VARCHAR, LONGVARCHAR, and NUMERIC data types: MaxVarcharSize, MaxLongVarcharSize, MaxNumericPrecision, and MaxNumericScale

        Version 5.1.1

        GA Release Features
        • Supports SQL access to Greenplum
        • Supports connection pooling
        • Supports the DataDirect Bulk Load API
        • Includes the TransactionErrorBehavior connection property which determines how the driver handles errors that occur within a transaction
        • 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

        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