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 support the SCRAM-SHA-256-PLUS password hashing mechanism for user ID/password authentication. The SCRAM-SHA-256-PLUS mechanism uses channel binding to establish a secure connection with PostgreSQL.
  Available: 8/20/2024 | 6.0.0.001552
• The driver has been enhanced to support Microsoft Entra ID authentication (formerly Azure Active Directory Authentication). Entra ID authentication is an alternate authentication type that allows administrators to centrally manage user permissions to Azure SQL Database data stores. The driver supports the following methods of Entra ID authentication:
  • User and password authentication
  • Service principal authentication

  For details, refer to Microsoft Entra ID authentication.
  Available: 8/20/2024 | 6.0.0.001552

• The driver has been enhanced to support the TLSv1.3 cryptographic protocol. Refer to CryptoProtocolVersion for details.
  Available: 7/2/2024 | 6.0.0.001479
• The driver has been enhanced to support MERGE against PostgreSQL 15 and later. MERGE is a SQL command that modifies rows in the target table using the data from the source table. It can conditionally INSERT, UPDATE or DELETE rows in a single statement, eliminating the need to write multiple procedural statements.*
  Available: Driver version 6.0.0.001277 (F002097.U001111)
• The driver has been enhanced to support the Geometry data type. Refer to Data types for details.*
  Available: Driver version 6.0.0.001097 (F001813.U000919)
• The driver has been enhanced with the new EnablePrepareThreshold and 
  PrepareThreshold connection properties, which allow you to configure the 
  behavior of server-side prepared statements. Refer to the user's guide for 
  details. Refer to EnablePrepareThreshold and PrepareThreshold for details.*
• The driver has been enhanced to support stored procedures.
• The CallEscapeBehavior connection property has been added to the driver. It determines whether the driver calls a user-defined function or a stored procedure. Refer to CallEscapeBehavior for details.
• The driver has been enhanced to support the following types of data types:
  • Geometric types
  • Network address types
  • Monetary types
  • Date/time types
  • Range types
  Refer to Data types for details.
• The driver has been enhanced to support the TXID_SNAPSHOT data type. Refer to Data types for details.
• The driver has been enhanced to support the SCRAM-SHA-256 authentication method, which uses a hashing mechanism for encrypting passwords to establish a secure connection with PostgreSQL. 
• The driver has been enhanced to include timestamp in the Spy and JDBC packet
  logs by default. If required, you can disable the timestamp logging by
  specifying the following at connection: For Spy logs, set
  spyAttributes=(log=(file)Spy.log;timestamp=no) and for JDBC packet logs,
  set ddtdbg.ProtocolTraceShowTime=false.
• 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.
• The driver has been enhanced to support a customized version of the PostgreSQL COPY command. It provides an additional keyword, LOCALFILE, to allow you to copy data from or to standard file-system files that are stored anywhere on your network, not just on the database server. For details, refer to Using COPY command.
• The driver has been enhanced to support the PostgreSQL COPY command for batch inserts. When BatchMechanism is set to copy, the driver leverages the PostgreSQL COPY command for substantial performance gains. For details, refer to Using COPY command.
• The driver has been enhanced to support retrieving the values of auto-generated keys. For details, refer to Auto-generated keys support.
• The driver has been enhanced to support the following data types: Citext, JSON, JSONB, and UUID. Refer to Data types for details
• The driver has been enhanced to support the Kerberos authentication protocol with the following connection properties:
  • AuthenticationMethod
  • ServicePrincipalName
  Refer to Kerberos authentication for details.
• The ExtendedColumnMetadata connection property has been added to the driver. This property determines how the driver returns column metadata when retrieving results with ResultSetMetaData methods. Refer to ExtendedColumnMetadata for details.
• The RegisterStatementPoolMonitorMBean connection property has been added to the driver. Note that the driver no longer registers the Statement Pool Monitor as a JMX MBean by default. You must set RegisterStatementPoolMonitorMBean to true to register the Statement Pool Monitor and manage statement pooling with standard JMX API calls. Refer to RegisterStatementPoolMonitorMBean for details.

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: July 3, 2024
• The default value for the SupportsCatalogs connection property has been changed to true. Refer to SupportsCatalogs for details.

Version 5.1.4

ENHANCEMENTS

• The CryptoProtocolVersion connection property has been added to the driver. This property can be used to avoid vulnerabilities associated with SSLv3 and SSLv2, including the POODLE vulnerability.
  
• Support for result set holdability has been added to the driver.

Version 5.1.2

ENHANCEMENTS

• Added SupportsCatalogs connection property, which enables driver support for catalog calls
• Added four connection properties to handle VARCHAR, LONGVARCHAR, and NUMERIC data types: MaxVarcharSize, MaxLongVarcharSize, MaxNumericPrecision, and MaxNumericScale

Version 5.1.1

GA Release Features

• Supports SQL access to PostgreSQL
• Supports SSL protocol for sending encrypted data
• Supports connection pooling
• Supports the DataDirect Bulk Load API
• Includes the TransactionErrorBehavior connection property which determines how the driver handles errors that occur within a transaction
• Includes the LoginTimeout connection property which allows you to specify the amount of time the driver waits for a connection to be established before timing out the connection request