Thread: [pgjdbc/pgjdbc] 33e74f: [maven-release-plugin] prepare releaseREL42.2.8

[pgjdbc/pgjdbc] 33e74f: [maven-release-plugin] prepare releaseREL42.2.8

From
Dave Cramer
Date:
  Branch: refs/heads/release/master
  Home:   https://github.com/pgjdbc/pgjdbc
  Commit: 33e74f5c2239ea79a9dffb13eb1a3eb8625b3d9a
      https://github.com/pgjdbc/pgjdbc/commit/33e74f5c2239ea79a9dffb13eb1a3eb8625b3d9a
  Author: pgjdbc CI <pgsql-jdbc@postgresql.org>
  Date:   2019-09-13 (Fri, 13 Sep 2019)

  Changed paths:
    M pgjdbc/pom.xml
    M pom.xml

  Log Message:
  -----------
  [maven-release-plugin] prepare release REL42.2.8


  Commit: 8a641a791c36326ee2f7c00798f37fd64306bebe
      https://github.com/pgjdbc/pgjdbc/commit/8a641a791c36326ee2f7c00798f37fd64306bebe
  Author: pgjdbc CI <pgsql-jdbc@postgresql.org>
  Date:   2019-09-13 (Fri, 13 Sep 2019)

  Changed paths:
    M pgjdbc/pom.xml
    M pom.xml

  Log Message:
  -----------
  [maven-release-plugin] prepare for next development iteration


  Commit: 91186c08968f15b11b7338f1a565124abedcbfae
      https://github.com/pgjdbc/pgjdbc/commit/91186c08968f15b11b7338f1a565124abedcbfae
  Author: Pavel Raiskup <praiskup@redhat.com>
  Date:   2019-09-20 (Fri, 20 Sep 2019)

  Changed paths:
    M packaging/rpm/postgresql-jdbc.spec.tpl

  Log Message:
  -----------
  rpm: drop BR on properties-maven-plugin

