JDBC Driver Version 24.2.0 Release Notes

Release date: 2024-11-11

This list provides an overview of all changes in JDBC driver version 24.2.0.

Download JDBC driver version 24.2.0 from the Exasol Download Portal.

Changed behavior

Changelog entry Changed behavior
22144

See changelog description to learn about the changes in timestamp precision for Exasol JDBC driver.
21749

Exasol JDBC Driver now throws an error on invalid parameters in both connection string and properties.
This improves the driver's reliability and predictability by providing better feedback and avoiding unexpected behavior and difficult-to-debug connection issues.
21411

Now isValid(timeout) will use the given timeout and return true or false.

21236

JDBC: The "EnterParallel" method is now deprecated. Please use the "RequestParallelConnections" method instead.
19453

SQL Syntax Adjustments
Users can specify certificate parameters before or after the FILE keyword in the SQL statement. If the parameters are included in both locations, an error will be thrown. This is a change from older drivers, where parameters could only be added at the end.

Impact on Older Exasol JDBC Drivers
If the database has TLS certificate verification enabled by default, older Exasol JDBC drivers that do not include the public key in the SQL statement will not be able to perform LOCAL IMPORT and EXPORT operations. This will result in operation failures due to failing certificate validation.

Solution:
To resolve this issue, users must either:

  • Update the Exasol JDBC driver to the latest version, which supports automatic public key inclusion.
  • Modify their SQL statements to include the IGNORE CERTIFICATE keyword in the end of the SQL statement, bypassing certificate verification.

New features

Changelog entry Summary
22144 JDBC timestamp precision changes

Improvements

Changelog entry Summary
22528 Exasol JDBC driver third-party library Bouncycastle updated to the version 1.79
21749 Exasol JDBC Driver should throw error on invalid parameter in connection string and connection string properties
21236 JDBC new Interface for Parallel Connections
19453 Exasol JDBC Driver Improvement: TLS Certificate Support for Local Import/Export

Bug fixes

Changelog entry Summary
21411 The JDBC isValid() method did not handle timeouts and was throwing unexpected exceptions