org.postgresql:pgjdbc-aggregate

Notable changes

We have released 42.2.12 to correct regressions in this version: Specifically

• PR 1729 was reverted as this is a breaking change
• PR 1719 has been reverted as it introduced errors in the PgType Cache

We recommend that version 42.2.11 not be used.

Changed

• reverted PR 1729 throw an error instead of silently rolling back a commit error. This change introduced a breaking change which will be moved to 42.3.0
• reverted PR 1719 add support for full names of data types (#1719)

title: PostgreSQL JDBC Driver 42.2.12 Released date: 2020-03-31 13:06:22 +0000 version: 42.2.12

Changed

• reverted PR 1729 throw an error instead of silently rolling back a commit error. This change introduced a breaking change which will be moved to 42.3.0
• reverted PR 1719 add support for full names of data types (#1719)

<!--more-->

Commits by author

Christian Ramseyer (1):

• Remove merge aritfacts and fix a typo PR 1741 3871bfd8

Dave Cramer (1):

• Revert "fix: convert silent rollbacks into exception if application sends commit command PR 1729" (#1746) 14576f4b

Vladimir Sitnikov (1):

• Revert "fix: add support for full names of data types PR 1719" 49d66e4e

Contributors to this release

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

Christian Ramseyer

Dave Cramer

Vladimir Sitnikov

Notable changes As mentioned above this version is broken and should not be used.

Changed

• Reverted PR 1641. The driver will now wait for EOF when sending cancel signals.
• DatabaseMetaData#getProcedures returns only procedures (not functions) for PostgreSQL 11+ PR 1723
• Convert silent rollbacks into exception if application sends commit or xa.prepare command PR 1729

Added

• feat: raiseExceptionOnSilentRollback connection option to configure if silent rollback should raise an exception PR 1729
• feat: Expose ByteStreamWriter in CopyManager PR 1702
• feat: add way to distinguish base and partitioned tables in PgDatabaseMetaData.getTables PR 1708
• refactor: introduce tuple abstraction (rebased) PR 1701
• refactor: make PSQLState enum consts for integrity constraint violations PR 1699
• test: add makefile to create ssl certs PR 1706

Fixed

• fix: Always use . as decimal separator in PGInterval PR 1705
• fix: allow DatabaseMetaData.getColumns to describe an unset scale PR 1716

Changed

• Build system update from Maven to Gradle PR 1627

Added

• docker-compose image for creating test databases (see docker folder)

title: PostgreSQL JDBC Driver 42.2.11 Released date: 2020-03-10 00:00:00 +0300 version: 42.2.11

We have released 42.2.12 to correct regressions in this version: Specifically

• PR 1729 was reverted as this is a breaking change
• PR 1719 has been reverted as it introduced errors in the PgType Cache

We recommend that this version 42.2.11 not be used.

Changed

• Reverted PR 1641. The driver will now wait for EOF when sending cancel signals.
• DatabaseMetaData#getProcedures returns only procedures (not functions) for PostgreSQL 11+ PR 1723
• Convert silent rollbacks into exception if application sends commit or xa.prepare command PR 1729

Added

• Convert silent rollbacks into exception if application sends commit or xa.prepare command PR 1729
• feat: Expose ByteStreamWriter in CopyManager PR 1702
• feat: add way to distinguish base and partitioned tables in PgDatabaseMetaData.getTables PR 1708
• refactor: introduce tuple abstraction (rebased) PR 1701
• refactor: make PSQLState enum consts for integrity constraint violations PR 1699
• test: add makefile to create ssl certs PR 1706

Fixed

• fix: Always use . as decimal separator in PGInterval PR 1705
• fix: allow DatabaseMetaData.getColumns to describe an unset scale PR 1716

<!--more-->

Commits by author

Dave Cramer (4):

• remove the user of the word master internally PR 1713 9a3e0f0c
• Revert "feat: implementation of adaptive fetching PR 1707" (#1717) 13a644b4
• document copy out not closing output stream PR 1721 0faf9ce2
• Update changelog for 42.2.11 PR 1720

Lőrinc Pap (2):

• refactor: introduce tuple abstraction (rebased) PR 1701 ed09fd11
• Expose ByteStreamWriter in CopyManager PR 1702 1e4f4758

Magnus Reftel (1):

• docs: document SocketFactory(Properties) PR 1696 8a8e8ff0

Markus Winand (1):

• Typo in documentation (case instead of cast) PR 1715 630692d6

Mike Goodman (4):

• refactor: make PSQLState enum consts for integrity constraint violations PR 1699 cc31c13f
• feat: add way to distinguish base and partitioned tables in PgDatabaseMetaData.getTables PR 1708 25eb32c8
• fix: add support for full names of data types PR 1719 f554118a
• fix: getProcedures returns only procedures (not functions) for psql11+ PR 1723 5fbe0462

Nick Mancuso (1):

• perf: upgrade maven-checkstyle-plugin to 3.1.1 PR 1726 7da60074

Sehrope Sarkuni (2):

• fix: Correct sort order of PGProperty. ASSUME_MIN_SERVER_VERSION 3ea08125
• test: Add test to check sort order of PGProperty values aa1b93f1

Toddy69 (1):

• fix: Always use . as decimal separator in PGInterval. PR 1705 94641ef0

Vladimir Sitnikov (11):

• test: skip PKCS12KeyTest when enable_ssl_tests is not set 6730f3fe
• test: add makefile for creating test certificates 202f88e1
• Revert "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" ca1f60ff
• Revert "fix unstable test. Originally this would loop creating many statements, now it should timeout properly PR 1650" 5eabe1ae
• style: compute nanoseconds with TimeUnit. SECONDS.toNanos b004c706
• revert: use simple executor.shutdown() in testFastCloses fc5467c6
• Move CopyBothResponseTest to replication folder 2509b663
• doc: fix HTML5 errors in javadoc 161ea249
• fix: convert silent rollbacks into exception if application sends commit command PR 1729 adcb194e
• chore: add continuation_indent_size = 4 to .editorconfig for *.java 45d5831e
• chore: remove end_of_line = lf from .editorconfig for .java 7ce254d2

adrklos (1):

• (reverted) feat: implementation of adaptive fetching PR 1707 5bb5f409

crwr45 (1):

• fix: allow DatabaseMetaData.getColumns to describe an unset scale PR 1716 30843e45

Contributors to this release

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

adrklos

crwr45

Dave Cramer

Lőrinc Pap

Magnus Reftel

Markus Winand

Mike Goodman

Nick Mancuso

Sehrope Sarkuni

Toddy69

Vladimir Sitnikov

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

title: PostgreSQL JDBC Driver 42.2.10 Released date: 2020-01-30 20:12:11 +0000 version: 42.2.10

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

<!--more-->

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

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

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

title: PostgreSQL JDBC Driver 42.2.9 Released date: 2019-12-06 17:52:49 +0000 version: 42.2.9

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

<!--more-->

Brett Okken (1):

• feat: read only transactions PR 1252 05079793

Craig Ringer (1):

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

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

• Adjust the default port to 5432. PR 1619 9a193de7

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

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

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

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

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

Torsten Brodbeck (1):

• fix camel case writing of 'cleanupSavepoints' PR 1587 0fd45353

Yuriy Yudin (1):

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

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

Contributors to this release

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

Árpád Magosányi

Brett Okken

Craig Ringer

Dave Cramer

Dongming

GregN

Igor Volkov

IvyDev0

Jorge Solorzano

Knut Wannheden

Mahmoud Bahaa

Michail Nikolaev

Pavel Raiskup

rnveach

Sehrope Sarkuni

Tom Eicher

Torsten Brodbeck

Yuriy Yudin

Changed

Added

Fixed

• fix: Revert inet default Java type to PGObject and handle values with net masks PR 1568

title: PostgreSQL JDBC Driver 42.2.8 Released date: 2019-09-13 13:23:26 +0000 version: 42.2.8

Changed

Added

Fixed

<!--more-->

Commits by author

Sehrope Sarkuni (1):

• fix: Revert inet default Java type to PGObject and handle values with net masks PR 1568 3df32f9

Contributors to this release

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

Dave Cramer

Sehrope Sarkuni

Changed

Added

• Expose parameter status messages (GUC_REPORT) to the user PR 1435
• Add automatic module name to manifest for jdk9+ PR 1538
• Log ignoring rollback when no transaction in progress PR 1549
• Map inet type to InetAddress PR 1527 issue 1134

Fixed

• fix issue 1547 As long as peek returns some bytes do not reset the timeout, this allows us to continue checking until any async notifies are consumed PR 1548
• fix: issue 1466 In logical decoding the if the backend was requesting a reply we… PR 1467
• fix: issue 1534 Proleptic java.time support PR 1539
• fix Ensure isValid() will not last more than timeout seconds PR 1557

title: PostgreSQL JDBC Driver 42.2.7 Released date: 2019-09-10 13:50:37 +0000 version: 42.2.7

Changed

Added

• Expose parameter status messages (GUC_REPORT) to the user PR 1435
• Add automatic module name to manifest for jdk9+ PR 1538
• Log ignoring rollback when no transaction in progress PR 1549
• Map inet type to InetAddress PR 1527 issue 1134

Fixed

• fix issue 1547 As long as peek returns some bytes do not reset the timeout, this allows us to continue checking until any async notifies are consumed PR 1548
• fix: issue 1466 In logical decoding the if the backend was requesting a reply we… PR 1467
• fix: issue 1534 Proleptic java.time support PR 1539
• fix Ensure isValid() will not last more than timeout seconds PR 1557

<!--more-->

Commits by author

Adrien (1):

• Ensure isValid() will not last more than timeout seconds PR 1557 b2eaefe

Craig Ringer (2):

• Expose parameter status messages (GUC_REPORT) to the user PR 1435 ce8333a
• Make ConnectTimeout test accept NoRouteToHostException PR 1526 08d8129

Dave Cramer (8):

• note that waffle 1.9.x is only supported in jre8 version Update README to point to new maven coordinates 58804e9
• add automatic module name to manifest for jdk9+ PR 1538 0600990
• fix issue 1547, as long as peek returns some bytes do not reset the timeout, this allows us to continue checking until any async notifies are consumed PR 1548 36a75cb
• fix: In logical decoding the if the backend was requesting a reply we… PR 1467 f89e62c
• Log ignoring rollback when no transaction in progress PR 1549 bda74d7
• fix assertion message PR 1553 ba82948
• remove failing tests for PostgreSQL version 8.3 add in tests for 11 89464a5
• Fix travis parsing issue 634ac7d

Hajar Razip (2):

• docs: add note on behavior of ResultSet.getString() PR 1286 (#1528) c30556c
• docs: update resultset.md in head to reflect 94 PR 1528 (#1536) fc8efc9

Matteo Melli (1):

• Updated scram to version 2.0 PR 1532 fcbbc3e

Myo Wai Thant (1):

• Issue 1134 Map inet type to InetAddress PR 1527 1d0c477

Pavel Raiskup (2):

• fix parent version in pgjdbc/pom.xml as well 3db55da
• rpm: remove karaf plugin 8495127

Philippe Marschall (1):

• fix: proleptic java.time support PR 1539 60fa6d3

Sehrope Sarkuni (2):

• docs: Add note to GitHub PR templates about test suites PR 1531 51f3d0b
• Sort test suites and enable missed tests PR 1530 aa8778d

Steinar Bang (1):

• Add an apache karaf feature for the PostgreSQL JDBC driver to fix PR 1552 (#1554) e2f6e9f

Tim Ward (1):

• Check that JDBC Connections that are closed by the server do not report as valid PR 1533 56399ef

Vsevolod Kaimashnikov (1):

• Add more info about currentSchema property. PR 1481 d96ed59

Contributors to this release

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

Adrien

Craig Ringer

Dave Cramer

Hajar Razip

Matteo Melli

Myo Wai Thant

Pavel Raiskup

Philippe Marschall

Sehrope Sarkuni

Steinar Bang

Tim Ward

Vsevolod Kaimashnikov

Known issues

• Waffle has dropped support for 1.6, 1.7 as such the new waffle 1.9.x is only available in jre8
• Microseconds in timestamps might be truncated when transferred in binary mode
• 24:00 time handling is not consistent issue 1385
• Unexpected packet type during stream replication issue 1466
• Driver goes missing after OSGi bundle restart issue 1476

Changed

• Change IS_GENERATED to IS_GENERATEDCOLUMN as per spec PR 1485
• Fix missing metadata columns, and misspelled columns in PgDatabaseMetaData#getTables PR 1323

Added

• CI tests with Java 11, and Java EA
• Support temporary replication slots in ReplicationCreateSlotBuilder PR 1306
• Support PostgreSQL 11, 12
• Return function (PostgreSQL 11) columns in PgDatabaseMetaData#getFunctionColumns
• Return information on create replication slot, now the snapshot_name is exported to allow a consistent snapshot in some uses cases. PR 1335

Fixed

• Fixed async copy performance (1ms per op) in SSL mode PR 1314
• Return Double.NaN for 'NaN'::numeric PR 1304
• Performance issue in PgDatabaseMetaData#getTypeInfo with lots of types in DB PR 1302
• PGCopyInputStream#read should cap values to [0, 255], -1 PR 1349
• Fixes LocalDateTime handling of BC dates PR 1388
• Release savepoints in autosave mode to prevent out of shared memory errors at the server side PR 1409
• Fix execution with big decimal in simple query mode. PR 1463
• Fix rounding for timestamps truncated to dates before 1970 PR 1502

title: PostgreSQL JDBC Driver 42.2.6 Released date: 2019-06-19 00:06:55 +0300 version: 42.2.6

Known issues

• Waffle has dropped support for 1.6, 1.7 as such the new waffle 1.9.x is only available in jre8
• Microseconds in timestamps might be truncated when transferred in binary mode
• 24:00 time handling is not consistent issue 1385
• Unexpected packet type during stream replication issue 1466
• Driver goes missing after OSGi bundle restart issue 1476

Changed

• Change IS_GENERATED to IS_GENERATEDCOLUMN as per spec PR 1485
• Fix missing metadata columns, and misspelled columns in PgDatabaseMetaData#getTables PR 1323

Added

• CI tests with Java 11, and Java EA
• Support temporary replication slots in ReplicationCreateSlotBuilder PR 1306
• Support PostgreSQL 11, 12
• Return function (PostgreSQL 11) columns in PgDatabaseMetaData#getFunctionColumns
• Return information on create replication slot, now the snapshot_name is exported to allow a consistent snapshot in some uses cases. PR 1335

Fixed

• Fixed async copy performance (1ms per op) in SSL mode PR 1314
• Return Double. NaN for 'NaN'::numeric PR 1304
• Performance issue in PgDatabaseMetaData#getTypeInfo with lots of types in DB PR 1302
• PGCopyInputStream#read should cap values to [0, 255], -1 PR 1349
• Fixes LocalDateTime handling of BC dates PR 1388
• Release savepoints in autosave mode to prevent out of shared memory errors at the server side PR 1409
• Fix execution with big decimal in simple query mode. PR 1463
• Fix rounding for timestamps truncated to dates before 1970 PR 1502

<!--more-->

Commits by author

Adam Brusselback (1):

• Add method alias's for each property which didn't use the conventiona… PR 1436 0efcf81c

AlexElin (6):

• chore: add .editorconfig PR 1410 61cc2756
• style: enable checkstyle modules for name checking PR 1411 6b124a05
• test: add tests for Driver and PgConnection PR 1402 7b52b0c9
• chore: add EmptyStatement checkstyle rule PR 1400 4cd3f05a
• chore: add StaticVariableName checkstyle rule PR 1414 ddb38e57
• chore: enable AtclauseOrder checkstyle rule PR 1417 7ae1e833

Andrew Guibert (1):

• Fix inconsistent javadoc for setDefaultAutoCommit PR 1472 fac5e09c

Craig Ringer (2):

• fix: NPE in PGXAConnection$ConnectionHandler.invoke() of .equals(null) PR 1365 cea5231b
• Update waffle-jna to new artifact coordinates PR 1383 72dc692e

Dave Cramer (31):

• docs: update README.md for SSL tests 1fff6043
• Update mailinglist.html 556c93d3
• chore: add jdk11 and jdk12-ea tests to travis b53eedf6
• fix: autosave being overwritten in BaseDataSource by setUrl PR 1309 10201f61
• perf: ignore tables for PgDatabaseMetaData.getTypeInfo PR 1302 e44e4e89
• Update issue_template.md f3ade07d
• Remove tests that use oids fixes PR 1347 (#1348) da4d6577
• Fix setURL in BaseDataSource PR 1341 2ad1ac3f
• Add support for version 11 and version 12 PR 1332 7f0e200a
• fix missing metadata columns, and misspelled columns PR 1323 0ed0e8f2
• fix: Incorrect return value for bytes [128-255] in stream.read PR 1349 325e63b4
• fix: as of v12 recovery.conf is no longer used for standby recovery. … PR 1355 c4656b32
• Update pull_request_template.md PR 1367 be23262b
• Update README.md 2a639fd6
• Fix formatting c0f6b9bd
• Update README.md PR 1404 65f7ea6f
• add matrix including master to test PR 1408 5965f399
• Fix:save points causing server to run out of resources PR 1409 af8f8836
• use postgres column type name in error message PR 1422 fe7eda3d
• fix: Test Case HostSpecTest , tests testShouldResolveWithEmptySocksProxyHost and testShouldResolveWithWhiteSpaceSocksProxyHost PR 1424 0c5cf475
• Update checkstyle to 8.18 PR 1447 ed5f750b
• fix javadoc for defaultAutoCommit to default to true PR 1465 0a4f078e
• autocommit true turns on autocommit by default 31bc6e59
• remove reference to unknown google group PR 1429 129960ea
• Update backend_protocol_v4_wanted_features.md 95ba7b26
• some fixbugs cleanup PR 1486 8bd9062f
• change IS_GENERATED to IS_GENERATEDCOLUMN as per spec PR 1485 17c4bcfb
• undo part of fixbugs pull request that set returned NULL mistakenly PR 1489 27b8fcae
• fix: Error messages cannot be formatted PR 1492 12ef697a
• fix PR 1499 rounding for timestamps truncated to dates before 1970 (#1502) c9a70782
• Fix maven coordinates PR 1479 45ce14fd

Dmitriy Tseyler (1):

• fix: return Double. NaN for 'NaN'::numeric PR 1304 265f22b2

Doug Mayer (1):

• Add core type delimiters into cache for array type OIDs. PR 1416 6a0960a6

Harry Chan (1):

• Optimize toArray PR 1395 (#1396) 2341623b

Ivan Leskin (1):

• Support custom 'options' connection property PR 1356 7be21fc3

Jorge Solorzano (2):

• feat: return info on create slot of replication PR 1335 84e8d90b
• test: fix misspelled secondaryPort2 build property PR 1284 2c0f692b

Kamal Kumlien (1):

• docs: cosmetic fixes on sample settings PR 1379 d0453b75

Kevin Wooten (1):

• Fixes LocalDateTime handling of BC dates PR 1388 ebada4af

Krzysztof Szafrański (1):

• Fix logging level PR 1446 f8c112cb

Marc Dean (1):

• Add DEADLOCK_DETECTED Enumeration PR 1380 a7f63bff

Mark Nguyen (1):

• docs: Add DEM format details for sslkey PR 1376 10945e34

Mykola Nikishov (2):

• Fix link to Test Suite Howto PR 1369 33ac76d1
• refactor: remove unused method encode3to4 from Base64 PR 1370 bac4bc1a

Nikolai Ivanov (1):

• fix: improper relative cursor movement PR 1462 b6ab27c1

Philip Sanetra (1):

• feat: Extend ReplicationCreateSlotBuilder DSL to support temporary replications slots PR 1306 d514ceb5

Sehrope Sarkuni (4):

• Fix TestUtil.dropXyz(...) object not exists errors PR 1359 0999bb78
• refactor: Clean up loading of reading of keydata file in LazyKeyManager PR 1372 9b45e709
• Fix metadata test to use explicit PK/FK names PR 1442 42d6bfa5
• Cleanup encoding PR 1441 73ec8173

Sualeh Fatehi (2):

• Fix: getFunctionColumns used to return ProcedureColumns, now returns function columns b8a86807
• Update testing documents, and point to jackdb/pgjdbc-test-vm PR 1363 2a715a98

Tyson Andre (1):

• docs: Fix typos in docs detected by codespell PR 1361 5b0c05fb

Vladimir Sitnikov (9):

• docs: reflect 42.2.5 release in readme.md d43398a5
• perf: fix 1ms per async CopyAPI (regression since 42.2.5) PR 1314 e2623d63
• chore: use openjdk7 to boostrap Travis CI images for JDK 6 PR 1366 cdfd49cf
• test: avoid locale-dependent output in SetObject310Test ef14ceae
• fix: date rounding errors for dates before 1970 b5653899
• docs: update translation files 9fcaa98e
• fix: temporary make LibPQFactory. ConsoleCallbackHandler public 95d8da60
• Update pgjdbc-parent-poms to 1.1.6 to use updated waffle-jna f0a297db
• Update changelog for 42.2.6 8944fa67

itchyny (1):

• docs: fix link to pull request 1052 in 42.2.3 changelog PR 1345 9f248e12

jajalvipul (1):

• Added break statement to avoid the additional iterations in for loop PR 1406 6b13f7b7

kaiwangchen (1):

• Fix execution with big decimal in simple query mode. PR 1463 8e47a303

kazachka (2):

• style: remove extra empty lines PR 1452 5e48c4d0
• style: remove extra empty lines PR 1454 cb466d1b

maltalex (1):

• Make LogSequenceNumber implement Comparable PR 1494 1970c4a3

pbillen (1):

• Allow setFlushedLSN(lsn) and setAppliedLSN(lsn) from outside main loop PR 1329 381cf45c

rnveach (1):

• fix: improper indentation for javadoc PR 1434 35df0dde

Contributors to this release

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

Adam Brusselback

AlexElin

Andrew Guibert

Craig Ringer

Dave Cramer

Dmitriy Tseyler

Doug Mayer

Harry Chan

itchyny

Ivan Leskin

jajalvipul

Jorge Solorzano

kaiwangchen

Kamal Kumlien

kazachka

Kevin Wooten

Krzysztof Szafrański

maltalex

Marc Dean

Mark Nguyen

Mykola Nikishov

Nikolai Ivanov

pbillen

Philip Sanetra

rnveach

Sehrope Sarkuni

Sualeh Fatehi

Tyson Andre

Vladimir Sitnikov

Known issues

• 1ms per async copy call issue 1312

Changed

• ssl=true implies sslmode=verify-full, that is it requires valid server certificate cdeeaca4

targetServerType=master has been deprecated in favour of targetServerType=primary. master will still be accepted but not documented.

Added

• Support for sslmode=allow/prefer/require cdeeaca4

Fixed

• Security: added server hostname verification for non-default SSL factories in sslmode=verify-full (CVE-2018-10936) cdeeaca4
• Updated documentation on SSL configuration fa032732
• Updated Japanese translations PR 1275
• IndexOutOfBounds on prepared multistatement with insert values c2885dd0

title: PostgreSQL JDBC Driver 42.2.5 Released date: 2018-08-27 18:21:38 +0300 version: 42.2.5

Known issues

• 1ms per async copy call issue 1312

Changed

• ssl=true implies sslmode=verify-full, that is it requires valid server certificate cdeeaca4

Added

• Support for sslmode=allow/prefer/require cdeeaca4

Fixed

• Security: added server hostname verification for non-default SSL factories in sslmode=verify-full (CVE-2018-10936) cdeeaca4
• Updated documentation on SSL configuration fa032732
• Updated Japanese translations PR 1275
• IndexOutOfBounds on prepared multistatement with insert values c2885dd0

<!--more-->

Commits by author

Christoph Berg (1):

• chore: remove editor backup files PR 1255 b1b1afb8

Dave Cramer (4):

• Update Contributing.md 1f8ac406
• Add issue templates PR 1263 c66bf710
• move issue template and pull request template into github specific di… PR 1283 b5c19af6
• docs: improve documentation on SSL fa032732

Kazuhiro Sera (1):

• docs: fix typos detected by github.com/client9/misspell PR 1287 9534e9ca

Kyotaro Horiguchi (1):

• fix: Japanese translation PR 1275 993a3beb

Sehrope Sarkuni (1):

• fix: Correct typo in CopyManager comment PR 1285 203a106d

Vladimir Sitnikov (12):

• reflect 42.2.4 release in readme.md b99cea0d
• doc: add SQL_TSI to the known issues for 42.2.3 [ci-skip] 2da319a0
• docs: escape underscores in changelog otherwise it produces italic b1507f84
• docs: typo in 42.2.3 changelog "minute->second" 5898cdf1
• refactor: remove unused PgPreparedStatement.adjustIndex PR 1253 178eecc9
• test: run testShortQueryTimeout in PG_VERSION=HEAD Travis job only PR 1270 ecd412e4
• fix: remove POT-Creation-Date from generated .po and .pot files PR 1269 450a496b
• fix: use UTF-8 encoding in generated translation/messages_*.java files 2cbe7b35
• fix: typo in "One ore more ClientInfo failed" error message [ci skip] 21e126f4
• fix: IndexOutOfBounds on prepared multistatement with insert values PR 1289 c2885dd0
• security: implement SSL hostname verification for non-default (LibPQFactory) SSL factories (CVE-2018-10936) cdeeaca4
• Update changelog for 42.2.5 237a89bf

Contributors to this release

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

Christoph Berg

Dave Cramer

Kazuhiro Sera

Kyotaro Horiguchi

Sehrope Sarkuni

Vladimir Sitnikov

Changed

• PreparedStatement.setNull(int parameterIndex, int t, String typeName) no longer ignores the typeName argument if it is not null PR 1160

Fixed

• Fix treatment of SQL_TSI_YEAR, SQL_TSI_WEEK, SQL_TSI_MINUTE PR 1250
• Map integrity constraint violation to XA_RBINTEGRITY instead of XAER_RMFAIL PR 1175 f2d1352c

title: PostgreSQL JDBC Driver 42.2.4 Released date: 2018-07-14 19:02:04 +0300 version: 42.2.4

Changed

• PreparedStatement.setNull(int parameterIndex, int t, String typeName) no longer ignores the typeName argument if it is not null PR 1160

Fixed

• Fix treatment of SQL_TSI_YEAR, SQL_TSI_WEEK, SQL_TSI_MINUTE PR 1250
• Map integrity constraint violation to XA_RBINTEGRITY instead of XAER_RMFAIL PR 1175 f2d1352c

<!--more-->

Commits by author

Christian Kotzbauer (1):

• Fixed typo in CHANGELOG.md PR 1249 b20df919

Dave Cramer (3):

• use the correct date for the release 985b63b7
• also fix spelling of error b0162c0a
• fix: setNull for types not in java.sql. Types (e.g. uuid) PR 1160 6287c954

Jan Van den Bergh (1):

• fix: map integrity constraint violation to XA_RBINTEGRITY instead of XAER_RMFAIL PR 1175 f2d1352c

Pavel Raiskup (1):

• packaging: sync RPM spec with Fedora Rawhide cc545d28

Vladimir Sitnikov (2):

• docs: fix broken commit link in 42.2.3 changelog 776e1717
• fix: treatment of SQL_TSI_YEAR, SQL_TSI_WEEK, SQL_TSI_MINUTE PR 1250 4668f43f

Contributors to this release

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

Christian Kotzbauer

Dave Cramer

Jan Van den Bergh

Pavel Raiskup

Vladimir Sitnikov

Known issues

• SQL_TSI_YEAR is treated as hour, SQL_TSI_WEEK is treated as hour, SQL_TSI_MINUTE is treated as second

Changed

• Reduce the severity of the error log messages when an exception is re-thrown. The error will be thrown to caller to be dealt with so no need to log at this verbosity by pgjdbc PR 1187
• Deprecate Fastpath API PR 903
• Support parenthesis in {oj ...} JDBC escape syntax PR 1204
• ubenchmark module moved pgjdbc/benchmarks repository due to licensing issues PR 1215
• Include section on how to submit a bug report in CONTRIBUTING.md PR 951

Fixed

• getString for PGObject-based types returned "null" string instead of null PR 1154
• Field metadata cache can be disabled via databaseMetadataCacheFields=0 PR 1052
• Properly encode special symbols in passwords in BaseDataSource PR 1201
• Adjust date, hour, minute, second when rounding nanosecond part of a timestamp PR 1212
• perf: reduce memory allocations in query cache PR 1227
• perf: reduce memory allocations in SQL parser PR 1230, PR 1233
• Encode URL parameters in BaseDataSource PR 1201
• Improve JavaDoc formatting PR 1236

title: PostgreSQL JDBC Driver 42.2.3 Released date: 2018-07-12 12:02:03 +0300 version: 42.2.3

Known issues

• SQL_TSI_YEAR is treated as hour, SQL_TSI_WEEK is treated as hour, SQL_TSI_MINUTE is treated as second (fixed in 42.2.4)

Changed

• Reduce the severity of the error log messages when an exception is re-thrown. The error will be thrown to caller to be dealt with so no need to log at this verbosity by pgjdbc PR 1187
• Deprecate Fastpath API PR 903
• Support parenthesis in {oj ...} JDBC escape syntax PR 1204
• ubenchmark module moved pgjdbc/benchmarks repository due to licensing issues PR 1215
• Include section on how to submit a bug report in CONTRIBUTING.md PR 951

Fixed

• getString for PGObject-based types returned "null" string instead of null PR 1154
• Field metadata cache can be disabled via databaseMetadataCacheFields=0 PR 1052
• Properly encode special symbols in passwords in BaseDataSource PR 1201
• Adjust date, hour, minute, second when rounding nanosecond part of a timestamp PR 1212
• perf: reduce memory allocations in query cache PR 1227
• perf: reduce memory allocations in SQL parser PR 1230, PR 1233
• Encode URL parameters in BaseDataSource PR 1201
• Improve JavaDoc formatting PR 1236

<!--more-->

AlBundy33 (1):

• fix: support parenthesis in {oj ...} JDBC escape syntax PR 865 38356e68

AlexElin (3):

• refactor: deprecate Fastpath API PR 903 f8e21b63
• refactor: migrate MultiHostsConnectionTest to JUnit4 PR 886 17a4d6a5
• refactor: simplify PgConnection.java PR 1047 ba360f73

Dave Cramer (3):

• fixed spelling mistake in PostgreSQL PR 1202 b92bd65a
• docs: improve javadocs in PgResultSetMetaData PR 792 825c0924
• minor language updates PR 1241 e19ee7ae

Hari Babu Kommi (2):

• spelling mistake correction PR 1181 e88abd79
• fix: set the loggerName in ConnectionFactoryImpl.log PR 1188 f78a639d

Jesper Pedersen (1):

• perf: guard logging statements PR 1112 7a0b7d65

Jorge Solorzano (6):

• fix: error on Travis build head PR 1186 354d2857
• test: add coverage for extendedCacheEverything PR 1062 f4d503c2
• Update after_n_builds to 10 PR 1193 2f9fed45
• test: drop OpenJ9 CI tests PR 1196 9b6506df
• fix: logger should be generally quiet PR 1187 30f06e14
• docs: improve CONTRIBUTING.md PR 951 38c8845e

KimBisgaardDmi (1):

• fix: getString for PGObject columns returns null PR 1154 bbb6c1f8

Marc Slemko (1):

• fix: allow disabling field metadata cache PR 1052 6ce91721

Michele Mancioppi (1):

• docs: clarify database and username for the build PR 859 83f2e385

Pavel Raiskup (1):

• packaging: fix RPM build requirements 6bb72e69

Sidi Mohamed EL AATIFI (1):

• Fix typos in java8-date-time.md PR 1174 dde8c020

Stephen Nelson (2):

• chore: add missing javadoc tags to avoid warnings PR 1164 e9ced455
• docs: correct the Javadoc and enforce with Checkstyle PR 1236 08631ccd

Vladimir Sitnikov (19):

• reflect 42.2.2 release in readme.md b1581e99
• fix: avoid NPE in PgConnection.finalize PR 1206 03a1441b
• chore: update gettext plugin, sort po files eb5c8fdd
• chore: sort messages in *.po files 10fc2fbb
• chore: remove obsolete translations ed1eab9e
• doc: add Russian translation to "No IOException expected..." eaa0acad
• fix: adjust date, hour, minute, second when rounding timestamp PR 1212 4dc98be8
• chore: remove ubenchmark module due to licensing issues PR 1215 88ec13bb
• chore: remove ubenchmark from packaging/rpm as well a699965a
• fix: support query timeouts exceeding 2147483 seconds (~25 days) PR 1224 b7fd9f3c
• perf: improve performance of replacing JDBC {...} escapes PR 1230 177f63be
• docs: use union merge strategy for CHANGELOG PR 1107 70189203
• chore: use 5432 as default port when running code from IDE 5dc03f63
• docs: use "PR 42" references instead of "PRPR 42" in the changelog (#1239) f4ae60ec
• test: close of replication connection has not been fixed at backend side, so disable the test till 12.1 PR 1243 481460a3
• perf: avoid string allocation for oid/rows parsing in command tag PR 1232 da831de5
• docs: prepare changelog for 42.2.3 release c5f5d8d2
• chore: fetch contributors' URL via GitHub API d7297984
• docs: update site for 42.2.3

bazzargh (1):

• fix: encode url query parameters DataSource PR 1201 9f3838f7

benbenw (2):

• refactor: remove obsolete outParmBeforeFunc PR 1234 71028532
• perf: improve parsing performance of JDBC-style { call ...} calls PR 1233 435e2f79

benoit (3):

• perf: reduce memory allocations when JDBC escapes ({fn ...}) are used 2a1e0910
• refactor: use singleArgumentFunctionCall in EscapedFunctions 191d84eb
• perf: avoid BaseQueryKey.toString in CachedQuery.getSize PR 1227 669fc31e

bpd0018 (1):

• style: rephrase comment on named portals PR 1129 86c46f94

Étienne BERSAC (1):

• docs: fix link to GitHub documentation PR 1191 655b6e70

Contributors to this release

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

AlBundy33

AlexElin

bazzargh

benbenw

benoit

bpd0018

Dave Cramer

Étienne BERSAC

Hari Babu Kommi

Jesper Pedersen

Jorge Solorzano

KimBisgaardDmi

Marc Slemko

Michele Mancioppi

Pavel Raiskup

Sidi Mohamed EL AATIFI

Stephen Nelson

Vladimir Sitnikov

Added

• Documentation on server-side prepared statements PR 1135

Fixed

• Avoid failure for insert ... on conflict...update for reWriteBatchedInserts=true case PR 1130
• fix: allowEncodingChanges should allow set client_encoding=... PR 1125
• Wrong data from Blob/Clob when mark/reset is used PR 971
• Adjust XAException return codes for better compatibility with XA specification PR 782
• Wrong results when single statement is used with different bind typesPR 1137
• Support generated keys for WITH queries that miss RETURNING PR 1138
• Support generated keys when INSERT/UPDATE/DELETE keyword is followed by a comment PR 1138

title: PostgreSQL JDBC Driver 42.2.2 Released date: 2018-03-15 18:55:14 +0300 version: 42.2.2

Added

• Documentation on server-side prepared statements PR 1135

Fixed

• Avoid failure for insert ... on conflict...update for reWriteBatchedInserts=true case PR 1130
• fix: allowEncodingChanges should allow set client_encoding=... PR 1125
• Wrong data from Blob/Clob when mark/reset is used PR 971
• Adjust XAException return codes for better compatibility with XA specification PR 782
• Wrong results when single statement is used with different bind typesPR 1137
• Support generated keys for WITH queries that miss RETURNING PR 1138
• Support generated keys when INSERT/UPDATE/DELETE keyword is followed by a comment PR 1138

<!--more-->

Commits by author

Dave Cramer (5):

• Update java8-date-time.md 643e5583
• Update about.html 6fe76a3c
• Update documentation.md 3b3fd8c9
• Update documentation.md a8ef9f96
• test: add Travis configuration to test SSL PR 1095 298683b1

Jorge Solorzano (1):

• fix: improve DatabaseMetaData.getSQLKeywords() PR 940 7a586b6e

Pawel (1):

• Fixes #1096 PR 1097 df4e7fa0

Selene Feigl (1):

• fix: wrong data from Blob/Clob when mark/reset is used PR 971 61e1c300

Simon Stelling (1):

• fix: handle Timestamp values with fractional seconds < 1 microsecond correctly in PreparedStatement arguments PR 1119 8ff2a617

Vladimir Sitnikov (14):

• docs: reflect 42.2.1 release in readme.md 1a4256b9
• chore: make sure TEST_CLIENTS performs regular tests as well aa676bb3
• chore: remove unused variable lastKnownTime in ConnectionFactoryImpl 48b98971
• fix: ArrayIndexOutOfBoundsException when using the same SQL for regular and updateable resultset PR 1123 45c32bc6
• fix: support insert ... on conflict...update for reWriteBatchedInserts=true PR 1130 1ca0c586
• fix: allowEncodingChanges should allow set client_encoding=... PR 1125 af64ed2d
• tests: UUID vs setString test PR 1133 5827858b
• fix: UUID test for preferQueryMode=simple 44bb7f8d
• fix: wrong results when a single statement is used with UNSPECIFIED types PR 1137 fcd1ea14
• test: workaround DST issue in StatementTest#testDateFunctions af499625
• docs: improve documentation and tests for server-side prepared statements PR 1135 4204f094
• test: make testAlternatingBindType Java 6-compatible PR 1139 bcdd4273
• fix: better support for RETURNING for WITH queries and queries with comments PR 1138 04e76661
• chore: add contributor links to release script 2568d38e

bpd0018 (3):

• docs: fix spelling and chapter, update sample code PR 1098 0cfffa84
• style: spelling in comment PR 1121 cc219aa7
• docs: fix JavaDoc for getPreferQueryMode() PR 1122 43d80cd4

chalda (1):

• Adjust XAException return codes for better compatibility with XA specification PR 782 e5aab1cd

trtrmitya (1):

• fix: use Locale. Category. DISPLAY (~lc_messages) when selecting resource bundle. PR 1115 0e9dfce4

Contributors to this release

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

Dave Cramer

Jorge Solorzano

Pawel

Selene Feigl

Simon Stelling

Vladimir Sitnikov

bpd0018

chalda

trtrmitya

Known issues

• client_encoding has to be UTF8 even with allowEncodingChanges=true

Changed

• socksProxyHost is ignored in case it contains empty string PR 1079

Fixed

• Avoid connection failure when DateStyle is set to ISO (~PgBouncer) Issue 1080
• Package scram:client classes, so SCRAM works when using a shaded jar PR 1091 1a89290e
• reWriteBatchedInserts=true causes syntax error with ON CONFLICT Issue 1045 PR 1082
• Avoid failure in getPGArrayType when stringType=unspecified PR 1036
• For PostgreSQL 9.0+ return a complete list of keywords in DatabaseMetadata.getSQLKeywords() from pg_catalog.pg_get_keywords(). PR 940

title: PostgreSQL JDBC Driver 42.2.1 Released date: 2018-01-25 19:30:35 +0300 version: 42.2.1

Known issues

• client_encoding has to be UTF8 even with allowEncodingChanges=true

Changed

• socksProxyHost is ignored in case it contains empty string PR 1079

Fixed

• Avoid connection failure when DateStyle is set to ISO (~PgBouncer) Issue 1080
• Package scram:client classes, so SCRAM works when using a shaded jar PR 1091 1a89290e
• reWriteBatchedInserts=true causes syntax error with ON CONFLICT Issue 1045 PR 1082
• Avoid failure in getPGArrayType when stringType=unspecified PR 1036

<!--more-->

Commits by author

AlexElin (1):

• test: check if url is not for PostgreSQL PR 1077 fe463bce

Alexander Kjäll (1):

• feat: add support for fetching 'TIMESTAMP(6) WITHOUT TIME ZONE' as LocalDate to getObject() PR 1083 09af4b23

Dave Cramer (1):

• fix: package scram:client classes, so SCRAM works when using a shaded jar PR 1091 1a89290e

Ivan (2):

• chore: remove braces for LeftCurlyCheck checkstyle PR 1075 c2664b44
• chore: remove additional braces for LeftCurlyCheck checkstyle PR 1076 975aaf5a

JCzogalla (1):

• Fixes issue #1078 PR 1079 0d51370b

Jamie Pullar (1):

• fix: getPGArrayType fails in when stringType=unspecified PR 1036 d5f1cf7c

Jorge Solorzano (1):

• Fix style changelog PR 1089 5ebd2090

Pavel Raiskup (1):

• packaging: update Fedora's CI dcbf70bc

Vladimir Sitnikov (3):

• docs: reflect 42.2.0 release in readme.md 6d02e958
• fix: avoid connection failure when DateStyle is set to ISO PR 1081 e442db1f
• fix: reWriteBatchedInserts=true causes syntax error with ON CONFLICT PR 1082 e133510e

Contributors to this release

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

AlexElin

Alexander Kjäll

Dave Cramer

Ivan

JCzogalla

Jamie Pullar

Jorge Solorzano

Pavel Raiskup

Vladimir Sitnikov

Known issues

• SCRAM does not work as scram:client library is not packaged
• client_encoding has to be UTF8 even with allowEncodingChanges=true

Added

• Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library. PR 842
• Make SELECT INTO and CREATE TABLE AS return row counts to the client in their command tags. Issue 958 PR 962
• Support Subject Alternative Names for SSL connections. PR 952
• Support isAutoIncrement metadata for PostgreSQL 10 IDENTITY column. PR 1004
• Support for primitive arrays PR#887 3e0491a
• Implement support for get/setNetworkTimeout() in connections. PR 849
• Make GSS JAAS login optional, add an option "jaasLogin" PR 922 see Connecting to the Database

Changed

• Improve behaviour of ResultSet.getObject(int, Class). PR 932
• Parse CommandComplete message using a regular expression, allows complete catch of server returned commands for INSERT, UPDATE, DELETE, SELECT, FETCH, MOVE, COPY and future commands. PR 962
• Use 'time with timezone' and 'timestamp with timezone' as is and ignore the user provided Calendars, 'time' and 'timestamp' work as earlier except "00:00:00" now maps to 1970-01-01 and "24:00:00" uses the system provided Calendar ignoring the user-provided one PR 1053
• Change behaviour of multihost connection. The new behaviour is to try all secondaries first before trying the master PR 844.
• Avoid reflective access to TimeZone.defaultTimeZone in Java 9+ PR 1002 fixes Issue 986

Fixed

• Make warnings available as soon as they are received from the server. This is useful for long running queries, where it can be beneficial to know about a warning before the query completes. PR 857
• Use 00:00:00 and 24:00:00 for LocalTime.MIN/MAX. PR 992
• Now the DatabaseMetaData.getFunctions() implementation complies with the JDBC docs. PR 918
• Execute autosave/rollback savepoint via simple queries always to prevent "statement S_xx not exists" when autosaving fixes Issue #955
• Received resultset tuples, but no field structure for them" when bind failure happens on 5th execution of a statement Issue 811

Removed

• Drop support for the (insecure) crypt authentication method. PR 1026

Deprecated

• Reintroduce Driver.getVersion for backward compatibility reasons, mark it as deprecated as application should not rely on it (regression since 42.0.0) 50d5dd3e

title: PostgreSQL JDBC Driver 42.2.0 Released date: 2018-01-17 20:11:10 +0300 version: 42.2.0

Known issues

• SCRAM authentication does not work as scram client classes are not packaged
• client_encoding has to be UTF8 even with allowEncodingChanges=true

Added

• Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library. PR 842
• Make SELECT INTO and CREATE TABLE AS return row counts to the client in their command tags. Issue 958 PR 962
• Support Subject Alternative Names for SSL connections. PR 952
• Support isAutoIncrement metadata for PostgreSQL 10 IDENTITY column. PR 1004
• Support for primitive arrays PR 887 3e0491a
• Implement support for get/setNetworkTimeout() in connections. PR 849
• Make GSS JAAS login optional, add an option "jaasLogin" PR 922 see Connecting to the Database

Changed

• Improve behaviour of ResultSet.getObject(int, Class). PR 932
• Parse CommandComplete message using a regular expression, allows complete catch of server returned commands for INSERT, UPDATE, DELETE, SELECT, FETCH, MOVE, COPY and future commands. PR 962
• Use 'time with timezone' and 'timestamp with timezone' as is and ignore the user provided Calendars, 'time' and 'timestamp' work as earlier except "00:00:00" now maps to 1970-01-01 and "24:00:00" uses the system provided Calendar ignoring the user-provided one PR 1053
• Change behaviour of multihost connection. The new behaviour is to try all secondaries first before trying the master PR 844.
• Avoid reflective access to TimeZone.defaultTimeZone in Java 9+ PR 1002 fixes Issue 986

Fixed

• Make warnings available as soon as they are received from the server. This is useful for long running queries, where it can be beneficial to know about a warning before the query completes. PR 857
• Use 00:00:00 and 24:00:00 for LocalTime. MIN/MAX. PR 992
• Now the DatabaseMetaData.getFunctions() implementation complies with the JDBC docs. PR 918
• Execute autosave/rollback savepoint via simple queries always to prevent "statement S_xx not exists" when autosaving fixes Issue #955
• Received resultset tuples, but no field structure for them" when bind failure happens on 5th execution of a statement Issue 811

Removed

• Drop support for the (insecure) crypt authentication method. PR 1026

Deprecated

• Reintroduce Driver.getVersion for backward compatibility reasons, mark it as deprecated as application should not rely on it (regression since 42.0.0) 50d5dd3e
• slave and preferSlave values for the targetServerType connection property have been deprecated in favour of secondary and preferSecondary respectively.

<!--more-->

AlexElin (9):

• docs: fix header in CONTRIBUTING PR 902 38ff0fe
• refactor: remove dead code from PGStream, implement Closeable PR 901 acff949
• refactor: replace some usages of assertTrue PR 957 c759a58
• refactor: state of PGXAConnection as enum PR 966 7618822
• refactor: make PgStream implements Flushable PR 1008 0c3a2fc
• style: add MissingDeprecated into checkstyle PR 1019 d74386d
• chore: update checkstyle PR 1025 69e3b8b
• refactor: simplify methods in ConnectionFactoryImpl PR 1028 ed27c5b
• refactor: replace some usages of initCause PR 1037 0c29823

Álvaro Hernández Tortosa (1):

• Add SCRAM-SHA-256 support PR 842 befea18

Barnabas Bodnar (1):

• fix: don't attempt to read a SQLXML more than once PR 965 8f5e245

Brett Okken (1):

• feat: primitive arrays PR 887 3e0491a

Brett Wooldridge (1):

• Fixes #638 Implement support for get/setNetworkTimeout() PR 849 8a30044

Chen Huajun (1):

• fix: improve multihost connection for preferSlave case (verify expired hosts before connecting to cached master) PR 844 c6fec34

Dave Cramer (11):

• Update thread safety status of the driver to reflect reality; that being that the driver is not thread safe PR 928 ad47aba
• fix: use 00:00:00 and 24:00:00 for LocalTime. MIN/MAX PR 992 f2d8ec5
• fix: support Subject Alternative Names for SSL connections PR 952 2dcb91e
• test: Appveyor configuration PR 1000 059628f
• add test for identity, fix isAutoincrement in postgresql 10 fixes #130 PR 1004 2f6633b
• elaborate on sslmode options PR 1054 aa7a420
• prefer the word secondary over slave PR 1063 2e8c2b6
• Revert "refactor: replace some usages of initCause PR 1037" (#1064) e6a1ecc
• prefer secondary over slave referring to standby or secondary servers PR 1070 32c53902
• first pass at release notes and some fixes to previous notes PR 1041 a8260f5
• Update 2018-01-16-42.2.0-release.md b36867f

Hugh Cole-Baker (1):

• Make GSS JAAS login optional PR 922 d7f0f27

Jeff Klukas (1):

• fix: advance lastReceiveLSN on keepalive messages PR 1038 1be8a9e

Joe Kutner (1):

• fix: Added support for socksNonProxyHosts property PR 975 (#985) 9813c68

Jorge Solorzano (13):

• chore: use mainly Trusty in Travis, reorder CI jobs, and jdk tests PR 939 646a868
• fix: ignore replication test until 11.1 to avoid random failures PR 949 ee6443d
• chore: streamlining jobs PR 959 ed0a398
• docs: move changelog to separate file PR 956 e67e8f9
• docs: improve website front page PR 968 65170f1
• docs: fix test db password in docs PR 984 7df56f8
• test: add openj9 to the matrix PR 974 f187645
• chore: remove testing of the latest Java updates PR 993 0d8fde6
• chore: updates to CHANGELOG.md in release_notes.sh PR 981 bdfc1db
• test: querymode extendedCacheEverything PR 1007 f574285
• fix: first composite query not calling getNativeSql() PR 1020 2cae5a1
• drop old and unused crypt auth PR 1026 405f14e
• chore: collect coverage for Java 7 PR 1030 b629934

Magnus (1):

• fix: make warnings available as soon as they are received PR 857 83dd5fe

Magnus Hagander (1):

• Fix documentation spelling of sslpasswordcallback PR 1021 8ba5841

MichaelZg (1):

• fix: trim trailing zeros in timestamp strings returned in binary mode PR 896 d28deff

Michael Glaesemann (1):

• refactor: use TypeInfo getPGArrayType instead of munging type name PR 913 634e157

Pavel Raiskup (2):

• packaging: rpm_ci: add missing BuildRequires 4e0cdc1
• packaging: rpm_ci: don't shade scram jar into pgjdbc 1fd6c4f

Philippe Marschall (2):

• feat: improve ResultSet#getObject(int, Class) PR 932 fcb28c7
• test: add ubenchmark for UTF-8 decoding PR 988 0d918c3

Piyush Sharma (1):

• doc: Added quotes to URL in '@see' tag over org.postgresql.sspi. NTDSAPI#DsMakeSpnW for syntactic correctness PR 926 29f574a

Sehrope Sarkuni (1):

• feat: parse command complete message via regex PR 962 097db5e

Thach Hoang (2):

• Update ServerVersionTest to actually compare versions PR 1015 cccd6cd
• fix: always return Short[] for java.sql. Array.getArray() on smallint[] PR 1017 279fb43

Vladimir Sitnikov (23):

• fix: reintroduce Driver.getVersion for backward compatibility reasons PR 905 50d5dd3
• style: make PGReplicationStream, LargeObject implement AutoCloseable for Java 7+ PR 1016 9f07c9a
• fix: prevent statement hang in case close() called when query is in progress PR 1022 04c5dbb
• fix: synchronize Statement#result field access to make #close() more thread-safe 4139248
• fix: avoid reflective access to TimeZone.defaultTimeZone in Java 9+ PR 1002 fd0eeee
• fix: throw TOO_MANY_RESULTS (0100E) instead of "PgResultSet: tuples must be non-null" 0d31d46
• fix: "Received resultset tuples, but no field structure for them" when bind failure happens on 5th execution of a statement PR 811 082d009
• tests: correct assertion to use proper column 63918eb
• fix: add type parameter so code is Java 6/7 compatible 1361c52
• chore: avoid non-blocking IO for stdout to workaround "stdout: write error" in Travis 12bb084
• test: run Travis tests with non-default time zone a3982b4
• fix: execute autosave/rollback savepoint via simple queries always to prevent "statement S_xx not exists" when autosaving PR 955 684a699
• fix: use 'time with time zone' and 'timestamp with time zone' values as is and avoid computation with user-provided/default Calendars e8c43f3
• test: refactor SetObject310Test to use proper assertion messages and use less statements (make it faster) be06946
• refactor: factor out receiveParameterStatus so all the ParameterStatus messages are handled in the same way a94cfea
• fix: add Provide-Capability OSGi manifest PR 1029 236805b
• chore: update version to 42.2.0-SNAPSHOT to reflect the next release version e27ee74
• packaging: add missing maven-clean-plugin dependency a2ed9b5
• chore: introduce release via Travis acb9bdd
• chore: skip CI builds for tags; skip Fedora and extendedCacheEverything jobs when building pull requests 3ba3b63
• fix: avoid NPE from getObject(..., Date.class) and getObject(..., Calendar.class) on null timestamps PR 1071 eb33c4c
• test: add "as" to test queries so they work with PostgreSQL 8.3 71b3c11
• docs: make pgjdbc's javadocs to inherit base Java documentation eb406dc

Zemian Deng (3):

• refactor: use PGProperty enum instead of text ref for targetServerType, hostRecheckSeconds, loadBalanceHosts PR 912 (#915) b0cfc33
• fix: correct javadoc on PGResultSetMetaData.getFormat PR 917 cd77693
• fix: Correct DatabaseMetaData.getFunctions() implementation PR 918 8884202

bpd0018 (3):

• docs - change load.md to reflect current practice PR 1058 90535d9
• docs: fix the URL regex PR 1057 6c5490f
• docs: fix no parameter connect string example PR 1056 bb8a315

djydewang (1):

• style: disallowing user to use incomplete fully qualified Check names in config file PR 961 3286c8c

eperez (1):

• Someone forgot to get the next column PR 973 15aec6a

mjanczykowski (1):

• feat: add setURL method to BaseDataSource PR 999 2277ffb

rnveach (1):

• style: remove deprecated maxLineLength from LeftCurlyCheck PR 904 5f083d1

steinarb (1):

• fix: add Provide-Capability org.osgi.service.jdbc. DataSourceFactory to OSGi manifest Issue 1029

zapov (1):

• fix: avoid integer overflow when sending large arguments PR 946 266ed61

Contributors to this release

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

AlexElin

Álvaro Hernández Tortosa

Barnabas Bodnar

Brett Okken

Brett Wooldridge

Chen Huajun

Dave Cramer

Hugh Cole-Baker

Jeff Klukas

Joe Kutner

Jorge Solorzano

Magnus

Magnus Hagander

MichaelZg

Michael Glaesemann

Pavel Raiskup

Philippe Marschall

Piyush Sharma

Sehrope Sarkuni

Thach Hoang

Vladimir Sitnikov

Zemian Deng

bpd0018

djydewang

eperez

mjanczykowski

rnveach

zapov

Changed

• Statements with non-zero fetchSize no longer require server-side named handle. This might cause issues when using old PostgreSQL versions (pre-8.4)+fetchSize+interleaved ResultSet processing combo. Issue 869

title: PostgreSQL JDBC Driver 42.1.4 Released date: 2017-08-01 20:00:00 +0300 version: 42.1.4

Changed

• Statements with non-zero fetchSize no longer require server-side named handle. This might cause issues when using old PostgreSQL versions (pre-8.4)+fetchSize+interleaved ResultSet processing combo. Issue 869

<!--more-->

Commits by author

AlexElin (4):

• test: migrate tests to JUnit 4 PR 738 5b65e2f4
• style: update checkstyle + turn on some rules PR 847 246b759c
• test: migrate tests to Junit4 PR 883 5c12da16
• refactor: remove useless checks in the tests 0221f930

Dave Cramer (2):

• honour PGPORT, PGHOST, PGDBNAME in connection properties PR 862 2951a958
• doc: fix spelling mistakes PR 868 757db625

Michael Glaesemann (4):

• test: assume minimum server version 8.3 testing autosave with ALTER 77ee528d
• test: assume minimum server version 8.3 when testing with uuid ff2717e4
• refactor: remove unused import 8afe856e
• test: assume integer datetimes for timestamp tests PR 873 8287e7f9

Vladimir Sitnikov (7):

• docs: prevent "<!--more-->" from being displayed on the changelog page e1747693
• doc: fix anchors for "contributors to this release" c1d743f2
• test: fix StringTypeParameterTest to skip preferQueryMode=simple beca1692
• chore: install PostgreSQL 9.1 to Trusty builds via apt, and use Precise for Java 6 e960f237
• test: make StringTypeParameterTest 8.3+ since 8.2 misses enum types PR 882 ed0014cc
• fix: named statements were used when fetchSize was non-zero and prepareThreshold=0 PR 870 f0deabf7
• test: skip ConcurrentStatementFetch for PostgreSQL < 8.4 PR 884 5334cb6e

Contributors to this release

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

AlexElin

Dave Cramer

Michael Glaesemann

Vladimir Sitnikov

Fixed

• Fix NPE in PreparedStatement.executeBatch in case of empty batch (regression since 42.1.2). PR 867

title: PostgreSQL JDBC Driver 42.1.3 Released date: 2017-07-14 10:49:13 +0300 version: 42.1.3

Fixed

• Fix NPE in PreparedStatement.executeBatch in case of empty batch (regression since 42.1.2). PR 867

<!--more-->

Commits by author

Vladimir Sitnikov (2):

• doc: ensure changelog uses %Y-%m-%d format, not %Y-%d-%m 5d585aac
• fix: NPE in PreparedStatement.executeBatch in case of empty batch PR 867 7514552d

Contributors to this release

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

Vladimir Sitnikov

Changed

• Better logic for returning keyword detection. Previously, pgjdbc could be defeated by column names that contain returning, so pgjdbc failed to "return generated keys" as it considered statement as already having returning keyword PR 824 201daf1d
• Use server-prepared statements for batch inserts when prepareThreshold>0. Note: this enables batch to use server-prepared from the first executeBatch() execution (previously it waited for prepareThreshold executeBatch() calls) abc3d9d7

Fixed

• Replication API: fix issue in #834 setting statusIntervalUpdate causes high CPU load. PR 835 59236b74

Regressions

• NPE in PreparedStatement.executeBatch in case of empty batch. Fixed in 42.1.3

title: PostgreSQL JDBC Driver 42.1.2 Released date: 2017-07-12 18:11:06 +0300 version: 42.1.2

Changed

• Better logic for returning keyword detection. Previously, pgjdbc could be defeated by column names that contain returning, so pgjdbc failed to "return generated keys" as it considered statement as already having returning keyword PR 824 201daf1d
• Use server-prepared statements for batch inserts when prepareThreshold>0. Note: this enables batch to use server-prepared from the first executeBatch() execution (previously it waited for prepareThreshold executeBatch() calls) abc3d9d7

Fixed

• Replication API: fix issue in #834 setting statusIntervalUpdate causes high CPU load. PR 835 59236b74

Regressions

• NPE in PreparedStatement.executeBatch in case of empty batch. Fixed in 42.1.3

<!--more-->

Commits by author

AlexElin (1):

• refactor: make PSQLState as enum PR 837 fb5df7fe

Dave Cramer (8):

• Initial support of partitioned tables via JDBC metadata API PR 823 9c3471f2
• fix javadoc complaints and some small edits to replication comments PR 832 2d0bfceb
• fix issue #834 setting statusIntervalUpdate causes high CPU load \ PR 835 59236b74
• fix issue #838 make sure we don't get columns that are dropped PR 840 464a2d43
• add missing connection documentation, fix spelling PR 846 cd400f6f
• more spelling mistakes for preferQueryMode PR 850 73bc3c1b
• fix formatting of section on failover, still not perfect but better PR 852 9f722014
• small reformat to clarify read and write connections PR 854 551d71b6

Jorge Solorzano (3):

• test: yet another rename to use "lsn" not "location" in Pg10. PR 822 90228621
• use zulu-9 PR 828 4ac74886
• fix: remove type name from cast exception of getBoolean and setObject PR 781 394b3a2f

Robert 'Bobby' Zenz (1):

• fix: Add fallback to setObject(int, Object) for Number PR 812 5b9edb7d

Vladimir Gordiychuk (1):

• bug: floating logical replcation test PR 829 2d3e8972

Vladimir Sitnikov (7):

• chore: implement a script to stage pgjdbc, pgdjbc-jre7, pgjdbc-jre6 artifacts 15d78839
• doc: fix 42.1.0.jre8->jre6 typo PR 42 88942b58
• fix: use server-prepared statements for batch inserts when prepareThreshold>0 abc3d9d7
• fix: better parsing for returning keyword PR 824 201daf1d
• docs: build index, changelog pages from _posts/... to reduce release overhead d6fe07d7
• chore: make ./release_notes.sh create docs/_posts/$DATE_YMD-$VERS-release.md file e00d4571
• docs: add 42.1.2 release notes 6f127a61

Contributors to this release

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

AlexElin

Dave Cramer

Jorge Solorzano

Robert 'Bobby' Zenz

Vladimir Gordiychuk

Vladimir Sitnikov

Fixed

• Fix infinite dates that might be corrupted when transferred in binary for certain JREs. For instance, 5881610-07-11 instead of infinity. 1e5bf563

title: "PostgreSQL JDBC Driver 42.1.1 Released" date: 2017-05-05 00:00:00 +0300 version: 42.1.1

Fixed

• Fix infinite dates that might be corrupted when transferred in binary for certain JREs. For instance, 5881610-07-11 instead of infinity. 1e5bf563

<!--more-->

Commits by author

Vladimir Sitnikov (2):

• fix: infinite dates might be corrupted when transferred in binary for certain JREs 1e5bf563
• chore: print "include notable changes" to the generated changelog 6bc4fe07

Contributors to this release

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

Vladimir Sitnikov

Added

• Support fetching a REF_CURSOR using getObject PR 809

Fixed

• Fix data being truncated in setCharacterStream (bug introduced in 42.0.0) PR 802
• Fix calculation of lastReceiveLSN for logical replication PR 801
• Make sure org.postgresql.Driver is loaded when accessing though DataSource interface Issue 768

Regressions

• There's no 42.1.0.jre6 version due to infinity handling bug. Fixed in 42.1.1.jre6

title: "PostgreSQL JDBC Driver 42.1.0 Released" date: 2017-05-04 00:00:00 +0300 version: 42.1.0

Added

• Support fetching a REF_CURSOR using getObject PR 809

Fixed

• Fix data being truncated in setCharacterStream (bug introduced in 42.0.0) PR 802
• Fix calculation of lastReceiveLSN for logical replication PR 801
• Make sure org.postgresql. Driver is loaded when accessing though DataSource interface Issue 768

Regressions

• There's no 42.1.0.jre6 version due to infinity handling bug. Fixed in 42.1.1.jre6

<!--more-->

Commits by author

Alexander Kjäll (1):

• documentation typo PR 818 90f5556f

Daniel Migowski (1):

• feat: improve waiting for notifications by providing a timeout option PR 778 a7e0c83b

Dave Cramer (4):

• Update index.html 4d8b1b38
• Review the documentation for the replication API PR 756 3e1eb34d
• fix callproc escape documentation the specification PR 785 95a3f41d
• Honour setLogStream. If the logStream is set PR 780 b97ad630

Jacques Fuentes (1):

• Make replication docs use PREFER_QUERY_MODE PR 761 bd0497de

James (1):

• fix: use SQLWarning(String reason) constructor for correct DriverManager PR 751 74a426b9

Joe Kutner (1):

• fix: Only resolve hostname if not using a SOCKS proxy PR 774 480b0cf1

Jorge Solorzano (3):

• fix: build site with jekyll 2.2.0 PR 755 773ee679
• test: check that new properties follow correct lower camel case PR 740 3f2a02e1
• refactor: simplify Encoding class PR 765 ef8c6f96

Philippe Marschall (1):

• feat: support fetching a REF_CURSOR using getObject PR 809 4ab5ccb7

Robert Zenz (1):

• fix: function calls without parameters do not require parentheses 2958cc22

Vladimir Gordiychuk (2):

• chore: fix false alarm on check coredump PR 806 3883a846
• bug: fix calculation of lastReceiveLSN for logical replication PR 801 170d9c27

Vladimir Sitnikov (3):

• fix: make sure org.postgresql. Driver is loaded when accessing though DataSource interface PR 768 9c80adc2
• refactor: add encoding, fix expected/actual, use proper constructor 77cace40
• fix: infinity handling for java.time types PR 789 f375701b

slmsbrhgn (1):

• bug: fix data being truncated in setCharacterStream (the bug introduced in 42.0.0) PR 802 28c98418

Contributors to this release

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

Alexander Kjäll

Daniel Migowski

Dave Cramer

Jacques Fuentes

James

Joe Kutner

Jorge Solorzano

Philippe Marschall

Robert Zenz

Vladimir Gordiychuk

Vladimir Sitnikov

slmsbrhgn

Added

• Replication protocol API was added: replication API documentation. PR 550
• java.util.logging is now used for logging: logging documentation. PR 722
• Add support for PreparedStatement.setCharacterStream(int, Reader). ee4c4265

Changed

• Version bumped to 42.0.0 to avoid version clash with PostgreSQL version and follow a better semantic versioning. 46634923
• Ensure executeBatch() can be used with pgbouncer. Previously pgjdbc could use server-prepared statements for batch execution even with prepareThreshold=0. Issue 742
• Error position is displayed when SQL has unterminated literals, comments, etc. Issue 688
• Strict handling of accepted values in getBoolean and setObject(BOOLEAN), now it follows PostgreSQL accepted values, only 1 and 0 for numeric types are accepted (previously !=0 was true). PR 732
• Return correct versions and name of the driver. PR 668

Removed

• Support for PostgreSQL versions below 8.2 was dropped. PR 661

Deprecated

• Deprecated PGPoolingDataSource, instead of this class you should use a fully featured connection pool like HikariCP, vibur-dbcp, commons-dbcp, c3p0, etc. PR 739

Regressions

• Data truncated in setCharacterStream. Fixed in 42.1.0
• No suitable driver found for jdbc:postgresql when using a DataSource implementation. Fixed in 42.1.0

title: "PostgreSQL JDBC Driver 42.0.0 Released" date: 2017-02-20 00:00:00 +0300 version: 42.0.0

Added

• Replication protocol API was added: replication API documentation. PR 550
• java.util.logging is now used for logging: logging documentation. PR 722
• Add support for PreparedStatement.setCharacterStream(int, Reader). ee4c4265

Changed

• Version bumped to 42.0.0 to avoid version clash with PostgreSQL version and follow a better semantic versioning. 46634923
• Ensure executeBatch() can be used with pgbouncer. Previously pgjdbc could use server-prepared statements for batch execution even with prepareThreshold=0. Issue 742
• Error position is displayed when SQL has unterminated literals, comments, etc. Issue 688
• Strict handling of accepted values in getBoolean and setObject(BOOLEAN), now it follows PostgreSQL accepted values, only 1 and 0 for numeric types are accepted (previously !=0 was true). PR 732
• Return correct versions and name of the driver. PR 668

Removed

• Support for PostgreSQL versions below 8.2 was dropped. PR 661

Deprecated

• Deprecated PGPoolingDataSource, instead of this class you should use a fully featured connection pool like HikariCP, vibur-dbcp, commons-dbcp, c3p0, etc. PR 739

Regressions

• Data truncated in setCharacterStream. Fixed in 42.1.0
• No suitable driver found for jdbc:postgresql when using a DataSource implementation. Fixed in 42.1.0

You may have noticed the change in the versioning of the driver, you can read the FAQ for more information.

<!--more-->

Commits by author

AlexElin (6):

• refactor: use varargs PR 681 50b7fe0f
• refactor: make HostChooser implement Iterable PR 645 3d37db78
• refactor: migrate to Junit4 PR 682 f4a067cc
• refactor: remove deprecated Utils' methods PR 678 0275d40f
• refactor: migrate tests to junit4 PR 685 faab4998
• refactor: remove checks for jdk version 1.4 (tests) PR 737 ee51dfce

Eric McCormack (1):

• fix: accept server version with more than 3 parts PR 741 8437f6c1

Jordan Lewis (1):

• feat: do not use pg_depend against PostgreSQL 9.0+ PR 689 62e25fba

Jorge Solorzano (22):

• refactor: remove support for postgresql < 8.2 PR 661 14e64be7
• fix: add query to support postgresql 8.2 without t.typarray PR 699 cb3995b5
• test: add CI tests against PostgreSQL 8.3 PR 710 436365b0
• fix: robust castToBoolean for setObject in PreparedStatement PR 714 edc2a14a
• refactor: remove unused V2ReplicationProtocol.java PR 718 7881e41e
• test: ignore tests that don't apply to Pg8.2 and Pg8.3 PR 703 3bc0951e
• style: reorder checkstyle in travis PR 721 ba812fb4
• refactor: remove charset property not used PR 709 f6fd5a5a
• fix: huntbugs on PgDatabaseMetaData, String concatenation in a loop PR 693 3a00ef94
• refactor: fix getDriverVersion, getDriverName and getJDBCMajor/MinorVersion methods PR 668 aa974341
• docs: reword supported versions, include datasources section, compare versions PR 673 b2cdd057
• test: fix test replication on PG_HEAD PR 734 3b406a18
• refactor: deprecated PGPoolingDataSource PR 739 55e2cd16
• fix: strict handling of getBoolean and setObject with postgres accepted values PR 732 4942f7d1
• docs: move docs from www/documentation/head PR 744 70e23c45
• test: fix replication test in Pg10 PR 746 63ed2129
• feat: use java.util.logging PR 722 43e6505e
• perf: short circuit Oid. BOOL in getBoolean PR 745 e69e4a1d
• fix: add isLoggable around parameterized logger PR 752 8b50cfe5
• docs: move www repository to pgjdbc/docs d4e99198
• add syntax highlight to documentation 8c035ade
• add more style 9c510e65

Pavel Raiskup (3):

• fix: sync with latest Fedora PR 637 a29ad80b
• packaging: rpm: update srpm generator 5c3c9239
• packaging: rpm_ci: use curl -L to download rawhide logs c8125cff

Philippe Marschall (3):

• refactor: clean up PgDatabaseMetaData PR 692 d32b077e
• refactor: delete Keyword enum PR 697 677e3c4c
• feat: support microsecond resolution for JSR-310 types PR 691 6b3a1efb

Roman Ivanov (2):

• config: move version of checkstyle to property PR 723 9ef7d6f1
• chore: upgrade checkstyle to 7.4, make checkstyle version configurable via property PR 725 e1a25782

Steve Ungerer (1):

• fix: ensure executeBatch() does not use server-side prepared statements when prepareThreshold=0 PR 690 aca26a07

Trygve Laugstøl (1):

• feat: connect the socket only if the socket factory created an unconnected socket PR 587 f75572be

Vladimir Gordiychuk (4):

• bug: fix not enscaped special symbol that fail build PR 686 b4604cd7
• feat: add replication protocol API PR 550 f48c6bb7
• test: fix drop replication slot on 9.4 for tests PR 696 c1c48bd7
• chore: Gather backtrace from core dump on CI PR 736 da5e4ef1

Vladimir Sitnikov (12):

• fedora: add BuildRequires: classloader-leak-test-framework 64b6750c
• tests: remove Class.forName(..driver..) from test code c99507b5
• test: add CI tests against PostgreSQL 8.2 PR 659 63ee60e2
• feat: display error position when SQL has unterminated literals, comments, etc PR 688 8a95d991
• feat: add support for PreparedStatement.setCharacterStream(int, Reader) PR 671 ee4c4265
• chore: update next version to 42.0.0-SNAPSHOT 46634923
• refactor: add CallableQueryKey#equals override 401c51a1
• doc: correct wording in readme regarding PostgreSQL versions used in pgjdbc regression testing 60391d75
• fix: revert ExpressionProperties to Properties in BaseDataSource 989b4d23
• fix: correct edge cases for setCharacterStream(int, Reader) f1190d8c
• test: add SharedTimerClassLoaderLeakTest to the regular test suite b3553276
• refactor: wrap more log statements with isLoggable check 07d225ec

bd-infor (1):

• docs: clarify handling of loglevel PR 711 6334bac0

Contributors to this release

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

AlexElin

bd-infor

Eric McCormack

Jordan Lewis

Jorge Solorzano

Pavel Raiskup

Philippe Marschall

Roman Ivanov

Steve Ungerer

Trygve Laugstøl

Vladimir Gordiychuk

Vladimir Sitnikov