This document contains the release notes for all PGJDBC-NG releases since 0.8.

Please refer to the User Guide for comprehensive reference documentation on integrating and using PGJDBC-NG.

0.8.3

Date of Release:

Scope: Bug Fixes

For a complete list of all closed issues and pull requests for this release, consult the 0.8.3 milestone page in the PGJDBC-NG repository on GitHub.

PGJDBC-NG Driver

Bug Fixes

  • Intervals are now parsed/formatted correctly according to server’s or connection’s IntervalStyle

  • PGNotificationListener.close will only be called a single time

  • Locale handling has been properly matched to the server and JVM respectfully

  • Windows Locales are looked up in ROOT/ENGLISH locale

  • Connection URL parameters are properly percent-escaped

  • SQLData implementations handle nulls properly

  • Version meta-data is now correct in shaded jar & fat-jar applications

Deprecations and Breaking Changes

  • Interval has been completely overhauled with a Java 9 java.time interface

  • Due to fixes related to locale handling, text passed to the JDBC API must be in the JVM’s locale and text being passed to the server must be in the server’s locale; this shouldn’t be an overly impactful.

New Features and Improvements

  • PostgreSQL 12 is supported and part of the testing matrix

  • CockroachDB is supported

  • Batch executions use pipelined requests to increase performance by as much as 70%

  • PostgreSQL COPY FROM/TO support

PGJDBC-NG UDT Generator

Bug Fixes

  • Generated UDT implementations correctly handle nulls

  • Fix issue that caused generated attributes to be in incorrect order

  • Nested UDT’s now write wit the specific server type instead of generic record

Deprecations and Breaking Changes

New Features and Improvements

PGJDBC-NG Spy

Bug Fixes

Deprecations and Breaking Changes

New Features and Improvements

0.8.2

Date of Release: 2019-02-09

Scope: Bug fixes for 0.8 release

For a complete list of all closed issues and pull requests for this release, consult the 0.8.2 milestone page in the PGJDBC-NG repository on GitHub.

PGJDBC-NG Driver

Bug Fixes

  • Fix parsing of server versions with packaging information.

Deprecations and Breaking Changes

  • None

New Features and Improvements

  • None

PGJDBC-NG UDT Generator

No Changes

PGJDBC-NG Spy

No Changes

0.8.1

Date of Release: 2019-02-03

Scope: Bug fixes for 0.8 release

For a complete list of all closed issues and pull requests for this release, consult the 0.8.1 milestone page in the PGJDBC-NG repository on GitHub.

PGJDBC-NG General

Fixed source code highlighting in README and in asciidoc documentation.

PGJDBC-NG Driver

Bug Fixes

  • Fix notification delivery

  • Fix NPE in prepared statement batches

Deprecations and Breaking Changes

  • None

New Features and Improvements

  • None

PGJDBC-NG UDT Generator

Bug Fixes

  • Uber jar is now packaged and published for easy command line execution.

Deprecations and Breaking Changes

  • None

New Features and Improvements

  • None

PGJDBC-NG Spy

Bug Fixes

  • None

Deprecations and Breaking Changes

  • None

New Features and Improvements

  • None

0.8

Date of Release: 2019-01-30

Scope: Everything

For a complete list of all closed issues and pull requests for this release, consult the 0.8 milestone page in the PGJDBC-NG repository on GitHub.

PGJDBC-NG Driver

The driver went through a lot of changes in this release. Much of the code experienced changes to bring it up-to-date, bring performance inline and simplify the implementation in a number of areas.

Due to the large number of changes, for status of a specific bug it is best to check the milestone link above.

New Features and Improvements

  • Asynchronous FIFO engine

    • Allows query pipelining

    • Paves way for asynchronous API

  • Lazy Parameter Encoding, Result Decoding

  • Dramatically reduced type registry

    • Nearly 80% less information

    • Connections share registry information

    • Startup time ~10ms on localhost

  • Comprehensive Logging & Tracing

    • JDBC API, SQL & Protocol traces available

  • JDBC 4.2 conformance

    • Provides SQLType implementation

    • JSR310 support

    • Numerous conformance updates

  • Unix Domain Socket support

  • Date/Time Rewrite

    • Completely built on JSR 310

    • Simple and easy to understand

  • Detailed asciidoc documentation added.

    • Comprehensive User Guide

    • Detailed Release Notes (this!)

    • Auto-generated settings details (included in User Guide)

    • Documentation is now "code"

    • Each release includes its documentation.

  • Switched to multi-project Gradle build

Bug Fixes

  • Fixed Flyway compatibility

  • Fixed Windows locale support

  • Fixed issue with generated key support

  • Fixed CallableStatement out parameter handling

  • Fixed driver version name/number reporting

  • Fixed allowed DB names in URLs

  • Fixed numerous Time/Date/Timestamp issues

  • Fixed array handling

  • Fixed batch update handling

Deprecations and Breaking Changes

  • OSGI bundling has been removed due to it being incorrect. A future release may include it again.

PGJDBC-NG UDT Generator

The UDT generator is a "suggested" feature of JDBC 4.2. Although one has existed for PGJDBC-NG, it previously was a separate project and was not documented or updated. It’s now part of the main project, documented in the new "User Guide" and will be released and updated as normal.

PGJDBC-NG Spy

Spy is a general purpose library that (see User Guide) that PGJDBC-NG uses internally to provide JDBC API level tracing.