org.postgresql:postgresql

---

title: PostgreSQL JDBC Driver 42.5.3 Released date: 2023-02-03 08:24:49 -0500 categories: - new_release version: 42.5.3

Fixed

• fix: Add box to TypeInfoCache, fixes Issue #2746 PR #2747\
• fix: regression in PgResultSet LONG_MIN copy and paste error fixes Issue #2748 PR#2749

<!--more-->

Commits by author

Dave Cramer (2):

• Fix: regression in PgResultSet LONG_MIN copy and paste error fixes Issue (#2749) PR 2748\
• Add box to TypeInfoCache, fixes Issue (#2747) PR 2746

---

title: PostgreSQL JDBC Driver 42.5.2 Released date: 2023-01-31 14:30:44 -0500 categories:

• new_release version: 42.5.2

---

Changed

• regression: This release has 2 known regressions which make it unusable see the notes in 42.5.3. We advise people not to use 42.5.2.
• docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes #Issue 2671 PR #2686\
• docs: clarify binaryTransfer and add it to README PR# 2698\
• docs: Document the need to encode reserved characters in the connection URL PR #2700\
• feat: Define binary transfer for custom types dynamically/automatically fixes Issue #2554 PR #2556

Added

• fix: added gssResponseTimeout as part of PR #2687 to make sure we don't wait forever on a GSS RESPONSE

Fixed

• fix: Ensure case of XML tags in Maven snippet is correct PR #2682\
• fix: Make sure socket is closed if an exception is thrown in createSocket fixes Issue #2684 PR #2685\
• fix: Apply patch from Issue #2683 to fix hanging ssl connections PR #2687\
• fix: binary conversion of (very) long numeric values (longer than 4 * 2^15 digits) PR #2697 fixes Issue #2695\
• minor: enhance readability connection of startup params PR #2705\
• fix: improve thread safety of PgResultSet#getTimestamp PR #2726 fixes Issue #2723

<!--more-->

Commits by author

Dave Cramer (2):

• fix: binary conversion of (very) long numeric values (longer than 4 * 2^15 digits) PR #2697\
• fix: Apply patch from Issue #2683 provided by James Courtney to fix hanging ssl connections PR #2687\
• fix: Make sure socket is closed if an exception is thrown in createSocket fixes Issue #2684 PR #2685

Sebastian Baumhekel(1): sebastian.baumhekel@gmail.com

• feat: Define binary transfer for custom types dynamically/automatically fixes Issue #2554 PR #2556

sz-liva(1):

• fix: improve thread safety of PgResultSet#getTimestamp PR #2726 fixes Issue #2723

---

title: PostgreSQL JDBC Driver 42.5.1 Released date: 2022-11-23 10:14:47 -0500 categories: - new_release version: 42.5.1

Security

• security: StreamWrapper spills to disk if setText, or setBytea sends very large Strings or arrays to the server. createTempFile creates a file which can be read by other users on unix like systems (Not macos).
  This has been fixed in this version fixes CVE-2022-41946 see the security advisory for more details.
  Reported by Jonathan Leitschuh
  This has been fixed in versions 42.5.1, 42.4.3 42.3.8, 42.2.27.jre7.
  Note there is no fix for 42.2.26.jre6. See the security advisory for work arounds.

Fixed

• fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes #Issue 2548 PR #2552
• fix: binary decoding of bool values PR #2640
• perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns PR #2634
• chore: fix various spelling errors PR #2592
• chore: Feature/urlparser improve URLParser PR #2641

<!--more-->

Commits by author

Dave Cramer (13):

• Update README.md PR 2609
• Ignore simplequery for postgresql 8.4 PR 2614
• Single commit to move newdocs into master PR 2618
• update versions PR 2619
• fix grammar, fix downloads, minor edits PR 2626
• fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes #Issue 2548 PR 2552
• clarify prepared statement usage PR 2629
• fix maven coordinates PR 2631
• remove javadoc links for java 17 and above PR 2637
• revert change to PGProperty.get() to keep the API the same PR 2644
• exclude ArrayTest versions less than 9.1 PR 2645

Evgeniy Devyatykh (1):

• perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns PR 2634

Josh Soref (1):

• chore: fix various spelling errors PR 2592

Kevin222004 (1):

Knut Olav Løite (1):

• fix: binary decoding of bool values PR 2640

Marek Läll (1):

• Feature/urlparser improve3 pr1 PR 2641

Vladimir Sitnikov (4):

• docs: clarify we ship security fixes by default for the latest 42.x and 42.2 only PR 2586

μtkarsh (1):

• Optimize png files PR 2621

---

title: PostgreSQL JDBC Driver 42.5.0 Released date: 2022-08-24 08:30:09 -0400 version: 42.5.0

Changed

• fix: revert change in PR #1986 where float was aliased to float4 from float8. float now aliases to float8 PR #2598 fixes Issue #2597

<!--more-->

Commits by author

Dave Cramer (5):

• fix: revert change in PR 2597 where float was aliased to float4 from float8. float now aliases to float8 (#2598)

---

title: PostgreSQL JDBC Driver 42.4.2 Released date: 2022-08-17 10:33:37 -0400 version: 42.4.2

Changed

• fix: add alias to the generated getUDT() query for clarity PR #2553

Added

• fix: make setObject accept UUID array PR #2587

Fixed

• fix: regression with GSS. Changes introduced to support building with Java 17 caused failures Issue #2588
• fix: set a timeout to get the return from requesting SSL upgrade. PR #2572
• feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads)

<!--more-->

Commits by author

Dave Cramer (7):

  Revert revert commits made in PR 2580 [PR 2583](https://github.com/pgjdbc/pgjdbc/pull/2583)
  fix mismatched types for invokeExact. Have to tell invokeExact what type we are expecting [PR 2589](https://github.com/pgjdbc/pgjdbc/pull/2589)
  update last copyright year [PR 2593](https://github.com/pgjdbc/pgjdbc/pull/2593)
  fix erroneous method signature and null subjectCallAs [PR 2595](https://github.com/pgjdbc/pgjdbc/pull/2595)

Sasa Vilic (1):

  fix: make setObject accept UUID array [PR 2587](https://github.com/pgjdbc/pgjdbc/pull/2587)

Andrei Lurie (1):

  fix: add alias to the generated getUDT() query for clarity (PR #2553)[https://github.com/pgjdbc/pgjdbc/pull/2553]

---

title: PostgreSQL JDBC Driver 42.4.1 Released date: 2022-08-03 08:09:07 -0400 version: 42.4.1

Security

• fix: CVE-2022-31197 Fixes SQL generated in PgResultSet.refresh() to escape column identifiers so as to prevent SQL injection.
  • Previously, the column names for both key and data columns in the table were copied as-is into the generated SQL. This allowed a malicious table with column names that include statement terminator to be parsed and executed as multiple separate commands.
  • Also adds a new test class ResultSetRefreshTest to verify this change.
  • Reported by Sho Kato

Changed

• chore: skip publishing pgjdbc-osgi-test to Central
• chore: bump Gradle to 7.5
• test: update JUnit to 5.8.2

Added

• chore: added Gradle Wrapper Validation for verifying gradle-wrapper.jar
• chore: added "permissions: contents: read" for GitHub Actions to avoid unintentional modifications by the CI
• chore: support building pgjdbc with Java 17

<!--more-->

Commits by author

Dave Cramer (9):

  bump gradle to version 3 to fix compile errors with jdk17 [PR 2550](https://github.com/pgjdbc/pgjdbc/pull/2550)
  update the website content [PR 2578](https://github.com/pgjdbc/pgjdbc/pull/2578)

Sehrope Sarkuni (1):

Fix SQL generated in PgResultSet.refresh() to escape column identifiers so as to prevent SQL injection.

Vladimir Sitnikov (34):

bump system-stubs-jupiter to 2.0.1 to support Java 16+
update JUnit to 5.8.2
migrate DriverTest to JUnit5
bump Gradle to 7.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.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)

---

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

---

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

吴伟杰

---

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

---

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

---

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

吴伟杰

---

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

---

title: PostgreSQL JDBC Driver 42.2.24 Released date: 2021-09-22 15:30:49 +0000 version: 42.2.24

Fixed

• Fix startup regressions caused by PR #1949. Instead of checking all types by OID, we can return types for well known types PR #2257
• Backport PR #2148 Avoid leaking server error details through BatchUpdateException when logServerErrorDetail PR #2254
• Backpatch PR #2247 QueryExecutorImpl.receiveFastpathResult did not properly handle ParameterStatus messages. This in turn caused failures for some LargeObjectManager operations. Closes Issue #2237 Fixed by adding the missing code path, based on the existing handling in processResults. PR #2253
• Backpatch PR #2242 PgDatabaseMetaData.getIndexInfo() cast operands to smallint PR#2253 It is possible to break method PgDatabaseMetaData.getIndexInfo() by adding certain custom operators. This PR fixes it.
• Backpatching PR #2251 into 42.2 Clean up open connections to fix test failures on omni and appveyor use older syntax for COMMENT ON FUNCTION with explicit no-arg parameter parentheses as it is required on server versions before v10. Handle cleanup of connection creation in StatementTest, handle cleanup of privileged connection in DatabaseMetaDataTest
• Backpatch PR #2245 fixes case where duplicate tables are returned if there are duplicate descriptions oids are not guaranteed to be unique in the catalog PR #2248
• Change to updatable result set to use correctly primary or unique keys PR #2228 fixes issues introduced in PR #2199 closes Issue #2196
• Fix NPE calling getTypeInfo when alias is null PR #2220
• Backpatch PR #2217 to fix Issue #2215. OIDs are unsigned integers and were not being handled correctly when they exceeded the size of signed integers

<!--more-->

Commits by author

Dave Cramer (7):

• fix: backpatch PRPR 2217 to fix issue #2215. (#2218) be1d4aa0
• fix: NPE calling getTypeInfo when alias is null PR 2220 77c7d94e
• remove old changelog information from post. Incorrectly added by development script that is clearly still in development PR 2240 a70834e8
• backpatch prPR 2245 fixes case where duplicate tables are returned if there are duplicate descriptions oids are not guaranteed to be unique in the catalog (#2248) f4928cee
• backpatch PRPR 2247 (#2249) 7bf89c8b
• fix startup regressions caused by PR PR 1949. Instead of checking all types by OID, we can return types for well known types (#2257) 88cfccab
• Bump version to 42.2.24 and update changelog 233c5181

Jens Peters (1):

• Backport PR2148 into 42.2.x PR 2254 2917c1f2

Juha Syrjälä (1):

• PgDatabaseMetaData.getIndexInfo() cast operands to smallint PR 2242 (#2253) 33af6a78

Sehrope Sarkuni (3):

• test: Fix database metadata to handle older versions for function comment bb1f7285
• test: Handle cleanup of connection creation in StatementTest 1c5f5271
• test: Handle cleanup of privileged connection in DatabaseMetaDataTest 5c6041b4

chalmagr (1):

• Fix updateable result set when there are primary keys and unique keys PR 2228 c596587a

Contributors to this release

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

chalmagr

Dave Cramer

Jens Peters

Juha Syrjälä

Sehrope Sarkuni

---

title: PostgreSQL JDBC Driver 42.2.23 Released date: 2021-07-06 09:17:31 -0400 version: 42.2.23

Changed

• renewed the SSL keys for testing

Fixed

• getColumnPrecision for Numeric when scale and precision not specified now returns 0 instead of 131089 fixes: Issue #2188
• Calling refreshRow on an updateable resultset made the row readOnly. Fixes Issue #2193
• results should be updateable if there is a unique index available PR#2199 Fixes Issue #2196
• Rework sql type gathering to use OID instead of typname. This does not have the issue of name shadowing / qual-names, and has the added benefit of fixing #1948.

<!--more-->

Commits by author

Dave Cramer (2):

• fix: back patch results should be updateable PR#2199
• test: Regenerate TLS certs with new expirations (#2201)
• backpatch PR 1949 (#2206) Rework sql type gathering to use OID instead of typname.

---

title: PostgreSQL JDBC Driver 42.2.22 Released date: 2021-06-16 10:09:32 -0400 version: 42.2.22

Fixed

• Regression caused by https://github.com/pgjdbc/pgjdbc/commit/4fa2d5bc1ed8c0086a3a197fc1c28f7173d53cac. Unfortunately due to the blocking nature of the driver and issues with seeing if there is a byte available on a blocking stream when it is encrypted this introduces unacceptable delays in returning from peek(). At this time there is no simple solution to this.

<!--more-->

Commits by author

Dave Cramer (1):

---

title: PostgreSQL JDBC Driver 42.2.21 Released date: 2021-06-10 10:08:20 -0400 version: 42.2.21

Changed

• update docs to reflect deprecated DataSource API setServerName backpatch PR#2057 PR #2105

Added

Fixed

• make sure the table has defined primary keys when using updateable resultset backpatch PR#2101 fixes Issue 1975 PR #2106
• backpatch PR #2143 read notifies or errors that come in asynchronously after the ready for query PR #2168
• backpatch PR #507 which reworks OSGI bundle activator fixes ISSUE #2133
• Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified. backpatch PR #2174 fixes Issue 2173

<!--more-->

Commits by author

Dave Cramer (5):

• fix: make sure the table have defined primary keys when using updateable resultset PR 2101 (#2106) update docs to reflect deprecated DataSource API setServerName PR 2057 (#2105)

• fix: backpatch PRPR 507 which reworks OSGI bundle activator fixes ISSUE #2133 (#2166)

• fix: backpatch2142 read notifies or errors that come in asynchronously after the ready for query PR 2168

• fix: backpatch PRPR 2174 to Fix metadata functions getProcedures() and getFunctions() to ignore search_path (#2175)

---

title: PostgreSQL JDBC Driver 42.2.20 Released date: 2021-04-19 15:38:28 -0400 version: 42.2.20

Changed

Added

Fixed

• fix: Partitioned indexes were not found fixes #2078 PR #2087

• isValid() timeout should not be blocked #1943 Cherry-picked #2076 The usage of setQueryTimeout(); with the same value as the setNetworkTimeout(); is blocking the current transaction timeout. The timeouts are blocking each other with this approach.

• DatabaseMetaData.getTables returns columns in UPPER case as per the spec PR #2092 fixes Issue #830

<!--more-->

Commits by author

Dave Cramer (10):

  move comments to correct location [PR 2070](https://github.com/pgjdbc/pgjdbc/pull/2070
  Update Changelog to reflect changes in 42.2.19 [PR 2063](https://github.com/pgjdbc/pgjdbc/pull/2063
  fix: Partitioned indexes were not found fixes [PR 2078](https://github.com/pgjdbc/pgjdbc/pull/2078 (#2087)
  cherry-pick PR [PR 2092](https://github.com/pgjdbc/pgjdbc/pull/2092 PgDatabaseMetaData.getTables() should return UPPERCASE column names as per spec (#2104)

Hugo Abreu (1):

  isValid() timeout should not be blocked [PR 1943](https://github.com/pgjdbc/pgjdbc/pull/1943 (#2076)

---

title: PostgreSQL JDBC Driver 42.2.19 Released date: 2021-02-18 14:25:56 +0000 version: 42.2.19

Changed

• Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
• Fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes #1903 (#1905) There is a small behaviour change here as a result. If closeOnCompletion is called on an existing statement and the statement is executed a second time it will fail.

Added

• Verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) PR #2012

Fixed

• Fix: properly set cancel socket timeout (#2044)
• Fix "Required class information missing" when old org.jboss:jandex parses pgjdbc classes [issue 2008][https://github.com/pgjdbc/pgjdbc/issues/2008]
• Fix PGCopyInputStream returning the last row twice when reading with CopyOut API [issue 2016][https://github.com/pgjdbc/pgjdbc/issues/2016]
• Fix Connnection.isValid() to not wait longer than existing network timeout PR #2040
• Fix Passwords with spaces (ASCII and non-ASCII) now work with SCRAM authentication (driver now uses SASLprep normalization) PR #2052
• Fix DatabaseMetaData.getTablePrivileges() to include views, materialized views, and foreign tables PR #2049

<!--more-->

Commits by author

Dave Cramer (5):

• remove gssEncMode to test default in tests, should default to allow now PR 1927 013ba273
• Fixsite release42.2 PR 2032 9fcfd76e
• chore: More42.2 site fixes PR 2035 411f39d6
• fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes PR 1903 (#1905) fc25aebc

Jeremy Mailen (3):

• fix: return metadata privileges for views and foreign tables 66690817
• refactor: consolidate repeated drop code in TestUtil f5abc65c
• test: Add test for ACLs returned from metadata getTablePrivileges() for views a6cf67d2

Jorge Solórzano (1):

• fix: Use SASLprep normalization for SCRAM authentication PR 2052 b4800044

Pavel Bludov (2):

• chore: javadoc changes in PgResultSet.java to pass upcoming checkstyle version 70471c25
• chore: javadoc changes in Driver.java to pass upcoming checkstyle version c57ac5eb

Power (1):

• fix: isValid() should not wait longer than network timeout 0dbc6078

Roman Kozlov (1):

• fix: properly set cancel socket timeout PR 2044 e551d1a6

Sehrope Sarkuni (5):

• test: Add tests for broken PGCopyInputStream.readFromCopy() c6794f09
• fix: Fix last row duplicated in PGCopyInputStream.readFromCopy() 6c296a52
• test: Add TestUtils.closeQuietly(...) c152f7f0
• test: Add StrangeProxyServer 8f773a15
• docs: Add getTablePrivileges() fix to changelog 444cb1b1

Vladimir Sitnikov (14):

• chore: make javadoc optional for building from a reduced-pom.xml 736eb70d
• chore: make buildSrc.jar reproducible ff0774da
• chore: use cleanup-gradle-cache for Travis cache cleanup 0e0ae208
• fix: allow specifying binaryTransferEnable even for those types that are not enabled by default ed5891e3
• fix: binary transfer for numeric PR 1935 a4173079
• chore: update Gradle 6.3 -> 6.7.1 PR 2011 dbb12e41
• chore: verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) 991a9c0b
• chore: add org.postgresql.util.internal. Unsafe for forbidden-apis suppressions 6e3be122
• fix: "Required class information missing" when old org.jboss:jandex parses pgjdbc classes (PR PR 2010 2df6c97b
• test: set gssEncMode only in case it is not already present in Properties 97f6abd1
• test: temporarily allow CONNECTION_UNABLE_TO_CONNECT in SslTest for bad client certificates 5f584cd4
• perf: avoid duplicate PGStream#changeSocket calls b7e70d85
• chore: cancel stale workflows in GitHub Actions CI d255bd21
• doc: update README link from travis-ci.org to travis-ci.com 1bd679e8

odubaj (1):

• Remove dependency on java-comment-preprocesor df2297ef

rtrier (1):

• Fix resolve ParseError in PGtokenizer fixes PR 2050 9d6ab68e

Contributors to this release

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

Dave Cramer

Jeremy Mailen

Jorge Solórzano

odubaj

Pavel Bludov

Power

Roman Kozlov

rtrier

Sehrope Sarkuni

Vladimir Sitnikov

---

title: PostgreSQL JDBC Driver 42.2.18 Released date: 2020-10-15 14:10:20 +0000 version: 42.2.18

Fixed

• Unfortunately changing the default of gssEncMode to ALLOW was not enough. The GSSEncMode Enum was not changed as well fixed in #1920

<!--more-->

Commits by author

Contributors to this release

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

---

title: PostgreSQL JDBC Driver 42.2.17 Released date: 2020-10-09 14:24:57 +0000 version: 42.2.17

Changed

• Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly. Libpq gets around this by checking for a GSS credential cache before attempting the connection. This is possible in JDK 8 and up, but not JDK6, or JDK7 fixes Issue #1868 PR #1913

Added

• Add smallserial metadata [PR #899(https://github.com/pgjdbc/pgjdbc/pull/899)

Fixed

• Avoid NullPointerException when receiving PGbox, PGcircle, PGline, PGlseg, PGpath, PGpoint, PGpolygon, and PGmoney [PR 1873] (https://github.com/pgjdbc/pgjdbc/pull/1873)..
• The driver returns enum and jsonb arrays elements as String objects (like in 42.2.14 and earlier versions) PR 1879.
• PgTokenizer was ignoring last empty token PR #1882
• Remove osgi from karaf fixes Issue #1891 PR #1902

<!--more-->

Commits by author

Dave Cramer (5):

• fix: PgTokenizer was ignoring last empty token PR 1882 a6e83342
• fix checkstyle PR 1888 70b02c55
• fix: handle smallserial correctly fixes PR 1897 (#1899) d4a4b2d6
• fix:remove osgi from karaf fixes Issue PR 1891 (#1902) 0c2858e9
• Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly 14c4173c

Jorge Solorzano (1):

• feat: add smallserial metadata PR 899 05403bd0

Vladimir Sitnikov (8):

• fix: handle nulls when the following clasess are used: PGbox, PGcircle, PGline, PGlseg, PGpath, PGpoint, PGpolygon, and PGmoney c745f4e5
• chore: fix compileJava7 and compileJava6 0308ffca
• chore: run GitHub actions when branch name has slash 433817d6
• chore: seed build cache only when credentials exist (==skip on forks) eec708a8
• test: add GitHub CI for testing source distribution 44d0923f
• test: add tests for enum, json, and jsonb array 1bec4022
• fix: make enum, json, and jsonb array result classes to be the same as 42.2.14 and earlier PR 1876 41855018
• fix: avoid removal type annotations on "this" so the source archive is buildable 832bf21c

Contributors to this release

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

Dave Cramer

Jorge Solorzano

Vladimir Sitnikov