Support and certification

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

Changes for 6.0.1

  • Driver Enhancements
    • Corrections have been made to the contents of the getTypeInfo result set. For details, see Data types and getTypeInfo().
    • 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 support key-pair authentication. When key-pair authentication is enabled (AuthenticationMethod=KeyPair), you can authenticate to Snowflake using a pair of private and public keys. To configure the driver to use key-pair authentication, you can use the new PrivateKeyContent, PrivateKeyFile, and PrivateKeyPassphrase connection properties. For details, see Key-pair authentication.
    • The driver now allows you to specify whether the driver fetches metadata for only tables in the database to which you are connected when a database name is not specified in metadata calls. When enabled, this behavior can provide better performance for metadata calls by reducing the number of tables queried. You can use the new UseSessionDatabaseForMetadata connection property to configure the driver's behavior.
    • The driver has been modified to map Snowflake fixed-point number types where precision and scale cannot be modified to the Numeric data type by default. In addition, the IntegerFieldMapping connection property has been added to the driver. This connection property allows you to map these fixed-point number types to BigInt. For details, see IntegerFieldMapping and Data types.
    • The driver has been enhanced to support the refresh token grant for OAuth 2.0 authentication. To support it, a new connection property, RefreshToken, has been added. See Refresh token grant for details.
    • The driver has been enhanced to fall back to JSON query format when the arrow format is not properly initialized. The driver uses a high-speed arrow transfer that requires the restricted APIs from java.nio package. When the JVM is not correctly configured for Java SE 16 and higher, an exception is returned when the driver executes a query. To allow you to continue executing queries in this scenario, you can configure the new ArrowFallbackToJson property to switch to the JSON query format. See ArrowFallbackToJson for details.
  • 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.
    • The TransactionMode property has been removed from the driver as of version 6.0.1. It was determined that TransactionMode provides no value with respect to Snowflake connections. If you previously used TransactionMode with version 6.0.0, you must remove this setting after upgrading to 6.0.1. Continuing to use it may result in an error and prevent the driver from establishing a connection. In version 6.0.1, all transaction handling is delegated to the server.
    • 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:

      https://docs.progress.com/bundle/datadirect-product-compatibility/resource/datadirect-product-compatibility.pdf

Highlights of 6.0.0 Release

  • The driver supports SQL read-write access to Snowflake. See Supported SQL statements and extensions for details.

  • The driver supports JDBC core functions. For details, refer to JDBC support in the Progress DataDirect for JDBC Drivers Reference.

  • The driver supports Snowflake data types through data type inference. See Data types and getTypeInfo() for details.
  • The driver provides proxy support. See Proxy server and Connection property descriptions for more information.
  • The driver supports OAuth 2.0 authentication. See OAuth 2.0 authentication for details.
  • The driver supports user ID and password authentication. See User ID/password authentication for details.
  • The driver supports browser-based SSO authentication for Microsoft Windows.
  • The driver supports using the COPY command for loading and unloading data from local file systems and cloud platforms, such as Amazon S3, Google Cloud, and Microsoft Azure. See Using COPY command for further details.
  • The driver supports the handling of large result sets with paging, and the FetchSize connection property.
  • Interactive SQL is now installed with the product. Interactive SQL 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 details.
  • The driver includes the Progress DataDirect Snowflake Configuration Manager for quick configuration and testing of your driver in a web browser. The tool allows you to:
    • Generate and edit connection URLs
    • Test connect your connection URLs
    • Execute SQL commands for testing
    • Fetch access tokens and configure OAuth 2.0
    For details, see Generating connection URLs with the Configuration Manager and Testing connections and queries.