Support and certification

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

Changes since 6.0.0 Release

  • Driver Enhancements
    • The driver has been enhanced to support connection failover and client load balancing when connecting to a cluster. You can enable this new functionality by specifying a comma-separated list of member nodes using the new ClusterNodes connection property. See ClusterNodes for details.
    • 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 connect using secure connect bundles, which contain security certificates and credentials for your database. You can configure your driver to use secure connect bundles by specifying the location of the .zip file using the new SecureConnectBundle property. See SecureConnectBundle for details.

      Note that secure connect bundles are only supported by certain databases, such as DataStax Enterprise running in IBM Cloud. Refer to your database documentation for support information.

    • The driver has been enhanced to allow you to configure how collections are mapped in the relational view of your data. By configuring the new SchemaFormat config option, you can determine whether the driver normalizes collections and collections labeled FROZEN. See SchemaFormat (configuration option) for details.

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

    • The driver has been enhanced to support the Duration data type, which maps to the Varchar JDBC type. See Data Types 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 all the data consistency levels for read and write operations that are supported by Apache Cassandra data stores. Data consistency levels are configured using the ReadConsistency and WriteConsistency connection properties. For additional information, see ReadConsistency and WriteConsistency.
    • The driver has been enhanced to support SSL, incorporating the addition of eight new connection properties. See Data Encryption and Data Encryption Properties for details.
    • The driver has been enhanced to support Kerberos authentication. See Authentication and Authentication Properties for details.
    • The driver has been enhanced to improve the handling of large result sets and reduce the likelihood of out-of-memory errors through the introduction of the FetchSize, NativeFetchSize, and ResultMemorySize connection properties. See FetchSize, NativeFetchSize, and WriteConsistency 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.

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

    • The SchemaDefinition connection property has been replaced with the SchemaMap connection property. See SchemaMap for details.

Highlights of the 6.0.0 Release

  • Supports SQL read-write access to DataStax Enterprise 4.6 or higher and Apache Cassandra 2.0 or higher. See Supported SQL Functionality for details.

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

  • Supports user id/password authentication. See Authentication for details.
  • Supports Cassandra data types, including the complex types Tuple, user-defined types, Map, List and Set. See Data Types for details.
  • Generates a relational view of Cassandra data. Tuple and user-defined types are flattened into a relational parent table, while collection types are mapped as relational child tables. See Complex Type Normalization for details.
  • Supports Native and Refresh escape sequences to embed CQL commands in SQL-92 statements. See Native and Refresh Escape Sequences for details.
  • Supports Cassandra's tunable consistency functionality with ReadConsistency and WriteConsistency connection properties.
  • Supports the handling of large result sets with FetchSize, NativeFetchSize, and ResultMemorySize connection properties.
  • Includes the TransactionMode connection property which allows you to configure the driver to report that it supports transactions, even though Cassandra does not support transactions. This provides a workaround for applications that do not operate with a driver that reports transactions are not supported.
  • Supports Binary Large Objects (BLOBs). See Large Object (LOB) 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 the LoginTimeout connection property which allows you to specify how long the driver waits for a connection to be established before timing out the connection request.