Maven Central · #1417 by repository stars

org.postgresql:pgjdbc-osgi-test

42.4.0pgjdbc/pgjdbc ↗New releases in your daily digest, changelog included.

PostgreSQL JDBC Driver Pgjdbc-osgi-test

Last release 3 years ago
no release in 18 months
Ships unpredictably
gaps range from 2 weeks to 1.2 years
Most releases are documented
notes for 10 of 12 stable releases
Nothing withdrawn
no release was ever pulled
5 years old
12 releases · first in 2021

Release timeline

12 releases since 2021

202120222023202420252026

20212026

One column per quarter.

Releases

42.4.09 Jun 2022
fix: added GROUP_STARTUP_PARAMETERS boolean property to determine whether or not to group startup parameters in a transaction (default=false like 42.2
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)
Open source →

From the same repository

pgjdbc/pgjdbc

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)

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)

42.3.1013 Mar 2024

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

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.

Open source →

42.3.921 Feb 2024Security

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…

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.

Open source →

42.3.624 May 2022

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

Changed

Added

Fixed

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

Open source →

Additional notes

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

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)

Open source →

42.3.54 May 2022

test: polish TimestampUtilsTest

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

Open source →

Additional notes

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

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

Open source →

42.3.415 Apr 2022Deprecated

fix: Remove isDeprecated from PGProperty. It was originally intended to help produce automated docs. Fixes Issue #2479 PR 2480

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

Open source →

Additional notes

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

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

吴伟杰

42.3.315 Feb 2022

fix: Removed loggerFile and loggerLevel configuration. While the properties still exist. They can no longer be used to configure the driver logging. I

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

Open source →

Additional notes

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

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

Open source →

42.3.21 Feb 2022Security

CVE-2022-21724 pgjdbc instantiates plugin instances based on class names provided via authenticationPluginClassName, sslhostnameverifier, socketFactor…

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

Open source →

Additional notes

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

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.

42.3.129 Oct 2021

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

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

Open source →

Additional notes

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

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.

42.3.015 Oct 2021

No longer build for Java 6 or Java 7

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

Open source →

Additional notes

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