PGJDBC-NG Release Notes

Fix packaging and publishing of "UberJar"

Fix packaging and publishing of "UberJar"

Maven artifactId has changed to 'pgjdbc-ng-udt-gen`; prefix was added to disambiguate.

Maven artifactId has changed to 'pgjdbc-ng-udt-gen`; prefix was added to disambiguate.

Resolved driver hang when certain prepared queries are open during a hard database restart.

Resolved driver hang when rolling back to a savepoint when certain prepared queries are open.

Resolved null pointer exception during rollback when certain prepared queries are open.

Resolved regression when using CallableStatement as a simple PreparedStatement.

Fixed potential deadlock in default housekeeper implementation.

Procedure discovery succeeds when multiple schemas are present.

Struct with null values no longer throw NPE.

Use correct type map when retrieving Struct attributes.

Fixed loading and caching OIDs with large values.

Caching of ResultSetMetaData instances is now done, when possible.

Copy in/out errors no longer hang driver.

Errors related to protocol.message.size.max now have better messages.

Fixed synchronization issues when sharing registry information.

Connection.isValue(int) no longer has any transactional side effects.

More reliable cancellation of specific request.

PostgreSQL 13 added to validation matrix.

Support for SCRAM-SHA-256 & SCRAM-SHA-256-PLUS authentication methods.

More compliant host name verification supporting "Subject Alternate Names" and multiple common names.

Returning clauses can now be added manually to support PostgreSQL’s complex syntax.

Result sets can now be returned (e.g. from functions) and fetched using ResultSet.getObject.

Updated Netty to 4.1.53 (previous version contained critical vulnerabilities).

Concurrent data structures are now used for cleanup collections to fix concurrency issue during cleanup.

Null string values in scalars, records & arrays are now correctly handled.

PGDriver.cleanup is now safe to be called more than once.

Statement.setMaxFieldSize and pgjdbc.field.length.max now work as documented.

Integrity violation exceptions now include PostgreSQL’s DETAIL field.

System ids (oid, xid, cid) are now properly parsed/formatted as unsigned values.

DataSource.getConnection no longer overwrites user/password currently set on datasource.

URLs now properly support URL encoded values.

SSL hostname verifier now follows PostgreSQL’s specification for wildcards.

Published "uber" jars poms now declare no dependencies. Uber jar maven coordinates have changed.

DataSource properties & connection URL properties now support the same features; including Unix sockets and fallback addresses.

ACL’s now support the complete syntax and the ACLItem API has been updated to reflect this support.

SELECTing psuedo types (eg. record) is now supported.

Generated enum writes now use the specific type id of the enum (as required in a UDT).

Generator composite writers now use explicit types when necessary.

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

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.

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

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

Fix parsing of server versions with packaging information.

None

None

Fix notification delivery

Fix NPE in prepared statement batches

None

None

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

None

None

None

None

None

Asynchronous FIFO engine

Lazy Parameter Encoding, Result Decoding

Dramatically reduced type registry

Comprehensive Logging & Tracing

JDBC 4.2 conformance

Unix Domain Socket support

Date/Time Rewrite

Detailed asciidoc documentation added.

Switched to multi-project Gradle build

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

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