That one is not in Fedora 32+ anymore, and build seems to work fine
without this.


  Commit: 831115c1e8ede27d6a0434022b11edab7082721a
      https://github.com/pgjdbc/pgjdbc/commit/831115c1e8ede27d6a0434022b11edab7082721a
  Author: rnveach <rveach02@gmail.com>
  Date:   2019-09-23 (Mon, 23 Sep 2019)

  Changed paths:
    M pgjdbc/pom.xml

  Log Message:
  -----------
  upgrade maven-checkstyle-plugin to 3.1.0 (#1573)


  Commit: bd9485ef7b889ec7397b1e39f77f5d396f06ed05
      https://github.com/pgjdbc/pgjdbc/commit/bd9485ef7b889ec7397b1e39f77f5d396f06ed05
  Author: Tom Eicher <tom@tomeicher.de>
  Date:   2019-09-26 (Thu, 26 Sep 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/ds/common/BaseDataSource.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc2/optional/BaseDataSourceFailoverUrlsTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/optional/OptionalTestSuite.java

  Log Message:
  -----------
  fix: DataSources broken by connection failover urls (#1039) (#1457)

* fix DataSources broken by connection failover urls (#1039)

* removing java8 string join method and fixing indentation (#1039)

* preserve original test "bds" as we are modifying ours (#1039)

* storing old bds reference before changing it (#1039)

* moving the url-modifiying test out of BaseDataSourceTest (#1039)


  Commit: 0888e9355ca065ac2eae4e3085442ffd54f6dec6
      https://github.com/pgjdbc/pgjdbc/commit/0888e9355ca065ac2eae4e3085442ffd54f6dec6
  Author: Jorge Solorzano <jorsol@gmail.com>
  Date:   2019-10-01 (Tue, 01 Oct 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/core/ResultHandler.java
    M pgjdbc/src/main/java/org/postgresql/core/ResultHandlerBase.java
    M pgjdbc/src/main/java/org/postgresql/core/ResultHandlerDelegate.java
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/BatchResultHandler.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgPreparedStatement.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgStatement.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/ResultWrapper.java
    M pgjdbc/src/test/java/org/postgresql/test/TestUtil.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc42/Jdbc42TestSuite.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc42/LargeCountJdbc42Test.java

  Log Message:
  -----------
  feat: support for large update counts (JDBC 4.2) (#935)

Added support for large update counts of the JDBC 4.2 API (Java 8+)

This implementation supports:
PreparedStatement.executeLargeUpdate()
Statement.executeLargeUpdate(String sql)
Statement.getLargeUpdateCount()
Statement.executeLargeBatch()
Statement.executeLargeUpdate(String sql, int autoGeneratedKeys) *
Statement.executeLargeUpdate(String sql, int[] columnIndexes) *
Statement.executeLargeUpdate(String sql, String[] columnNames) *


  Commit: 69edc0b8f0985465af0ba0ee258f6b2564240232
      https://github.com/pgjdbc/pgjdbc/commit/69edc0b8f0985465af0ba0ee258f6b2564240232
  Author: Knut Wannheden <knut.wannheden@gmail.com>
  Date:   2019-10-02 (Wed, 02 Oct 2019)

  Changed paths:
    M docs/documentation/92/query.md
    M docs/documentation/93/query.md
    M docs/documentation/94/query.md
    M docs/documentation/head/query.md

  Log Message:
  -----------
  Fix Markdown formatting issue (#1576)

Fixes a Markdown formatting issue in the `query.md` section on
restrictions with cursor-based `ResultSet`s.


  Commit: 635cc86562aebc223dcc0d163639c5039a6b54c0
      https://github.com/pgjdbc/pgjdbc/commit/635cc86562aebc223dcc0d163639c5039a6b54c0
  Author: Árpád Magosányi <m4gw4s@gmail.com>
  Date:   2019-10-23 (Wed, 23 Oct 2019)

  Changed paths:
    M docs/documentation/head/connect.md

  Log Message:
  -----------
  fix documentation on generating the pk8 key. closes: #1585 (#1586)

* fix documentation on generating the pk8 key. closes: #1585

* more help on key types and such


  Commit: 0fd45353e504ed7821af69c8053814918212b8d7
      https://github.com/pgjdbc/pgjdbc/commit/0fd45353e504ed7821af69c8053814918212b8d7
  Author: Torsten Brodbeck <56440929+tbrodbeck-adc@users.noreply.github.com>
  Date:   2019-10-24 (Thu, 24 Oct 2019)

  Changed paths:
    M README.md
    M docs/documentation/head/connect.md

  Log Message:
  -----------
  fix camel case writing of 'cleanupSavepoints' (#1587)

* Camel case writing of 'cleanupSavepoints' fixed.


  Commit: ad734574726eb0decf5178071c87a1b513e484f2
      https://github.com/pgjdbc/pgjdbc/commit/ad734574726eb0decf5178071c87a1b513e484f2
  Author: Sehrope Sarkuni <sehrope@jackdb.com>
  Date:   2019-10-24 (Thu, 24 Oct 2019)

  Changed paths:
    M pgjdbc/src/test/java/org/postgresql/test/TestUtil.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/CopyTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/optional/ConnectionPoolTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc4/IsValidTest.java

  Log Message:
  -----------
  Clean up some tests and fix IsValidTest race condition (#1581)

* test: Add some helpers to TestUtil

Adds some helpers to TestUtil to deal with boiler plate of executinga query
and disgarding the results, fetching the backend process id, terminating a
backend process, and fetching the current transaction state.

* test: Clean up IsValidTest

Cleans up IsValidTest and removes a race condition when checking whether
terminated connections are marked as invalid. Also splits out the transaction
state test into three separate ones to better identify what's being tested.

* test: Change CopyTest to use TestUtil backend pid helpers

This also changes the connection termination to use a non-privileged
connection.

* test: Change ConnectionPoolTest to use backend pid TestUtil helpers

This also changes the pg_terminate_backend(...) call to use a non-privileged connection
as a regular user can terminate their own connection.

* fix: Use super user to terminate backend processes in tests

Older versions of the server (<=9.1) restrict calling pg_terminate_backend(...)
to super users so always use that in test helper.


  Commit: 7c591262792b8ff8f6139f67a98c16d41f2adf4f
      https://github.com/pgjdbc/pgjdbc/commit/7c591262792b8ff8f6139f67a98c16d41f2adf4f
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-10-28 (Mon, 28 Oct 2019)

  Changed paths:
    A pgjdbc/src/test/java/org/postgresql/test/ssl/LazyKeyManagerTest.java
    M pgjdbc/src/test/java/org/postgresql/test/ssl/SslTestSuite.java

  Log Message:
  -----------
  Add simple test to make sure we can load a key (#1588)

* Add simple test to make sure we can load a key


  Commit: 003ea8352dab2b49b4734cdf7338befb4d9b9ed4
      https://github.com/pgjdbc/pgjdbc/commit/003ea8352dab2b49b4734cdf7338befb4d9b9ed4
  Author: Sehrope Sarkuni <sehrope@jackdb.com>
  Date:   2019-10-29 (Tue, 29 Oct 2019)

  Changed paths:
    M .github/pull_request_template.md
    M pgjdbc/src/test/java/org/postgresql/test/extensions/ExtensionsTestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/hostchooser/MultiHostTestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/optional/OptionalTestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc42/Jdbc42TestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/jre8/core/Jre8TestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/osgi/OsgiTestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/ssl/SslTestSuite.java
    M pgjdbc/src/test/java/org/postgresql/test/xa/XATestSuite.java

  Log Message:
  -----------
  Fix test suite order (#1593)

* test: Standardize on array of tests in @SuiteClasses

* test: Fix sort order for test suites

* docs: Add note about sorting tests to GitHub PR template


  Commit: 504bb316b91fdbc6506a2e9870453fb75fbbb083
      https://github.com/pgjdbc/pgjdbc/commit/504bb316b91fdbc6506a2e9870453fb75fbbb083
  Author: Yuriy Yudin <jurixmath@mail.ru>
  Date:   2019-10-30 (Wed, 30 Oct 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java

  Log Message:
  -----------
  fix: add release save point into execute with batch (#1583)

release auto save points in batch processing in order to avoid out of
shared memory error

fix for the issue https://github.com/pgjdbc/pgjdbc/issues/1582


  Commit: e39a0be0739d016f524e7aef567f95e6ea59fd54
      https://github.com/pgjdbc/pgjdbc/commit/e39a0be0739d016f524e7aef567f95e6ea59fd54
  Author: Michail Nikolaev <michail.nikolaev@gmail.com>
  Date:   2019-10-30 (Wed, 30 Oct 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/core/v3/ConnectionFactoryImpl.java

  Log Message:
  -----------
  fix: do ssl handshake after socket timeout and buffer size settings (#1584)


  Commit: 5e48eaa4c9f6fc07904944bd98ad45fbb4aefd10
      https://github.com/pgjdbc/pgjdbc/commit/5e48eaa4c9f6fc07904944bd98ad45fbb4aefd10
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-04 (Mon, 04 Nov 2019)

  Changed paths:
    M docs/documentation/head/prepare.md

  Log Message:
  -----------
  Update prepare.md (#1601)


  Commit: c67b0b0b667a6b9f1b13ed5359687f3bc20ac61b
      https://github.com/pgjdbc/pgjdbc/commit/c67b0b0b667a6b9f1b13ed5359687f3bc20ac61b
  Author: Árpád Magosányi <mag@magwas.rulez.org>
  Date:   2019-11-12 (Tue, 12 Nov 2019)

  Changed paths:
    M docs/documentation/head/connect.md

  Log Message:
  -----------
  security notice and clarifications on choosing the right cipher suite for client key (#1591)


  Commit: 9b8a3ffd8a952a55be28d14cb80a23fdbb955133
      https://github.com/pgjdbc/pgjdbc/commit/9b8a3ffd8a952a55be28d14cb80a23fdbb955133
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-12 (Tue, 12 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgDatabaseMetaData.java
    M pgjdbc/src/main/java/org/postgresql/util/ByteConverter.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc4/DatabaseMetaDataTest.java

  Log Message:
  -----------
  fix: issue 716 getTypeInfo() may not return data in the order specified in Oracle documentation (#1506)

this replaces PR #910 as it was stale and easier to replace than fix. Original work by @zemian


  Commit: 539a09258f6009581785474fe5f15a46992ade6f
      https://github.com/pgjdbc/pgjdbc/commit/539a09258f6009581785474fe5f15a46992ade6f
  Author: Igor Volkov <1859437+virtual-machinist@users.noreply.github.com>
  Date:   2019-11-12 (Tue, 12 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/copy/PGCopyOutputStream.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/CopyTest.java

  Log Message:
  -----------
  Fix exception on PGCopyOutputStream.close() after endCopy() (#1574) (#1575)

* Fix: check if active before close() (#1574)

* Fix: NPEs on flush() and isActive() if copy has ended

* Tests for close(), flush(), isActive()


  Commit: c99ed1213410872915930bea4471df6b1bdc503e
      https://github.com/pgjdbc/pgjdbc/commit/c99ed1213410872915930bea4471df6b1bdc503e
  Author: Sehrope Sarkuni <sehrope@jackdb.com>
  Date:   2019-11-13 (Wed, 13 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java

  Log Message:
  -----------
  fix: Update error message for COPY commands executed using JDBC API (#1300)


  Commit: cd0b555c8045fc71e6f4d0fb0f24a2deb726301e
      https://github.com/pgjdbc/pgjdbc/commit/cd0b555c8045fc71e6f4d0fb0f24a2deb726301e
  Author: Sehrope Sarkuni <sehrope@jackdb.com>
  Date:   2019-11-14 (Thu, 14 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/PGProperty.java
    M pgjdbc/src/main/java/org/postgresql/core/QueryExecutorBase.java
    M pgjdbc/src/main/java/org/postgresql/core/v3/ConnectionFactoryImpl.java
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java
    M pgjdbc/src/main/java/org/postgresql/ds/common/BaseDataSource.java
    M pgjdbc/src/main/java/org/postgresql/gss/GssAction.java
    M pgjdbc/src/main/java/org/postgresql/gss/MakeGSS.java
    M pgjdbc/src/main/java/org/postgresql/util/PSQLException.java
    M pgjdbc/src/main/java/org/postgresql/util/ServerErrorMessage.java
    A pgjdbc/src/test/java/org/postgresql/test/core/LogServerMessagePropertyTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/Jdbc2TestSuite.java

  Log Message:
  -----------
  Add connection property to limit server error detail in exception exceptions (#1579)

* feat: Add connection property to limit server error detail in exception messages

Adds a boolean connection property, LOG_SERVER_MESSAGE_DETAIL ("logServerMessage") that
controls whether the full error detail, as reported back by the server, is included in
the exception messages. This property can be used to limit potentially sensitive content
in server messages from bubbling up in exception messages and stack traces.

If set to "false" then only the top level error will be included in the exception message.
If set to "true" then all details in the server error will be included.

Default value for the new property is "true" to reflect the prior behavior of logging the
full error detail.

Closes #1577

* fix: Add getter and setter for LOG_SERVER_ERROR_DETAIL to BaseDataSource

* test: Add test for logServerErrorDetail connection property


  Commit: e64b0a2df8dd5e94a24fbb2e2e197f6d7fed7d9a
      https://github.com/pgjdbc/pgjdbc/commit/e64b0a2df8dd5e94a24fbb2e2e197f6d7fed7d9a
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-14 (Thu, 14 Nov 2019)

  Changed paths:
    M docs/documentation/head/connect.md

  Log Message:
  -----------
  chore: Document how to use unix domain sockets.  (#1607)

* chore: Document how to use unix domain sockets. Thanks @aleksabl

* fix formatting


  Commit: 1e370263d2f59da04fd1f8fe55bb83afdc0a51dc
      https://github.com/pgjdbc/pgjdbc/commit/1e370263d2f59da04fd1f8fe55bb83afdc0a51dc
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-15 (Fri, 15 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgSQLXML.java
    A pgjdbc/src/test/java/org/postgresql/jdbc/PgSQLXMLTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/Jdbc2TestSuite.java

  Log Message:
  -----------
  fix: PgSQLXML setCharacterStream() results in null value  (#1608)

* fix: PgSQLXML setCharacterStream() results in null value fixes Issue #731


  Commit: 47f756fa926f7c78a7f55f030aadf7be82195e52
      https://github.com/pgjdbc/pgjdbc/commit/47f756fa926f7c78a7f55f030aadf7be82195e52
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-15 (Fri, 15 Nov 2019)

  Changed paths:
    M pgjdbc/src/test/java/org/postgresql/core/ParserTest.java

  Log Message:
  -----------
  add test for table name with values in it (#1609)


  Commit: 8abf3161d17fef3783c0c597e91c1fe455efc2e8
      https://github.com/pgjdbc/pgjdbc/commit/8abf3161d17fef3783c0c597e91c1fe455efc2e8
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-18 (Mon, 18 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgDatabaseMetaData.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java

  Log Message:
  -----------
  fix: get correct column length for simple domains (#1605)

* fix: get correct column length for simple domains


  Commit: 00fa448587532cc219977679bb8c573a1dcae11c
      https://github.com/pgjdbc/pgjdbc/commit/00fa448587532cc219977679bb8c573a1dcae11c
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-18 (Mon, 18 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgStatement.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc4/jdbc41/CloseOnCompletionTest.java

  Log Message:
  -----------
  fix: NPE as a result of calling executeQuery twice on a statement fixes issue #684 (#1610)


  Commit: 7f1752a1f2853c88333b3ac75c2dc0212272b254
      https://github.com/pgjdbc/pgjdbc/commit/7f1752a1f2853c88333b3ac75c2dc0212272b254
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-22 (Fri, 22 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgDatabaseMetaData.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java

  Log Message:
  -----------
  fix:handle numeric domain types (#1611)

* fix:handle numeric domain types


  Commit: 69320c7a7dc065f44db5ddeec8143c606298b382
      https://github.com/pgjdbc/pgjdbc/commit/69320c7a7dc065f44db5ddeec8143c606298b382
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-25 (Mon, 25 Nov 2019)

  Changed paths:
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/DateTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc4/jdbc41/GetObjectTest.java

  Log Message:
  -----------
  add checks for null results (#1616)


  Commit: 050797934a8a9c0ce2dff068eba14931988370ca
      https://github.com/pgjdbc/pgjdbc/commit/050797934a8a9c0ce2dff068eba14931988370ca
  Author: Brett Okken <brett.okken.os@gmail.com>
  Date:   2019-11-25 (Mon, 25 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/PGProperty.java
    M pgjdbc/src/main/java/org/postgresql/core/BaseConnection.java
    M pgjdbc/src/main/java/org/postgresql/core/QueryExecutor.java
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java
    M pgjdbc/src/main/java/org/postgresql/ds/common/BaseDataSource.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgConnection.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgStatement.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/ConnectionTest.java

  Log Message:
  -----------
  feat: read only transactions (#1252)

* feat: read only transactions

If autocommit is set to false, read only will be set on begin
transaction.
If autocommit is true, it will continue to be managed at session level.
The queries to change session have been cached to avoid re-parsing each
time readonly value changes.

https://github.com/pgjdbc/pgjdbc/issues/1228
https://github.com/pgjdbc/pgjdbc/issues/848

* feat: read only transactions

* checkstyle and hamcrest test import

* add connection property with 3 options to control read only behavior

* fix missing property methods on BaseDataSource 
* avoid redundant static modifier

* more loosely couple read only hints to backend

* return default read only mode from data source.

* avoid case conversion


  Commit: 7b454355939aebd995b1b79598a1e945c168eb68
      https://github.com/pgjdbc/pgjdbc/commit/7b454355939aebd995b1b79598a1e945c168eb68
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-25 (Mon, 25 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/util/PGInterval.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/IntervalTest.java

  Log Message:
  -----------
  fix: pginterval to take iso8601 strings (#1612)

* fix: pginterval to take iso8601 strings

* use integers for seconds and microseconds all tests passed


  Commit: d75591385538cd704a066c4ed026f767ce3784ab
      https://github.com/pgjdbc/pgjdbc/commit/d75591385538cd704a066c4ed026f767ce3784ab
  Author: GregN <gregn@fast.au.fujitsu.com>
  Date:   2019-11-26 (Tue, 26 Nov 2019)

  Changed paths:
    M README.md
    M docs/documentation/head/connect.md
    M pgjdbc/src/main/java/org/postgresql/PGProperty.java
    M pgjdbc/src/main/java/org/postgresql/core/CachedQueryCreateAction.java
    M pgjdbc/src/main/java/org/postgresql/core/JdbcCallParseInfo.java
    M pgjdbc/src/main/java/org/postgresql/core/Parser.java
    M pgjdbc/src/main/java/org/postgresql/core/QueryExecutor.java
    M pgjdbc/src/main/java/org/postgresql/core/QueryExecutorBase.java
    M pgjdbc/src/main/java/org/postgresql/ds/common/BaseDataSource.java
    A pgjdbc/src/main/java/org/postgresql/jdbc/EscapeSyntaxCallMode.java
    M pgjdbc/src/test/java/org/postgresql/core/ParserTest.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc3/EscapeSyntaxCallModeBaseTest.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc3/EscapeSyntaxCallModeCallIfNoReturnTest.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc3/EscapeSyntaxCallModeCallTest.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc3/EscapeSyntaxCallModeSelectTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc3/Jdbc3TestSuite.java

  Log Message:
  -----------
  feat: add new "escapeSyntaxCallMode" connection property (#1560)

The "escapeSyntaxCallMode" connection property allows you to specify how the driver transforms
JDBC escape call syntax into underlying SQL, for invoking procedures and functions.
The possible values of this property are: select, callIfNoReturn, or call
In escapeSyntaxCallMode=select mode (the default), the driver always uses a SELECT statement
(allowing function invocation only).
In escapeSyntaxCallMode=callIfNoReturn mode, the driver uses a CALL statement (allowing
procedure invocation) if there is no return parameter specified, otherwise the driver uses a
SELECT statement.
In escapeSyntaxCallMode=call mode, the driver always uses a CALL statement (allowing procedure
invocation only).
Prior to the addition of this connection property, the driver always used a SELECT statement for
JDBC escape call syntax, which results in the following error when attempting to invoke a
procedure:
    ERROR: xxxx is a procedure  Hint: To call a procedure, use CALL


  Commit: ed74670fae932935a156eccfb4b1ff16758f5693
      https://github.com/pgjdbc/pgjdbc/commit/ed74670fae932935a156eccfb4b1ff16758f5693
  Author: GregN <gregn@fast.au.fujitsu.com>
  Date:   2019-11-26 (Tue, 26 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/core/Parser.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc3/Jdbc3CallableStatementTest.java

  Log Message:
  -----------
  fix: allow OUT parameter registration when using CallableStatement native CALL (#1561)

Currently, using CallableStatement, the PGJDBC driver will allow invocation of procedures using
the native "call myproc(...)" syntax, provided the procedure only has IN parameters or no
parameters.
However, if the procedure has any INOUT parameters, then an attempt to invoke the
CallableStatement's registerOutParameter() method, which is required in order to register the OUT
part of the INOUT parameter, will fail with the following error:
   This statement does not declare an OUT parameter.  Use { ?= call ... } to declare one.

This fixes issue: https://github.com/pgjdbc/pgjdbc/issues/1545


  Commit: 9a193de71d3e834a231f8f5027fb887e00e903d2
      https://github.com/pgjdbc/pgjdbc/commit/9a193de71d3e834a231f8f5027fb887e00e903d2
  Author: Dongming <ldming101@gmail.com>
  Date:   2019-11-26 (Tue, 26 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/Driver.java

  Log Message:
  -----------
  Adjust the default port to 5432. (#1619)


  Commit: ff4a66d29d863cb4a6d2aecee2faec424f8d51d7
      https://github.com/pgjdbc/pgjdbc/commit/ff4a66d29d863cb4a6d2aecee2faec424f8d51d7
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-26 (Tue, 26 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/Driver.java
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java
    M pgjdbc/src/main/java/org/postgresql/hostchooser/GlobalHostStatusTracker.java

  Log Message:
  -----------
  fix: remove currentTimeMillis from code, tests are OK (#1617)


  Commit: 6899a43dff735ab14a02bedea853266de768da50
      https://github.com/pgjdbc/pgjdbc/commit/6899a43dff735ab14a02bedea853266de768da50
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-26 (Tue, 26 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgPreparedStatement.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/PreparedStatementTest.java

  Log Message:
  -----------
  fix: NPE when calling setNull on a PreparedStatement with no parameters (#1620)


  Commit: fdf898c781c00839210936d668d2341ca6c08406
      https://github.com/pgjdbc/pgjdbc/commit/fdf898c781c00839210936d668d2341ca6c08406
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-26 (Tue, 26 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/replication/PGReplicationStream.java

  Log Message:
  -----------
  doc: correct documentation about last applied message fixes #760 (#1621)


  Commit: f0af538f59924fd9d692627102c94517e5f6008e
      https://github.com/pgjdbc/pgjdbc/commit/f0af538f59924fd9d692627102c94517e5f6008e
  Author: Sehrope Sarkuni <sehrope@jackdb.com>
  Date:   2019-11-27 (Wed, 27 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/PGConnection.java

  Log Message:
  -----------
  feat: Add cancelQuery() to PGConnection public interface (#1157)

Adds cancelQuery() to the extended public interface PGConnection to allow
for issueing of cancels directly to connections rather than having to keep
track of individual statements. The internals of the driver and the backend
server already operate at a connection level (not a statement level) and
this patch only exposes the existing cancelQuery() method publicly.


  Commit: 4edca517bfdc0bffb2141369394d611803b43523
      https://github.com/pgjdbc/pgjdbc/commit/4edca517bfdc0bffb2141369394d611803b43523
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-27 (Wed, 27 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java

  Log Message:
  -----------
  docs: fix documentation about oids (#1624)


  Commit: 4258e0d0cfdc50aaec3d31301fd793e221740bda
      https://github.com/pgjdbc/pgjdbc/commit/4258e0d0cfdc50aaec3d31301fd793e221740bda
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-28 (Thu, 28 Nov 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/PGConnection.java

  Log Message:
  -----------
  fix: javadoc requires throws annotation (#1625)


  Commit: 82c2008f83dd687e80b1e3acdeeb618dccc2fb5c
      https://github.com/pgjdbc/pgjdbc/commit/82c2008f83dd687e80b1e3acdeeb618dccc2fb5c
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-29 (Fri, 29 Nov 2019)

  Changed paths:
    M certdir/README.md
    A certdir/goodclient.p12
    M docs/documentation/head/connect.md
    M docs/documentation/head/ssl-client.md
    M docs/documentation/head/ssl.md
    M pgjdbc/src/main/java/org/postgresql/ssl/LibPQFactory.java
    A pgjdbc/src/main/java/org/postgresql/ssl/PKCS12KeyManager.java
    M pgjdbc/src/test/java/org/postgresql/test/ssl/LazyKeyManagerTest.java
    A pgjdbc/src/test/java/org/postgresql/test/ssl/PKCS12KeyTest.java

  Log Message:
  -----------
  fix: Add pkcs12 key functionality (#1599)

* fix: Add pkcs12 key functionality
WIP
PBE-MD5-DES might be inadequate in environments where high level of security is needed and the key is not protected
pkcs12 uses 3DES which also isn't completely adequate but is certainly more secure than MD5-DES

* fix docs to add PKCS12 archive format


  Commit: 97d32caad1f72c11d3e89ffaf16a17a22c6b9790
      https://github.com/pgjdbc/pgjdbc/commit/97d32caad1f72c11d3e89ffaf16a17a22c6b9790
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-11-29 (Fri, 29 Nov 2019)

  Changed paths:
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/AutoRollbackTestSuite.java

  Log Message:
  -----------
  Actually test cleanSavePoints (#1509)


  Commit: 8106d3df5c3f6ea3cbc3e621977df5542b182b56
      https://github.com/pgjdbc/pgjdbc/commit/8106d3df5c3f6ea3cbc3e621977df5542b182b56
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-12-05 (Thu, 05 Dec 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgDatabaseMetaData.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc4/DatabaseMetaDataTest.java

  Log Message:
  -----------
  fix: DatabaseMetaData.getFunctions should not limit the search to the search_path if the schema is provided (#1633)

* fix: DatabaseMetaData.getFunctions should not limit the search to the search_path if the schema is provided


  Commit: ec76bace1d4e3c02a7bf235f726a6c6d7feb6ee3
      https://github.com/pgjdbc/pgjdbc/commit/ec76bace1d4e3c02a7bf235f726a6c6d7feb6ee3
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-12-05 (Thu, 05 Dec 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/PGProperty.java
    M pgjdbc/src/main/java/org/postgresql/ds/common/BaseDataSource.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgConnection.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgDatabaseMetaData.java
    A pgjdbc/src/test/java/org/postgresql/test/jdbc4/DatabaseMetaDataHideUnprivilegedObjectsTest.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc4/Jdbc4TestSuite.java

  Log Message:
  -----------
  feat: WIP Filter DatabaseMetaData using privileges for the user (#1630)

* feat:Filter DatabaseMetaData using privileges for the user
This replaces PR#647 as it required considerable work to merge.
Original work done by Scott Langley @slangley
adds a connection parameter: hideUnprivilegedObjects defaults to false


  Commit: 08bd46bfccc9c9481650e4ee09c943ec78d77895
      https://github.com/pgjdbc/pgjdbc/commit/08bd46bfccc9c9481650e4ee09c943ec78d77895
  Author: IvyDev0 <yiyid@andrew.cmu.edu>
  Date:   2019-12-05 (Thu, 05 Dec 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSetMetaData.java
    A pgjdbc/src/test/java/org/postgresql/jdbc/NoColumnMetadataIssue1613.java

  Log Message:
  -----------
  fix: null pointer exception from PgResultSetMetaData when there's no column metadata (#1615)

* fix all possible NPE in PgResultSetMetaData when there's column metadata


  Commit: c85b149d68c30ede0559d4bff6bc616ec03b2517
      https://github.com/pgjdbc/pgjdbc/commit/c85b149d68c30ede0559d4bff6bc616ec03b2517
  Author: Mahmoud Bahaa <mahmoud.bahaa.eg@gmail.com>
  Date:   2019-12-06 (Fri, 06 Dec 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgArray.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgConnection.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java
    M pgjdbc/src/main/java/org/postgresql/util/ByteConverter.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/PreparedStatementTest.java

  Log Message:
  -----------
  Add Binary Support for Oid.NUMERIC and Oid.NUMERIC_ARRAY (#1636)

* Add Binary Support for Oid.NUMERIC and Oid.NUMERIC_ARRAY

* Adding test cases for binary support for Oid.NUMERIC

* Fix Oid.NUMERIC_ARRAY binary format

* Fix java docs for numeric functions in ByteConverter

* remove Short.BYTES as it doesn't exist in jre6 and jre7


  Commit: ad83cb332058f0a891b89f47ceefb538cbf031db
      https://github.com/pgjdbc/pgjdbc/commit/ad83cb332058f0a891b89f47ceefb538cbf031db
  Author: Mahmoud Bahaa <mahmoud.bahaa.eg@gmail.com>
  Date:   2019-12-06 (Fri, 06 Dec 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgConnection.java

  Log Message:
  -----------
  Only allow binary transfer for those Oids that the pgjdbc currently supports (#1637)


  Commit: b37115373935732b1ab5e59b56837ac49942718a
      https://github.com/pgjdbc/pgjdbc/commit/b37115373935732b1ab5e59b56837ac49942718a
  Author: Craig Ringer <craig@2ndquadrant.com>
  Date:   2019-12-06 (Fri, 06 Dec 2019)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java

  Log Message:
  -----------
  Prevent use of extended query protocol for BEGIN before COPY (#1639)

When autocommit is off and the first query in a transaction is a COPY, we were
sending a BEGIN using the extended query protocol. It was being permitted to
use named portals as well, ignoring prepareThreshold.

Fix by forcing simple query mode and marking the BEGIN as oneshot.

Fixes #1638


  Commit: fa69e7e951d6f7dc48a605ac1c44393645512aa3
      https://github.com/pgjdbc/pgjdbc/commit/fa69e7e951d6f7dc48a605ac1c44393645512aa3
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-12-06 (Fri, 06 Dec 2019)

  Changed paths:
    M CHANGELOG.md
    A docs/_posts/2019-12-06-42.2.9-release.md

  Log Message:
  -----------
  new pr for release notes (#1640)

* release notes


  Commit: 03fdf75d7b3be54aa6b47c37c1c7fbdf57bda4ab
      https://github.com/pgjdbc/pgjdbc/commit/03fdf75d7b3be54aa6b47c37c1c7fbdf57bda4ab
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2019-12-06 (Fri, 06 Dec 2019)

  Changed paths:
    M docs/_posts/2019-12-06-42.2.9-release.md

  Log Message:
  -----------
  Update


Compare: https://github.com/pgjdbc/pgjdbc/compare/291ccf339961...03fdf75d7b3b