PostgreSQL

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Certified with PostgreSQL 12*
Driver version 5.1.4.000244 (F000453.U000216)
Certified with PostgreSQL 11*
Driver version 5.1.4.000134 (F000378.U000183)
Certified with Oracle JDK 11*
Driver version 5.1.4.000134 (F000378.U000183)
Certified with OpenJDK 11*
Driver version 5.1.4.000134 (F000378.U000183)
Certified with OpenJDK 8 on Windows and Linux*
Driver version 5.1.4.000134 (F000378.U000183)
Certified with Amazon Aurora PostgreSQL 1.0*
Driver version 5.1.4.000130 (F000375.U000182)
Certified with PostgreSQL 10.1*
Driver version 5.1.4.000121 (F000358.U000177)
Certified with PostgreSQL 9.5 and 9.6*
Certified with PostgreSQL 9.3 and 9.4

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 the DATADIRECT CONNECT SERIES FOR JDBC USER'S GUIDE.*
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.*
Support for the Kerberos authentication protocol has been added with the following
connection properties: AuthenticationMethod and ServicePrincipalName.*
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.*
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.

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).*
Added the RegisterStatementPoolMonitorMBean connection property. 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.*

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

Supports SQL access to PostgreSQL 8.2 and higher
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