PostgreSQL JDBC Driver 42.2.9 Released

Notable Changes

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

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

Brett Okken (1):

Craig Ringer (1):

Dave Cramer (20):

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

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

Mahmoud Bahaa (2):

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

Michail Nikolaev (1):

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

Pavel Raiskup (1):

Sehrope Sarkuni (5):

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

Tom Eicher (1):

Torsten Brodbeck (1):

Yuriy Yudin (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