PostgreSQL JDBC Driver 42.2.19 Released

Changed

  • Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
  • Fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes #1903 (#1905) There is a small behaviour change here as a result. If closeOnCompletion is called on an existing statement and the statement is executed a second time it will fail.

Added

  • Verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) PR #2012

Fixed

  • Fix: properly set cancel socket timeout (#2044)
  • Fix “Required class information missing” when old org.jboss:jandex parses pgjdbc classes [issue 2008][https://github.com/pgjdbc/pgjdbc/issues/2008]
  • Fix PGCopyInputStream returning the last row twice when reading with CopyOut API [issue 2016][https://github.com/pgjdbc/pgjdbc/issues/2016]
  • Fix Connnection.isValid() to not wait longer than existing network timeout PR #2040
  • Fix Passwords with spaces (ASCII and non-ASCII) now work with SCRAM authentication (driver now uses SASLprep normalization) PR #2052
  • Fix DatabaseMetaData.getTablePrivileges() to include views, materialized views, and foreign tables PR #2049

Commits by author

Dave Cramer (5):

Jeremy Mailen (3):

  • fix: return metadata privileges for views and foreign tables 66690817
  • refactor: consolidate repeated drop code in TestUtil f5abc65c
  • test: Add test for ACLs returned from metadata getTablePrivileges() for views a6cf67d2

Jorge Solórzano (1):

  • fix: Use SASLprep normalization for SCRAM authentication PR 2052 b4800044

Pavel Bludov (2):

  • chore: javadoc changes in PgResultSet.java to pass upcoming checkstyle version 70471c25
  • chore: javadoc changes in Driver.java to pass upcoming checkstyle version c57ac5eb

Power (1):

  • fix: isValid() should not wait longer than network timeout 0dbc6078

Roman Kozlov (1):

Sehrope Sarkuni (5):

  • test: Add tests for broken PGCopyInputStream.readFromCopy() c6794f09
  • fix: Fix last row duplicated in PGCopyInputStream.readFromCopy() 6c296a52
  • test: Add TestUtils.closeQuietly(…) c152f7f0
  • test: Add StrangeProxyServer 8f773a15
  • docs: Add getTablePrivileges() fix to changelog 444cb1b1

Vladimir Sitnikov (14):

  • chore: make javadoc optional for building from a reduced-pom.xml 736eb70d
  • chore: make buildSrc.jar reproducible ff0774da
  • chore: use cleanup-gradle-cache for Travis cache cleanup 0e0ae208
  • fix: allow specifying binaryTransferEnable even for those types that are not enabled by default ed5891e3
  • fix: binary transfer for numeric PR 1935 a4173079
  • chore: update Gradle 6.3 -> 6.7.1 PR 2011 dbb12e41
  • chore: verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) 991a9c0b
  • chore: add org.postgresql.util.internal. Unsafe for forbidden-apis suppressions 6e3be122
  • fix: “Required class information missing” when old org.jboss:jandex parses pgjdbc classes (PR PR 2010 2df6c97b
  • test: set gssEncMode only in case it is not already present in Properties 97f6abd1
  • test: temporarily allow CONNECTION_UNABLE_TO_CONNECT in SslTest for bad client certificates 5f584cd4
  • perf: avoid duplicate PGStream#changeSocket calls b7e70d85
  • chore: cancel stale workflows in GitHub Actions CI d255bd21
  • doc: update README link from travis-ci.org to travis-ci.com 1bd679e8

odubaj (1):

  • Remove dependency on java-comment-preprocesor df2297ef

rtrier (1):

Contributors to this release

We thank the following people for their contributions to this release.

Dave Cramer

Jeremy Mailen

Jorge Solórzano

odubaj

Pavel Bludov

Power

Roman Kozlov

rtrier

Sehrope Sarkuni

Vladimir Sitnikov