An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.
For a list a list of issues resolved since general availability, refer to the fixes.
The driver has been enhanced to support the following types of data types:
Network address types
The driver has been enhanced to support the TXID_SNAPSHOT data type.
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 Greenplum 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 user's guide.
The PrepareThreshold connection property has been added to the driver. This property determines the number of PreparedStatement executions that must occur before the driver begins using server-side prepared statements.
Support for the Kerberos authentication protocol has been added with the following connection properties: AuthenticationMethod and ServicePrincipalName.
The driver does not support access to Pivotal HAWQ anymore.
The default value for the SupportsCatalogs connection property has been changed to true.
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.
Certified with Greenplum 6.0* Driver version 5.1.4.000223 (F000432.U000208)
Certified with Oracle JDK 11* Driver version 5.1.4.000183 (F000381.U000186)
Certified with OpenJDK 11* Driver version 5.1.4.000183 (F000381.U000186)
Certified with OpenJDK 8 on Windows and Linux* Driver version 5.1.4.000183 (F000381.U000186)
Certified with Greenplum 5.0, 5.1, 5.2, 5.3, 5.4, 5.5* Driver version 5.1.4.000162 (F000369.U000179)
Certified with Greenplum 4.3
Certified with Pivotal HDB (HAWQ) 2.0*
Certified with Pivotal HAWQ 1.2
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.
Certified with Pivotal HAWQ 1.1
Added SSL support for Greenplum 4.2, incorporating eight additional connection properties
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
GA Release Features
Supports SQL access to Greenplum 3.2 and higher
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