Support and certification

Visit the following web pages for the latest support and certification information.

Changes Since the 6.0.1 Release

  • Enhancements
    • The driver has been enhanced to comply with FIPS standards for data encryption. As part of this enhancement, the driver was tested with FIPS 140-3 enabled using a Red Hat OpenJDK 21 on a Red Hat Universal Base Image 9 instance. See FIPS (Federal Information Processing Standard) for details.

    • The driver has been enhanced to allow you to override the default value of the User-Agent header when required by a service. Using the new UserAgent property, you can specify the string value of the User-Agent header to be used in HTTP requests. See UserAgent for details.

    • The driver has been enhanced to include timestamp in the Spy and JDBC packet logs by default. See SpyAttributes for details.

    • 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. See Interactive SQL for JDBC (JDBCISQL) for details.

    • The driver has been enhanced to support the Statement.cancel API, which allows you to cancel running queries. The Statement.cancel API is supported only on Apache Spark SQL 2.0 and higher.
    • The driver has been enhanced to support the Binary data type for Apache Spark SQL 2.0 and higher, including the following two new connection properties:
      • MaxBinarySize allows you to specify the maximum length of fields of the Binary data type that the driver describes through result set descriptions and metadata methods.
      • BinaryDescribeType allows you to specify whether Binary columns are described as VARBINARY or LONGVARBINARY.

      See Data Types, BinaryDescribeType, and MaxBinarySize for details.

    • The driver has been enhanced to support HTTP mode, which allows you to access Apache Spark SQL data stores using HTTP/HTTPS requests. HTTP mode can be configured using the new TransportMode and HTTPPath connection properties. See HTTP Mode, TransportMode, and HTTPPath for details.
    • The driver has been enhanced to support cookie based authentication for HTTP connections. Cookie based authentication can be configured using the new EnableCookieAuthentication and CookieName connection properties. See Configuring User ID/Password Authentication, EnableCookieAuthentication, and CookieName.
  • Changed Behavior
    • The connection property SpyAttributes has been updated to exclude the attribute load=classname, which was previously used to load the driver specified by the given class name. See SpyAttributes for details.
    • 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).

Highlights of the 6.0.1 Release

  • Certifications
    • Certified with Apache Spark SQL 1.4.x and 1.5.x.
  • Enhancements
    • Enhanced to support the Decimal and Varchar data types. See Data Types and getTypeInfo for details.
    • Added ArrayFetchSize connection property to improve performance and reduce out of memory errors. ArrayFetchSize can be used to increase throughput or, alternately, improve response time in Web-based applications. See ArrayFetchSize and Performance Considerations for details.
  • 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. For details, see RegisterStatementPoolMonitorMBean.

Highlights of the 6.0.0 Release

  • Supports Apache Spark 1.2 and higher.
  • Supports SSL protocol for sending encrypted data. See Data encryption for details.
  • Supports Kerberos authentication. See Using Authentication for details.
  • Returns result set metadata for parameterized statements that have been prepared but not yet executed. See Parameter metadata support for details.

  • Supports connection pooling. For details, refer to Connection Pool Manager in the Progress DataDirect for JDBC Drivers Reference.

  • Supports statement pooling. For details, refer to Statement Pool Monitor in the Progress DataDirect for JDBC Drivers Reference.

  • Includes a set of timeout connection properties which allow you to limit the duration of active sessions and how long the driver waits to establish a connection before timing out. See Timeout Properties for details.
  • Includes the TransactionMode connection property which allows you to configure the driver to report that it supports transactions, although Spark SQL does not support transactions. This provides a workaround for applications that do not operate with a driver that reports transactions are not supported. See TransactionMode for details.
  • The driver provides support for the following standard SQL functionality:
    • Insert
    • Create Table and Create View
    • Drop Table and Drop View
    • Batches

    See Supported SQL Functionality for details.