org.postgresql:pgjdbc-osgi-test

Changed

• fix: added GROUP_STARTUP_PARAMETERS boolean property to determine whether or not to group startup parameters in a transaction (default=false like 42.2.x) fixes Issue #2425 pgbouncer cannot deal with transactions in statement pooling mode PR #2425

Fixed

• fix: queries with up to 65535 (inclusive) parameters are supported now (previous limit was 32767) PR #2525, Issue #1311
• fix: workaround JarIndex parsing issue by using groupId/artifactId-version directory namings. Regression since 42.2.13. PR #2531, issue #2527
• fix: use Locale.ROOT for toUpperCase() toLowerCase() calls
• doc: add Vladimir Sitnikov's PGP key
• fix: return correct base type for domain from getUDTs PR #2520 Issue #2522
• perf: utcTz static and renamed to UTC_TIMEZONE PR #2519
• doc: fix release version for #2377 (it should be 42.3.6, not 42.3.5)

title: PostgreSQL JDBC Driver 42.4.0 Released date: 2022-06-09 08:14:50 -0400 version: 42.4.0

Changed

• fix: added GROUP_STARTUP_PARAMETERS boolean property to determine whether or not to group startup parameters in a transaction (default=false like 42.2.x) fixes Issue #2425 pgbouncer cannot deal with transactions in statement pooling mode PR #2425

Fixed

• fix: queries with up to 65535 (inclusive) parameters are supported now (previous limit was 32767) PR #2525, Issue #1311
• fix: workaround JarIndex parsing issue by using groupId/artifactId-version directory namings. Regression since 42.2.13. PR #2531, issue #2527
• fix: use Locale. ROOT for toUpperCase() toLowerCase() calls
• doc: add Vladimir Sitnikov's PGP key
• fix: return correct base type for domain from getUDTs PR #2520 Issue #2522
• perf: utcTz static and renamed to UTC_TIMEZONE PR #2519
• doc: fix release version for #2377 (it should be 42.3.6, not 42.3.5)

<!--more-->

Commits by author

