PostgreSQL JDBC Driver 42.2.10 Released

Changed

  • (!) Regression: remove receiving EOF from backend after cancel PR 1641. The regression is that the subsequent query might receive the cancel signal.

Added

  • Add maxResultBuffer property PR 1657
  • add caller push of binary data (rebase of #953) PR 1659

Fixed

  • Cleanup PGProperty, sort values, and add some missing to docs PR 1686
  • Fixing LocalTime rounding (losing precision) PR 1570
  • Network Performance of PgDatabaseMetaData.getTypeInfo() method PR 1668
  • Issue #1680 updating a boolean field requires special handling to set it to t or f instead of true or false PR 1682
  • bug in pgstream for replication PR 1681
  • Issue #1677 NumberFormatException when fetching PGInterval with small value PR 1678
  • Metadata queries improvements with large schemas. PR 1673
  • Utf 8 encoding optimizations PR 1444
  • interval overflow PR 1658
  • Issue #1482 where the port was being added to the GSSAPI service name PR 1651
  • remove receiving EOF from backend after cancel since according to protocol the server closes the connection once cancel is sent (connection reset exception is always thrown) PR 1641
  • Unable to register out parameter Issue #1646 PR 1648

[42.2.9] (2019-12-06)

Changed

Added

  • read only transactions PR 1252
  • pkcs12 key functionality PR 1599
  • new “escapeSyntaxCallMode” connection property PR 1560
  • connection property to limit server error detail in exception exceptions PR 1579
  • cancelQuery() to PGConnection public interface PR 1157
  • support for large update counts (JDBC 4.2) PR 935
  • Add Binary Support for Oid. NUMERIC and Oid. NUMERIC_ARRAY PR 1636

Fixed

  • issue 716 getTypeInfo() may not return data in the order specified in Oracle documentation PR 1506
  • PgSQLXML setCharacterStream() results in null value PR 1608
  • get correct column length for simple domains PR 1605
  • NPE as a result of calling executeQuery twice on a statement fixes issue #684 [PR 1610] (https://github.com/pgjdbc/pgjdbc/pull/1610)
  • handle numeric domain types PR 1611
  • pginterval to take iso8601 strings PR 1612
  • remove currentTimeMillis from code, tests are OK PR 1617
  • NPE when calling setNull on a PreparedStatement with no parameters PR 1620
  • allow OUT parameter registration when using CallableStatement native CALL PR 1561
  • add release save point into execute with batch PR 1583
  • Prevent use of extended query protocol for BEGIN before COPY PR 1639

Commits by author

Brett Okken (2):

Craig Ringer (1):

  • Prevent use of extended query protocol for BEGIN before COPY PR 1639 b3711537

Dave Cramer (33):

Dongming (1):

Frane Roje (1):

GregN (2):

  • feat: add new “escapeSyntaxCallMode” connection property PR 1560 d7559138
  • fix: allow OUT parameter registration when using CallableStatement native CALL PR 1561 ed74670f

Igor Volkov (1):

  • Fix exception on PGCopyOutputStream.close() after endCopy() PR 1574 (#1575) 539a0925

IvyDev0 (1):

  • fix: null pointer exception from PgResultSetMetaData when there’s no column metadata PR 1615 08bd46bf

Jorge Solorzano (1):

Knut Wannheden (1):

Lőrinc Pap (1):

  • feat: add caller push of binary data (rebase of PR 953 (#1659) db228a4f

Mahmoud Bahaa (4):

  • Add Binary Support for Oid. NUMERIC and Oid. NUMERIC_ARRAY PR 1636 c85b149d
  • Only allow binary transfer for those Oids that the pgjdbc currently supports PR 1637 ad83cb33
  • Fix test case by changing executeQuery to execute PR 1642 1d47c3cc
  • fix: remove receiving EOF from backend after cancel since according to protocol the server closes the connection once cancel is sent (connection reset exception is always thrown) PR 1641 23cce8ad

Michail Nikolaev (1):

  • fix: do ssl handshake after socket timeout and buffer size settings PR 1584 e39a0be0

Pavel Raiskup (1):

  • rpm: drop BR on properties-maven-plugin 91186c08

Roman Ivanov (1):

Russell Briggs (1):

  • Fix Network Performance of PgDatabaseMetaData.getTypeInfo() method PR 1668 beb354eb

Sehrope Sarkuni (7):

Svein Baardsen (1):

  • fix: PR 1677 NumberFormatException when fetching PGInterval with small value (#1678) e38868b2

Tom Eicher (1):

  • fix: DataSources broken by connection failover urls PR 1039 (#1457) bd9485ef

Torsten Brodbeck (1):

Vladimir Sitnikov (1):

  • style: use fixed checkstyle version so the build does not depend on user machine d164cba2

Yuriy Yudin (1):

Zhenlei Huang (2):

adrklos (1):

bjanczak (1):

draderaws (2):

hyunkshinft (1):

reibitto (1):

rnveach (1):

Árpád Magosányi (2):

  • fix documentation on generating the pk8 key. closes: PR 1585 (#1586) 635cc865
  • security notice and clarifications on choosing the right cipher suite for client key PR 1591 c67b0b0b

Contributors to this release

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

adrklos

Árpád Magosányi

bjanczak

Brett Okken

Craig Ringer

Dave Cramer

Dongming

draderaws

Frane Roje

GregN

hyunkshinft

Igor Volkov

IvyDev0

Jorge Solorzano

Knut Wannheden

Lőrinc Pap

Mahmoud Bahaa

Michail Nikolaev

Pavel Raiskup

reibitto rnveach

Roman Ivanov

Russell Briggs

Sehrope Sarkuni

Svein Baardsen

Tom Eicher

Torsten Brodbeck

Vladimir Sitnikov

Yuriy Yudin

Zhenlei Huang