PostgreSQL JDBC Driver 42.2.10 Released

Notable Changes

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):

feat: read only transactions PR 1252 05079793
Utf 8 encoding optimizations PR 1444 c84e62ef

Craig Ringer (1):

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

Dave Cramer (33):

Add simple test to make sure we can load a key PR 1588 7c591262
Update prepare.md PR 1601 5e48eaa4
fix: issue 716 getTypeInfo() may not return data in the order specified in Oracle documentation PR 1506 9b8a3ffd
chore: Document how to use unix domain sockets. PR 1607 e64b0a2d
fix: PgSQLXML setCharacterStream() results in null value PR 1608 1e370263
add test for table name with values in it PR 1609 47f756fa
fix: get correct column length for simple domains PR 1605 8abf3161
fix: NPE as a result of calling executeQuery twice on a statement fixes issue PR 684 (#1610) 00fa4485
fix:handle numeric domain types PR 1611 7f1752a1
add checks for null results PR 1616 69320c7a
fix: pginterval to take iso8601 strings PR 1612 7b454355
fix: remove currentTimeMillis from code, tests are OK PR 1617 ff4a66d2
fix: NPE when calling setNull on a PreparedStatement with no parameters PR 1620 6899a43d
doc: correct documentation about last applied message fixes PR 760 (#1621) fdf898c7
docs: fix documentation about oids PR 1624 4edca517
fix: javadoc requires throws annotation PR 1625 4258e0d0
fix: Add pkcs12 key functionality PR 1599 82c2008f
Actually test cleanSavePoints PR 1509 97d32caa
fix: DatabaseMetaData.getFunctions should not limit the search to the search_path if the schema is provided PR 1633 8106d3df
feat: WIP Filter DatabaseMetaData using privileges for the user PR 1630 ec76bace
new pr for release notes PR 1640 fa69e7e9
Update 03fdf75d
use TestUtil to find path of certdir PR 1643 4a8a8544
fix: Unable to register out parameter Issue PR 1646 (#1648) ea2ca87c
remove more currentTimeMillis in order to get tests to be more reliable PR 1647 617f0487
fix unstable test. Originally this would loop creating many statements, now it should timeout properly PR 1650 aaccf431
fix: issue 1482 where the port was being added to the GSSAPI service name PR 1651 f7a55cf9
Update README to reflect version 42.2.9 2972add8
be explicit about which JDK PR 1672 39c73a6a
fix: actually use milliseconds instead of microseconds for timeouts PR 1653 3dd5dff2
fix: Issue PR 1680 updating a boolean field requires special handling to set it to t or f instead of true or false (#1682) c266b088
add DatabaseMetaDataCacheTest to test suite to run it PR 1685 b21f474c
fix: Fixes issue PR 1592 where one thread is reading the copy and another thread closes the connection (#1594) 1191076c

Dongming (1):

Adjust the default port to 5432. PR 1619 9a193de7

Frane Roje (1):

Fixing LocalTime rounding (losing precision) PR 1570 a7480d20

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):

feat: support for large update counts (JDBC 4.2) PR 935 0888e935

Knut Wannheden (1):

Fix Markdown formatting issue PR 1576 69edc0b8

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):

minor: fix checkstyle violation of unused import PR 1683 2ea7311e

Russell Briggs (1):

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

Sehrope Sarkuni (7):

Clean up some tests and fix IsValidTest race condition PR 1581 ad734574
Fix test suite order PR 1593 003ea835
fix: Update error message for COPY commands executed using JDBC API PR 1300 c99ed121
Add connection property to limit server error detail in exception exceptions PR 1579 cd0b555c
feat: Add cancelQuery() to PGConnection public interface PR 1157 f0af538f
Add disallow multiple empty lines PR 1427 be5c9f43
Cleanup PGProperty, sort values, and add some missing to docs PR 1686 47e366dd

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):

fix camel case writing of ‘cleanupSavepoints’ PR 1587 0fd45353

Vladimir Sitnikov (1):

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

Yuriy Yudin (1):

fix: add release save point into execute with batch PR 1583 504bb316

Zhenlei Huang (2):

style: prepare for upcoming Checkstyle release 8.28 PR 1654 0b60c626
chore: upgrade checkstyle to 8.28 PR 1660 63316802

adrklos (1):

feat: Add maxResultBuffer property PR 1657 557e2de4

bjanczak (1):

Metadata queries improvements. PR 1673 c574147a

draderaws (2):

Stored procedure with transaction control test case and doc. PR 1645 d10ab8d6
sync error message value with tested value PR 1664 91d422d6

hyunkshinft (1):

fix testSetNetworkTimeoutEnforcement test failure PR 1681 799e78d5

reibitto (1):

Fix interval overflow PR 1658 a44ab4be

rnveach (1):

upgrade maven-checkstyle-plugin to 3.1.0 PR 1573 831115c1

Á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