Andrei Lurie (1):

  fix: return correct base type for domain from getUDTs [PR 2520](https://github.com/pgjdbc/pgjdbc/pull/2520) (#2522)

Dave Cramer (3):

  fix: added GROUP_STARTUP_PARAMETERS boolean property to determine whether or not to group startup parameters in a transaction or not fixes Issue 2423 pgbouncer cannot deal with transactions in statement pooling mode [PR 2425](https://github.com/pgjdbc/pgjdbc/pull/2425)

Jorge Solórzano (1):

  chore: Make the readme version agnostic [PR 2540](https://github.com/pgjdbc/pgjdbc/pull/2540)

Sven Diedrichsen (1):

  Made utcTz static and renamed to UTC_TIMEZONE [PR 2519](https://github.com/pgjdbc/pgjdbc/pull/2519)

Vladimir Sitnikov (24):

  doc: fix release version for [PR 2377](https://github.com/pgjdbc/pgjdbc/pull/2377) (it should be 42.3.6, not 42.3.5)

title: PostgreSQL JDBC Driver 42.3.10 Released date: 2024-03-13 15:42:00 -0400 categories: - new_release version: 42.3.10

Notable changes

Fixed

• Fix: Due to building the release using Java 17 version 42.3.9, would throw an exception NoSuchMethodError on ByteBuffer#position When Running on Java 8
• Fix: In SimpleQuery mode SimpleParameterList did not support type casting for all well known types.

title: PostgreSQL JDBC Driver 42.3.9 Released date: 2024-02-21 8:23:00 -0500 categories: - new_release version: 42.3.9

Notable changes

Security

• security: SQL Injection via line comment generation, it is possible in SimpleQuery mode to generate a line comment by having a placeholder for a numeric with a - such as -?. There must be second placeholder for a string immediately after. Setting the parameter to a -ve value creates a line comment. This has been fixed in this version fixes CVE-2024-1597. Reported by Paul Gerste. See the security advisory for more details. This has been fixed in versions 42.7.2, 42.6.1 42.5.5, 42.4.4, 42.3.9, 42.2.28.jre7. See the security advisory for work arounds.

Changed

Added

Fixed

• fix: close refcursors when underlying cursor==null instead of relying on defaultRowFetchSize PR #2377

title: PostgreSQL JDBC Driver 42.3.6 Released date: 2022-05-24 08:52:25 -0400 version: 42.3.6

Changed

Added

Fixed

• fix: close refcursors when underlying cursor==null instead of relying on defaultRowFetchSize PR #2377

<!--more-->

Commits by author

Dave Cramer (2):

  Fix heading format for version numbers [PR 2504](https://github.com/pgjdbc/pgjdbc/pull/2504)

Vladimir Sitnikov (1):

  fix: close refcursors when underlying cursor==null instead of relying on defaultRowFetchSize [PR #2377](https://github.com/pgjdbc/pgjdbc/pull/2377)

Changed

• test: polish TimestampUtilsTest
• chore: use GitHub Action concurrency feature to terminate CI jobs on fast PR pushes

Added

• Added KEYS file to allow for verifying artifacts PR 2499

Fixed

• perf: enable tcpNoDelay by default PR 2495. This is a regression from 42.2.x versions where tcpNoDelay defaulted to true
• docs: fix readme.md after PR 2495 PR 2496
• feat: targetServerType=preferPrimary connection parameter PR 2483
• fix: revert removal of toOffsetDateTime(String timestamp) fixes Issue #2497 PR 2501

title: PostgreSQL JDBC Driver 42.3.5 Released date: 2022-05-04 08:48:32 -0400 version: 42.3.5

Known issues

• Regression since 42.3.2: "cursor <unnamed portal 1> does not exist" when using ResultSet.setFetchSize from CallableStatement, fixed in 42.3.6 (see PG #2377)

Changed

• test: polish TimestampUtilsTest
• chore: use GitHub Action concurrency feature to terminate CI jobs on fast PR pushes

Added

• Added KEYS file to allow for verifying artifacts PR 2499

Fixed

• perf: enable tcpNoDelay by default PR 2495. This is a regression from 42.2.x versions where tcpNoDelay defaulted to true
• docs: fix readme.md after PR 2495 PR 2496
• feat: targetServerType=preferPrimary connection parameter PR 2483
• fix: revert removal of toOffsetDateTime(String timestamp) fixes Issue #2497 PR 2501

<!--more-->

Commits by author

Dave Cramer (4):

  move version to 42.3.5 [PR 2493](https://github.com/pgjdbc/pgjdbc/pull/2493)
  Added KEYS file to allow for verifying artifacts [PR 2499](https://github.com/pgjdbc/pgjdbc/pull/2499)
  fix: revert removal of toOffsetDateTime(String timestamp)  fixes #Issue 2497 [PR 2501](https://github.com/pgjdbc/pgjdbc/pull/2501)

Dmitriy Mukhin (1):

  feat: targetServerType=preferPrimary connection parameter [PR 2483](https://github.com/pgjdbc/pgjdbc/pull/2483)

Olivier Bourgain (2):

  perf: enable tcpNoDelay by default [PR 2495](https://github.com/pgjdbc/pgjdbc/pull/2495)
  docs: fix readme.md after [PR 2495](https://github.com/pgjdbc/pgjdbc/pull/2495) (#2496)

Vladimir Sitnikov (1):

  test: polish TimestampUtilsTest
  chore: use GitHub Action concurrency feature to terminate CI jobs on fast PR pushes

Changed

• fix: change name of build cache PR 2471
• feat: add support for ResultSet#getObject(OffsetTime.class) and PreparedStatement#setObject(OffsetTime.class) PR 2467
• fix: Use non-synchronized getTimeZone in TimestampUtils PR 2451
• docs: Fix CHANGELOG.md misformatted markdown headings PR 2461
• docs: remove loggerLevel and loggerFile from docs and issues PR 2489
• feat: use direct wire format -> LocalDate conversion without resorting to java.util.Date, java.util.Calendar, and default timezones PR 2464 fixes Issue #2221

Added

Fixed

• docs: Update testing documentation PR 2446
• fix: Throw an exception if the driver cannot parse the URL instead of returning NULL fixes Issue #2421 PR 2441
• fix: Use PGProperty instead of the property names directly PR 2444
• docs: update changelog, missing links at bottom and formatting PR 2460
• fix: Remove isDeprecated from PGProperty. It was originally intended to help produce automated docs. Fixes Issue #2479 PR 2480
• fix: change PGInterval parseISO8601Format to support fractional second PR 2457
• fix: GSS login to use TGT from keytab fixes Issue #2469 PR 2470
• fix: More test and fix for issues discovered by PR #2476 PR #2488

title: PostgreSQL JDBC Driver 42.3.4 Released date: 2022-04-15 11:00:00 -0400 version: 42.3.4

Known issues

• Regression since 42.3.2: "cursor <unnamed portal 1> does not exist" when using ResultSet.setFetchSize from CallableStatement, fixed in 42.3.6 (see PG #2377)

Changed

• fix: change name of build cache PR 2471
• feat: add support for ResultSet#getObject(OffsetTime.class) and PreparedStatement#setObject(OffsetTime.class) PR 2467
• fix: Use non-synchronized getTimeZone in TimestampUtils PR 2451
• docs: Fix CHANGELOG.md misformatted markdown headings PR 2461
• docs: remove loggerLevel and loggerFile from docs and issues #2489
• feat: use direct wire format -> LocalDate conversion without resorting to java.util. Date, java.util. Calendar, and default timezones PR 2464 fixes Issue #2221

Added

Fixed

• docs: Update testing documentation PR 2446
• fix: Throw an exception if the driver cannot parse the URL instead of returning NULL fixes Issue #2421 PR 2441
• fix: Use PGProperty instead of the property names directly PR 2444
• docs: update changelog, missing links at bottom and formatting PR 2460
• fix: Remove isDeprecated from PGProperty. It was originally intended to help produce automated docs. Fixes #Issue 2479 PR 2480
• fix: change PGInterval parseISO8601Format to support fractional second PR 2457
• fix: More test and fix for issues discovered by PR #2476 PR #2488

<!--more-->

Commits by author

Dave Cramer (8):

• docs: Update testing documentation PR 2446
• fix: Throw an exception if the driver cannot parse the URL instead of returning NULL fixes Issue PR 2421 (#2441)
• fix: Use PGProperty instead of the property names directly PR 2444
• docs: update changelog, missing links at bottom and formatting PR 2460
• added post for 42.2.25 PR 2466
• change name of build cache PR 2471
• Remove isDeprecated from PGProperty. It was originally intended to help produce automated docs. Fixes #Issue 2479 PR 2480

Fabio Cechinel Veronez (1):

• docs: Fix CHANGELOG.md misformatted markdown headings PR 2461

Uwe Schindler (2):

• feat: add support for ResultSet#getObject(OffsetTime.class) and PreparedStatement#setObject(OffsetTime.class) PR 2467

Wei Su (1):

• GSS login to use TGT from keytab fixes Issue 2469 PR 2470

paulo-kluh (1):

• fix: change PGInterval parseISO8601Format to support fractional second PR 2457

吴伟杰 (1):

• Use non-synchronized getTimeZone in TimestampUtils PR 2451

Contributors to this release

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

Uwe Schindler

Wei Su

Fabio Cechinel Veronez

paulo-kluh

吴伟杰

Changed

• fix: Removed loggerFile and loggerLevel configuration. While the properties still exist. They can no longer be used to configure the driver logging. Instead use java.util.logging configuration mechanisms such as logging.properties.

Added

Fixed

title: PostgreSQL JDBC Driver 42.3.3 Released date: 2022-02-15 11:32:22 -0500 version: 42.3.3

Known issues

• Regression since 42.3.2: "cursor <unnamed portal 1> does not exist" when using ResultSet.setFetchSize from CallableStatement, fixed in 42.3.6 (see PG #2377)

Changed

• fix: Removed loggerFile and loggerLevel configuration. While the properties still exist. They can no longer be used to configure the driver logging. Instead use java.util.logging configuration mechanisms such as logging.properties .

Added

Fixed

<!--more-->

Commits by author

Dave Cramer (5):

• add: security policy link to index PR 2440
• Update: SECURITY.md PR 2445
• fix: javadocs PR 2454

Contributors to this release

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

Sehrope Sarkuni

Security

• CVE-2022-21724 pgjdbc instantiates plugin instances based on class names provided via authenticationPluginClassName, sslhostnameverifier, socketFactory, sslfactory, sslpasswordcallback connection properties. However, the driver did not verify if the class implements the expected interface before instantiating the class. This would allow a malicious class to be instantiated that could execute arbitrary code from the JVM. Fixed in commit

Changed

• perf: read in_hot_standby GUC on connection PR #2334
• test: materialized view privileges PR #2209 fixes Issue #2060
• docs: add info about convenience maven project PR #2407
• docs: Document timezone reversal from POSIX to ISO PR #2413
• fix: we will ask the server if it supports GSS Encryption if gssEncryption is prefer or require PR #2396 remove the need to have a ticket in the cache before asking the server if gss encryptions are supported
• docs: remove Java 6 and 7 references from contributing PR #2385
• style: remove Java 8 / JDBC 4.2 checks PR #2383 Remove all remaining checks whether the source is lower than Java 8 or JDBC 4.2.
• fix: throw SQLException for #getBoolean BIT(>1) PR #2386 Throw SQLException instead of ClassCastException when calling CallableStatement#getBoolean(int) on BIT(>1).
• style: import java.time types in more classes PR #2382 Use imports for java.time types in all remaining classes.
• style: import java.time types in TimestampUtils PR #2380 Use imports for java.time types in TimestampUtils.
• refactor: Change internal constructors to pass only connection Properties Changes internal constructors for PgConnection and related classes to only accept the connection properties object and remove the user and password arguments. Any locations that required those fields can retrieve them from the properties map.
• test: Fix DatabaseMetadataTest to perform mview tests only on 9.3+
• perf: read in_hot_standby GUC on connection PR #2334
• doc: improv doc around binary decoding of numeric data #2331
• Add cert key type checking to chooseClientAlias PR #2417

Added

• feat: Add authenticationPluginClassName option to provide passwords at runtime Adds authenticationPluginClassName connection property that allows end users to specify a class that will provide the connection passwords at runtime. Users implementing that interface must ensure that each invocation of the method provides a new char[] array as the contents will be filled with zeroes by the driver after use.Call sites within the driver have been updated to use the char[] directly wherever possible. This includes direct usage in the GSS authentication code paths that internally were already converting the String password into a char[] for internal usage. This allows configuring a connection with a password that must be generated on the fly or periodically changes. PR #2369 original issue Issue #2102
• feat: add tcpNoDelay option PR #2341 fixes Issue #2324
• feat: pg_service.conf and .pgpass support (jdbc:postgresql://?service=my-service) PR #2260 fixes Issue #2278

Fixed

• Use local TimestampUtil in PgStatement and PgResultset for thread safety PR #2291 fixes Issue #921 synchronize modification of shared calendar
• fix: PgObject isNull() was reporting the opposite fixes Issue #2411 PR #2414
• fix: default file name is ".pg_service.conf" on Windows (not "pg_service.conf") PR #2398 fixes Issue #2278
• test: Fix RefCursorFetchTest on older platforms
• fix: do not close refcursor after reading if fetchsize has been set fixes Issue #2227 PR #2371
• fix: rework gss authentication to use the principal name to get the credentials fixes Issue #2235 PR #2352
• fix: return getIndexInfo metadata columns in UPPER CASE PR #2368
• fix: Connection leak in ConnectionFactoryImpl#tryConnect PR #2350 Issue #2351
• fix: Fix For IS_AUTOGENERATED Flag PR #2348
• fix: parsing service file tests for windows PR #2347
• fix: The spec says that calling close() on a closed connection is a noop. PR #2345 fixes Issue #2300
• fix: add microsecond precision to getTimestamp() called on sql TIME(6) Currently, "when fetching a value of type TIME(6) through resultSet.getTimestamp() only ms precision is retained, the microsecond fractional digits are lost." This change will retain the microsecond precision when .getTimestamp() is called on TIME(6). PR #2181 Closes Issue #1537
• test: materialized view privileges PR #2209 add and drop a materialized view Add to TestUtil and also to DatabaseMetaData setup and teardown fixes Issue #2060
• fix: typo in connect.md PR #2338 OutOfMemoryException => OutOfMemoryError
• fix: use local TimestampUtil in PgStatement and PgResultset for thread safety TimestampUtil is not thread safe. It raises exceptions when multiple threads use ResultSets of one connection. PR #2291 fixes Issue #921 If PgStatement and PgResultSet use their own TimestampUtil no synchronize is needed.
• fix: typo in CONTRIBUTING.md PR #2332 seccion => section

title: PostgreSQL JDBC Driver 42.3.2 Released date: 2022-02-01 07:35:28 -0500 version: 42.3.2

Known issues

• Regression since 42.3.2: "cursor <unnamed portal 1> does not exist" when using ResultSet.setFetchSize from CallableStatement, fixed in 42.3.6 (see PG #2377)

Security

• CVE-2022-21724 pgjdbc instantiates plugin instances based on class names provided via authenticationPluginClassName, sslhostnameverifier, socketFactory, sslfactory, sslpasswordcallback connection properties. However, the driver did not verify if the class implements the expected interface before instantiating the class. This would allow a malicious class to be instantiated that could execute arbitrary code from the JVM. Fixed in commit

Changed

• perf: read in_hot_standby GUC on connection PR #2334
• test: materialized view privileges PR #2209 fixes Issue #2060
• docs: add info about convenience maven project PR #2407
• docs: Document timezone reversal from POSIX to ISO PR #2413
• fix: we will ask the server if it supports GSS Encryption if gssEncryption is prefer or require PR #2396 remove the need to have a ticket in the cache before asking the server if gss encryptions are supported
• docs: remove Java 6 and 7 references from contributing PR #2385
• style: remove Java 8 / JDBC 4.2 checks PR #2383 Remove all remaining checks whether the source is lower than Java 8 or JDBC 4.2.
• fix: throw SQLException for #getBoolean BIT(>1) PR #2386 Throw SQLException instead of ClassCastException when calling CallableStatement#getBoolean(int) on BIT(>1).
• style: import java.time types in more classes PR #2382 Use imports for java.time types in all remaining classes.
• style: import java.time types in TimestampUtils PR #2380 Use imports for java.time types in TimestampUtils.
• refactor: Change internal constructors to pass only connection Properties Changes internal constructors for PgConnection and related classes to only accept the connection properties object and remove the user and password arguments. Any locations that required those fields can retrieve them from the properties map.
• test: Fix DatabaseMetadataTest to perform mview tests only on 9.3+
• perf: read in_hot_standby GUC on connection PR #2334
• doc: improv doc around binary decoding of numeric data #2331
• Add cert key type checking to chooseClientAlias PR #2417

Added

• feat: Add authenticationPluginClassName option to provide passwords at runtime Adds authenticationPluginClassName connection property that allows end users to specify a class that will provide the connection passwords at runtime. Users implementing that interface must ensure that each invocation of the method provides a new char[] array as the contents will be filled with zeroes by the driver after use. Call sites within the driver have been updated to use the char[] directly wherever possible. This includes direct usage in the GSS authentication code paths that internally were already converting the String password into a char[] for internal usage. This allows configuring a connection with a password that must be generated on the fly or periodically changes. PR #2369 original issue Issue #2102
• feat: add tcpNoDelay option PR #2341 fixes Issue #2324
• feat: pg_service.conf and .pgpass support (jdbc:postgresql://?service=my-service) PR #2260 fixes Issue #2278

Fixed

• Use local TimestampUtil in PgStatement and PgResultset for thread safety PR #2291 fixes Issue #921 synchronize modification of shared calendar
• fix: PgObject isNull() was reporting the opposite fixes Issue #2411 PR #2414
• fix: default file name is ".pg_service.conf" on Windows (not "pg_service.conf") PR #2398 fixes Issue #2278
• test: Fix RefCursorFetchTest on older platforms
• fix: do not close refcursor after reading if fetchsize has been set fixes Issue #2227 PR #2371
• fix: rework gss authentication to use the principal name to get the credentials fixes Issue #2235 PR #2352
• fix: return getIndexInfo metadata columns in UPPER CASE PR #2368
• fix: Connection leak in ConnectionFactoryImpl#tryConnect PR #2350 Issue #2351
• fix: Fix For IS_AUTOGENERATED Flag PR #2348
• fix: parsing service file tests for windows PR #2347
• fix: The spec says that calling close() on a closed connection is a noop. PR #2345 fixes Issue #2300
• fix: add microsecond precision to getTimestamp() called on sql TIME(6) Currently, "when fetching a value of type TIME(6) through resultSet.getTimestamp() only ms precision is retained, the microsecond fractional digits are lost." This change will retain the microsecond precision when .getTimestamp() is called on TIME(6). PR #2181 Closes Issue #1537
• test: materialized view privileges PR #2209 add and drop a materialized view Add to TestUtil and also to DatabaseMetaData setup and teardown fixes Issue #2060
• fix: typo in connect.md PR #2338 OutOfMemoryException => OutOfMemoryError
• fix: use local TimestampUtil in PgStatement and PgResultset for thread safety TimestampUtil is not thread safe. It raises exceptions when multiple threads use ResultSets of one connection. PR #2291 fixes Issue #921 If PgStatement and PgResultSet use their own TimestampUtil no synchronize is needed.
• fix: typo in CONTRIBUTING.md PR #2332 seccion => section

<!--more-->

Commits by author

Andrei Paikin (1):

• minor: fix checkstyle violations for empty lines in enum PR 2426

Brett Okken (1):

• doc: improv doc around binary decoding of numeric data PR 2331

Dave Cramer (21):

• move comment to appropriate place and add explanation PR 2336
• bump version in readme and gradle.properties PR 2335
• add entries for latest changes PR 2339
• Ms goodman time gettimestamp micros PR 2181
• add TCP No Delay option fixes Issue PR 2324 (#2341)
• fix Issue PR 2300. The spec says that calling close() on a closed connection is a noop. (#2345)
• fix: parsing service file tests for windows PR 2347
• fix: return getIndexInfo metadata columns in UPPER CASE PR 2368
• fix: rework gss authentication to use the principal name to get the credentials fixes Issue PR 2235 (#2352)
• Removed unsafe package and native kerberos ticket check PR 2363
• log4jmessage PR 2370
• Put back GSSCallbackHandler. Avoid using forbidden api PR 2373
• fix: do not close refcursor after reading if fetchsize has been set fixes ISSUE PR 2227 (#2371)
• perf: add read(b, o, l) to BlobInputStream PR 2376
• change the default directory returned on windows to APPDATA/postgresql since that is what we end up using anyway PR 2402
• fix: we will ask the server if it supports GSS Encryption if gssEncryption is prefer or require PR 2396
• docs: Document timezone reversal from POSIX to ISO PR 2413
• fix: PgObject isNull() was reporting the opposite fixes Issue PR 2411 (#2414)
• remove skipjre6 and skipjre7 PR 2415
• Revert "perf: add read(b, o, l) to BlobInputStream PR 2376" (#2422)
• Changelog42.3.2 PR 2418

JoelRabinovitch (1):

• fixForIsAutoGenerated Fix For IS_AUTOGENERATED Flag PR 2348

Marek Läll (2):

• Issue 2278 ; jdbc:postgresql://?service= ; pg_service.conf ; .pgpass PR 2282
• fix: default file name is ".pg_service.conf" on Windows (not "pg_service.conf") PR 2398

Mark Grobaker (1):

• test: materialized view privileges PR 2209

Michał Wyrzykowski (1):

• fix: Connection leak in ConnectionFactoryImpl#tryConnect PR 2350 (#2351)

Nick Burgan (1):

• Add cert key type checking to chooseClientAlias PR 2417

Philippe Marschall (6):

• style: fix typos in pgobject javadoc PR 2379
• style: import java.time types in TimestampUtils PR 2380
• style: import java.time types in more classes PR 2382
• fix: throw SQLException for #getBoolean BIT(>1) PR 2386
• style: remove Java 8 / JDBC 4.2 checks PR 2383
• docs: remove Java 6 and 7 references from contributing PR 2385

Sehrope Sarkuni (9):

• feat: Change AuthenticationPlugin interface to use char[] rather than String PR 2420
• test: Disable no-arg callable statement tests in simple query mode PR 2419
• test: Remove extra catch-fail in RefCursorFetchTest PR 2391
• test: Fix RefCursorFetchTest on older platforms PR 2391
• feat: Add authenticationPluginClassName option to provide passwords at runtime PR 2369
• test: Add TestUtil.assumeHaveMinimumServerVersion(...) helper PR 2369
• refactor: Change internal constructors to pass only connection Properties PR 2369
• refactor: Use multi-catch for exceptions in ConnectionFactoryImpl PR 2369
• test: Fix DatabaseMetadataTest to perform mview tests only on 9.3+ PR 2340

Sergey Nuyanzin (4):

• [typo] typo in CONTRIBUTING.md PR 2332
• [typo] in connect.md PR 2338
• Misprint in messages_ru.java PR 2358

Sergey Prytkov (1):

• perf: read in_hot_standby GUC on connection PR 2334

Zuzana Miklankova (1):

• docs: add info about convenience maven project PR 2407

marcmuel (1):

• fix: use local TimestampUtil in PgStatement and PgResultset for thread safety PR 2291

Contributors to this release

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

Pavel Raiskup

Sehrope Sarkuni

Andrei Paikin

Nick Burgan

Zuzana Miklankova

Marek Läll

Philippe Marschall

Sergey Nuyanzin

Michał Wyrzykowski

JoelRabinovitch

Mark Grobaker

Sergey Prytkov

marcmuel

Brett Okken

Changed

• improv: Arrays in Object[] PR 2330 when an Object[] contains other arrays, treat as though it were a multi-dimensional array the one exception is byte[], which is not supported.
• improv: Use jre utf-8 decoding PR 2317 Remove use of custom utf-8 decoding.
• perf: improve performance of bytea string decoding PR 2320 improve the parsing of bytea hex encoded string by making a lookup table for each of the valid ascii code points to the 4 bit numeric value
• feat: intern/canonicalize common strings PR 2234

Added

Fixed

• numeric binary decode for even 10 thousands PR #2327 fixes Issue 2326 binary numeric values which represented integers multiples of 10,000 from 10,000-9,990,000 were not decoded correctly
• [typo] typo in certdir/README.md PR #2309 certificatess => certificates
• [typo] typo in TimestampUtils.java PR #2314 Change Greagorian to Gregorian.
• remove check for negative pid in cancel request. Apparently pgbouncer can send one fixes Issue 2317 PR #2319

title: PostgreSQL JDBC Driver 42.3.1 Released date: 2021-10-29 15:09:25 +0000 version: 42.3.1

Changed

• improv: Arrays in Object[] PR 2330 when an Object[] contains other arrays, treat as though it were a multi-dimensional array the one exception is byte[], which is not supported.
• improv: Use jre utf-8 decoding PR 2317 Remove use of custom utf-8 decoding.
• perf: improve performance of bytea string decoding PR 2320 improve the parsing of bytea hex encoded string by making a lookup table for each of the valid ascii code points to the 4 bit numeric value
• feat: intern/canonicalize common strings PR 2234

Added

Fixed

• numeric binary decode for even 10 thousands PR #2327 fixes Issue 2326 binary numeric values which represented integers multiples of 10, 000 from 10, 000-9, 990, 000 were not decoded correctly
• [typo] typo in certdir/README.md PR #2309 certificatess => certificates
• [typo] typo in TimestampUtils.java PR #2314 Change Greagorian to Gregorian.
• remove check for negative pid in cancel request. Apparently pgbouncer can send one fixes Issue 2317 PR #2319

<!--more-->

Commits by author

Brett Okken (6):

• improv: Arrays in Object[] PR 2230 538c79f5
• improv: Use jre utf-8 decoding PR 2317 a5786037
• perf: improve performance of bytea string decoding PR 2320 f2a24d37
• feat: intern/canonicalize common strings PR 2234 a024cd51
• fix: numeric binary decode for even 10 thousands PR 2327 b3050e60
• fix: remove unused OptimizedUTF8Encoder PR 2329 515ea066

Dave Cramer (5):

• Update debezium.yml 84f1057d
• update release date to Oct 18 PR 2308 5fc1976d
• remove check for negative pid in cancel request. Apparently pgbouncer can send one fixes Issue PR 2318 (#2319) c9be5c0f
• move version to 42.3.0 PR 2322 1b8629b2
• Remove references to JAVA 6 and 7 PR 2312 67113020

Sergey Nuyanzin (1):

• [typo] typo in certdir/README.md PR 2309 e5e36bd3

吴伟杰 (1):

• Fix typo in TimestampUtils.java PR 2314 4293a790

Contributors to this release

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

Brett Okken

Dave Cramer

Sergey Nuyanzin

吴伟杰

Changed

• No longer build for Java 6 or Java 7
• If assumeMinServerVersion is not defined and server is at least 9.0, group startup statements into a single transaction PR #1977

Added

• Support for pg_service.conf file and jdbc URL syntax: "jdbc:postgresql://?service=service1". Resource can be provided using 1) property "-Dorg.postgresql.pgservicefile=file1" 2) environment variable PGSERVICEFILE=file2 3) default location "$HOME/.pg_service.conf" 4) environment variable PGSYSCONFDIR=dir1 looks for file "dir1/pg_service.conf".
• Support for .pgpass file. Resource can be provided using 1) property "-Dorg.postgresql.pgpassfile=file1" 2) environment variable PGPASSFILE=file2 3) default location "$HOME/.pgpass"

Fixed

• Rework OSGi bundle activator so it does not rely on exception message to check DataSourceFactory presence PR #507
• Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified PR #2174
• Fix refreshRow made the row readOnly. [PR #2195](https://github.com/pgjdbc/pgjdbc/pull/2195 Fixes Issue #2193
• Fix do not add double quotes to identifiers already double quoted PR #2224 Fixes Issue #2223 Add a property QUOTE_RETURNING_IDENTIFIERS which determines if we put double quotes around identifiers that are provided in the returning array.
• Fix Provide useful error message for empty or missing passwords for SCRAM auth PR #2290 fixes Issue #2288

title: PostgreSQL JDBC Driver 42.3.0 Released date: 2021-10-18 15:05:25 +0000 version: 42.3.0

Changed

• No longer build for Java 6 or Java 7
• If assumeMinServerVersion is not defined and server is at least 9.0, group startup statements into a single transaction PR #1977

Added

Fixed

• Rework OSGi bundle activator so it does not rely on exception message to check DataSourceFactory presence PR #507
• Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified PR #2174
• Fix refreshRow made the row readOnly. PR #2195 Fixes Issue #2193
• Fix do not add double quotes to identifiers already double quoted PR #2224 Fixes Issue #2223 Add a property QUOTE_RETURNING_IDENTIFIERS which determines if we put double quotes around identifiers that are provided in the returning array.
• Fix Provide useful error message for empty or missing passwords for SCRAM auth PR #2290 fixes Issue #2288

Contributors to this release

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

Abhishek-kumar09

adrklos

Agata Naomichi

Andrew Dunstan

Brett Okken

costa100

Dave Cramer

David Rader

Eric Peterson

Feng zhihao

Frode Carlsen

Hugo Abreu

iceback

Jeremy Mailen

Jesper Pedersen

Jorge Solorzano

Jorge Solórzano

Juha Syrjälä

JY Cr

Laurenz Albe

Michael Ernst

MMeent

odubaj

Pavel Bludov

Peter Eisentraut

plan3d

Power

rtrier

Sehrope Sarkuni

Simon Strassl

Tom Aizenberg

Vladimir Sitnikov

Vyom Yadav

xpoinsard