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 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. Refer to FIPS (Federal Information Processing Standard) for details.*
  Available: 1/31/2025 | 6.0.0.000879

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: 7/3/2024

NOTES, KNOWN ISSUES, AND LIMITATIONS

• Isolation level support: The driver supports only the READ_COMMITTED isolation level.
• Data type support: The driver does not support the ST_Geometry and ST_Point data types.
• LOB data type support: The driver does not support write operations for LOB data types.
• Parameter metadata: The parameter metadata (JDBC type, precision, and scale) is different from the result set metadata for some data types due to server limitations.
• Executing DataDirect Shell Script: For Linux users: If you receive an error message when executing any DataDirect for JDBC shell script, make sure that the file has EXECUTE permission. To do this, use the chmod command. For example, to grant EXECUTE permission to the testforjdbc.sh file, change to the directory containing testforjdbc.sh and enter: chmod +x testforjdbc.sh
• JDBC Methods: The following notes on JDBC methods apply generally to Progress DataDirect for JDBC drivers. Additional information on driver support for the JDBC API can be found in the "JDBC Support" section of the product user's guide.
  • The DataDirect for JDBC drivers allow PreparedStatement.setXXX methods and ResultSet.getXXX methods on Blob/Clob data types, in addition to the functionality described in the JDBC specification. The supported conversions typically are the same as those for LONGVARBINARY/LONGVARCHAR, except where limited by database support.
  • The DataDirect for JDBC drivers support retrieval of output parameters from a stored procedure before all result sets and/or update counts have been completely processed. When CallableStatement.getXXX is called, result sets and update counts that have not yet been processed by the application are discarded to make the output parameter data available. Warnings are generated when results are discarded.
  • The preferred method for executing a stored procedure that generates result sets and update counts is using CallableStatement.execute(). If multiple results are generated using executeUpdate, the first update count is returned. Any result sets prior to the first update count are discarded. If multiple results are generated using executeQuery, the first result set is returned. Any update counts prior to the first result set are discarded. Warnings are generated when result sets or update counts are discarded.
  • The ResultSet methods getTimestamp(), getDate(), and getTime() return references to mutable objects. If the object reference returned from any of these methods is modified, re-fetching the column using the same method returns the modified value. The value is only modified in memory; the database value is not modified.

Features

• Supports SQL read-write access to SAP HANA
• Supports all JDBC core functions. Refer to JDBC support in the Progress DataDirect for JDBC Drivers Reference.
  
• Supports the core SQL-92 grammar
  
• Supports SAP HANA data types. Refer to Data types and getTypeInfo() for details.
  
• Supports user ID and password authentication method with SCRAM-SHA-256 mechanism authentication. Refer to Authentication for details.
  
• Supports TLS/SSL data encryption. See Connection property descriptions for details.
  
• Supports proxy connections with a proxy server. See Proxy server for details.
  
• Supports the handling of large result sets with paging and the FetchSize connection property. Refer to FetchSize for details.  
  
• Includes Interactive SQL. It 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. Refer to Interactive SQL for JDBC (JDBCISQL) for details.
  
• The installer program supports Azul Zulu JRE 11. The installer supports the 
    following operating systems: 
  • 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 and Windows Server 2012 RC2 or higher

Important: These changes do not affect the operating system requirements of the driver.