Skip to content

Commit 512799b

Browse files
davecramerjorsol
davecramer
and
jorsol
authored
Changelog 42.2.24 (#2258)
* Bump version to 42.2.24 and update changelog * update contributors, and release post Co-authored-by: Jorge Solórzano <jorsol@gmail.com>
1 parent 88cfcca commit 512799b

4 files changed

Lines changed: 111 additions & 23 deletions

File tree

‎CHANGELOG.md‎

Lines changed: 35 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -9,13 +9,32 @@ The format is based on [Keep a Changelog](http://keepachangelog.com/en/1.0.0/).
99
### Added
1010

1111
### Fixed
12-
- Fix "Avoid leaking server error details through BatchUpdateException when logServerErrorDetail=false" [PR #2148](https://github.com/pgjdbc/pgjdbc/pull/2148) fixes Issue #2147
1312

14-
[42.2.23] (2021-07-06 09:17:32 -0400)
1513

14+
## [42.2.24] (2021-09-23)
15+
### Fixed
16+
- Fix startup regressions caused by [PR #1949](https://github.com/pgjdbc/pgjdbc/pull/1949). Instead of checking all types by OID, we can return types for well known types [PR #2257](https://github.com/pgjdbc/pgjdbc/pull/2257)
17+
- Backport [PR #2148](https://github.com/pgjdbc/pgjdbc/pull/2148)
18+
Avoid leaking server error details through BatchUpdateException when logServerErrorDetail [PR #2254](https://github.com/pgjdbc/pgjdbc/pull/2254)
19+
- Backpatch [PR #2247](https://github.com/pgjdbc/pgjdbc/pull/2247)
20+
QueryExecutorImpl.receiveFastpathResult did not properly handle ParameterStatus messages.
21+
This in turn caused failures for some LargeObjectManager operations. Closes [Issue #2237](https://github.com/pgjdbc/pgjdbc/issues/2237)
22+
Fixed by adding the missing code path, based on the existing handling in processResults. [PR #2253](https://github.com/pgjdbc/pgjdbc/pull/2253)
23+
- Backpatch [PR #2242](https://github.com/pgjdbc/pgjdbc/pull/2242) PgDatabaseMetaData.getIndexInfo() cast operands to smallint [PR#2253](https://github.com/pgjdbc/pgjdbc/pull/2253)
24+
It is possible to break method PgDatabaseMetaData.getIndexInfo() by adding certain custom operators. This PR fixes it.
25+
- Backpatching [PR #2251](https://github.com/pgjdbc/pgjdbc/pull/2251) into 42.2 Clean up open connections to fix test failures on omni and appveyor
26+
use older syntax for COMMENT ON FUNCTION with explicit no-arg parameter parentheses as it is required on server versions before v10.
27+
Handle cleanup of connection creation in StatementTest, handle cleanup of privileged connection in DatabaseMetaDataTest
28+
- Backpatch [PR #2245](https://github.com/pgjdbc/pgjdbc/pull/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](https://github.com/pgjdbc/pgjdbc/pull/2248)
29+
- Change to updatable result set to use correctly primary or unique keys [PR #2228](https://github.com/pgjdbc/pgjdbc/pull/2228)
30+
fixes issues introduced in [PR #2199](https://github.com/pgjdbc/pgjdbc/pull/2199) closes [Issue #2196](https://github.com/pgjdbc/pgjdbc/issues/2196)
31+
- Fix NPE calling getTypeInfo when alias is null [PR #2220](https://github.com/pgjdbc/pgjdbc/pull/2220)
32+
- Backpatch [PR #2217](https://github.com/pgjdbc/pgjdbc/pull/2217) to fix [Issue #2215](https://github.com/pgjdbc/pgjdbc/issues/2215). OIDs are unsigned integers and were not being handled correctly when they exceeded the size of signed integers
33+
34+
35+
## [42.2.23] (2021-07-06)
1636
### Changed
1737
- renewed the SSL keys for testing
18-
### Added
1938

2039
### Fixed
2140
- getColumnPrecision for Numeric when scale and precision not specified now returns 0 instead of 131089 fixes: Issue #2188
@@ -24,35 +43,27 @@ The format is based on [Keep a Changelog](http://keepachangelog.com/en/1.0.0/).
2443
- Rework sql type gathering to use OID instead of typname.
2544
This does not have the issue of name shadowing / qual-names, and has the added benefit of fixing #1948.
2645

27-
[42.2.22] (2021-06-16 10:09:33 -0400)
28-
### Changed
29-
30-
### Added
3146

47+
## [42.2.22] (2021-06-16)
3248
### Fixed
3349
- Regression caused by https://github.com/pgjdbc/pgjdbc/commit/4fa2d5bc1ed8c0086a3a197fc1c28f7173d53cac. Unfortunately
3450
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
3551
this introduces unacceptable delays in returning from peek(). At this time there is no simple solution to this.
36-
37-
[42.2.21] (2021-06-10 10:08:21 -0400)
52+
53+
54+
## [42.2.21] (2021-06-10)
3855
### Changed
3956
- update docs to reflect deprecated DataSource API setServerName backpatch [PR#2057](https://github.com/pgjdbc/pgjdbc/pull/2057) [PR #2105](https://github.com/pgjdbc/pgjdbc/pull/2105)
4057

41-
### Added
42-
4358
### Fixed
4459
- make sure the table has defined primary keys when using updateable resultset backpatch [PR#2101](https://github.com/pgjdbc/pgjdbc/pull/2101) fixes [Issue 1975](https://github.com/pgjdbc/pgjdbc/issues/1975) [PR #2106](https://github.com/pgjdbc/pgjdbc/pull/2106)
4560
- backpatch [PR #2143](https://github.com/pgjdbc/pgjdbc/pull/2143) read notifies or errors that come in asynchronously after the ready for query [PR #2168](https://github.com/pgjdbc/pgjdbc/pull/2168)
4661
- backpatch [PR #507](https://github.com/pgjdbc/pgjdbc/pull/507) which reworks OSGI bundle activator fixes [ISSUE #2133](https://github.com/pgjdbc/pgjdbc/issues/2133)
4762
- Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified. backpatch [PR #2174](https://github.com/pgjdbc/pgjdbc/pull/2174)
4863
fixes [Issue 2173](https://github.com/pgjdbc/pgjdbc/issues/2173)
4964

50-
[42.2.20] (2021-04-19 15:38:44 -0400)
51-
52-
### Changed
53-
54-
### Added
5565

66+
## [42.2.20] (2021-04-19)
5667
### Fixed
5768
- Partitioned indexes were not found fixes [#2078](https://github.com/pgjdbc/pgjdbc/issues/2078) PR [#2087](https://github.com/pgjdbc/pgjdbc/pull/2087)
5869

@@ -61,8 +72,8 @@ The format is based on [Keep a Changelog](http://keepachangelog.com/en/1.0.0/).
6172
The timeouts are blocking each other with this approach.
6273
- DatabaseMetaData.getTables returns columns in UPPER case as per the spec [PR #2092](https://github.com/pgjdbc/pgjdbc/pull/2092) fixes [Issue #830](https://github.com/pgjdbc/pgjdbc/issues/830)
6374

64-
## [42.2.19] (2021-02-18)
6575

76+
## [42.2.19] (2021-02-18)
6677
**Notable Changes**
6778
- Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
6879
- If closeOnCompletion is called on an existing statement and the statement
@@ -89,12 +100,14 @@ is executed a second time it will fail.
89100
- Fix Resolve ParseError in PGtokenizer fixes #2050
90101
- Fix return metadata privileges for views and foreign tables
91102

92-
## [42.2.18]
103+
104+
## [42.2.18] (2020-10-15)
93105
### Fixed
94106
- Unfortunately changing the default of gssEncMode to ALLOW was not enough. The GSSEncMode Enum was not changed as well
95107
fixed in #1920
96108

97-
## [42.2.17]
109+
110+
## [42.2.17] (2020-10-09)
98111
### Changed
99112
- 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](https://github.com/pgjdbc/pgjdbc/pull/1913)
100113

@@ -107,6 +120,7 @@ fixed in #1920
107120
- PgTokenizer was ignoring last empty token [PR #1882](https://github.com/pgjdbc/pgjdbc/pull/1882)
108121
- Remove osgi from karaf fixes Issue #1891 [PR #1902](https://github.com/pgjdbc/pgjdbc/pull/1902)
109122

123+
110124
## [42.2.16] (2020-08-20)
111125
### Known issues
112126
- The driver returns enum and jsonb arrays elements are returned as PGobject instances (fixed in 42.2.17)
@@ -509,5 +523,6 @@ thrown to caller to be dealt with so no need to log at this verbosity by pgjdbc
509523
[42.2.21]: https://github.com/pgjdbc/pgjdbc/compare/REL42.2.20...REL42.2.21
510524
[42.2.22]: https://github.com/pgjdbc/pgjdbc/compare/REL42.2.21...REL42.2.22
511525
[42.2.23]: https://github.com/pgjdbc/pgjdbc/compare/REL42.2.22...REL42.2.23
512-
[Unreleased]: https://github.com/pgjdbc/pgjdbc/compare/REL42.2.23...HEAD
526+
[42.2.24]: https://github.com/pgjdbc/pgjdbc/compare/REL42.2.23...REL42.2.24
513527

528+
[Unreleased]: https://github.com/pgjdbc/pgjdbc/compare/REL42.2.24...HEAD

‎contributors.json‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -33,6 +33,7 @@
3333
"Hari Babu Kommi" : "https://github.com/kommiharibabu",
3434
"Harry Chan" : "https://github.com/hc-codersatlas",
3535
"Hugh Cole-Baker" : "https://github.com/sigmaris",
36+
"Hugo Abreu" : "6619758+hugomiguelabreu@users.noreply.github.com",
3637
"Igor Volkov" : "https://github.com/virtual-machinist",
3738
"ItaiFonio" : "https://github.com/ItaiFonio",
3839
"Ivan Leskin" : "https://github.com/leskin-in",
@@ -44,12 +45,14 @@
4445
"Jan Van den Bergh" : "https://github.com/janvdbergh",
4546
"Jean-Christophe Arnu" : "https://github.com/jcarnu",
4647
"Jeff Klukas" : "https://github.com/jklukas",
48+
"Jens Peters" : "https://github.com/jp7677",
4749
"Jeremy Mailen" : "https://github.com/jeremymailen",
4850
"Jeremy Whiting" : "https://github.com/whitingjr",
4951
"Jesper Pedersen" : "https://github.com/jesperpedersen",
5052
"Joe Kutner" : "https://github.com/jkutner",
5153
"Jordan Lewis" : "https://github.com/jordanlewis",
5254
"Jorge Solórzano" : "https://github.com/jorsol",
55+
"Juha Syrjälä" : "https://github.com/jsyrjala",
5356
"Kamal Kumlien" : "https://github.com/kkumlien",
5457
"Kazuhiro Sera" : "https://github.com/seratch",
5558
"Kevin Wooten" : "https://github.com/kdubb",
@@ -131,6 +134,7 @@
131134
"bjanczak" : "https://github.com/bjanczak",
132135
"bpd0018" : "https://github.com/bpd0018",
133136
"chalda" : "https://github.com/ochaloup",
137+
"chalmagr" : "https://github.com/chalmagr",
134138
"crwr45" : "https://github.com/crwr45",
135139
"djydewang" : "https://github.com/djydewang",
136140
"draderaws" : "https://github.com/draderaws",
@@ -155,6 +159,5 @@
155159
"zapov" : "https://github.com/zapov",
156160
"Álvaro Hernández Tortosa" : "https://github.com/ahachete",
157161
"Árpád Magosányi" : "https://github.com/magwas",
158-
"Étienne BERSAC" : "https://github.com/bersace",
159-
"Hugo Abreu" : "6619758+hugomiguelabreu@users.noreply.github.com"
162+
"Étienne BERSAC" : "https://github.com/bersace"
160163
}

‎docs/_posts/2021-09-22-42.2.24-release.md‎

Lines changed: 70 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,70 @@
1+
---
2+
title: PostgreSQL JDBC Driver 42.2.24 Released
3+
date: 2021-09-22 15:30:49 +0000
4+
categories:
5+
- new_release
6+
version: 42.2.24
7+
---
8+
9+
### Fixed
10+
- Fix startup regressions caused by [PR #1949](https://github.com/pgjdbc/pgjdbc/pull/1949). Instead of checking all types by OID, we can return types for well known types [PR #2257](https://github.com/pgjdbc/pgjdbc/pull/2257)
11+
- Backport [PR #2148](https://github.com/pgjdbc/pgjdbc/pull/2148)
12+
Avoid leaking server error details through BatchUpdateException when logServerErrorDetail [PR #2254](https://github.com/pgjdbc/pgjdbc/pull/2254)
13+
- Backpatch [PR #2247](https://github.com/pgjdbc/pgjdbc/pull/2247)
14+
QueryExecutorImpl.receiveFastpathResult did not properly handle ParameterStatus messages.
15+
This in turn caused failures for some LargeObjectManager operations. Closes [Issue #2237](https://github.com/pgjdbc/pgjdbc/issues/2237)
16+
Fixed by adding the missing code path, based on the existing handling in processResults. [PR #2253](https://github.com/pgjdbc/pgjdbc/pull/2253)
17+
- Backpatch [PR #2242](https://github.com/pgjdbc/pgjdbc/pull/2242) PgDatabaseMetaData.getIndexInfo() cast operands to smallint [PR#2253](https://github.com/pgjdbc/pgjdbc/pull/2253)
18+
It is possible to break method PgDatabaseMetaData.getIndexInfo() by adding certain custom operators. This PR fixes it.
19+
- Backpatching [PR #2251](https://github.com/pgjdbc/pgjdbc/pull/2251) into 42.2 Clean up open connections to fix test failures on omni and appveyor
20+
use older syntax for COMMENT ON FUNCTION with explicit no-arg parameter parentheses as it is required on server versions before v10.
21+
Handle cleanup of connection creation in StatementTest, handle cleanup of privileged connection in DatabaseMetaDataTest
22+
- Backpatch [PR #2245](https://github.com/pgjdbc/pgjdbc/pull/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](https://github.com/pgjdbc/pgjdbc/pull/2248)
23+
- Change to updatable result set to use correctly primary or unique keys [PR #2228](https://github.com/pgjdbc/pgjdbc/pull/2228)
24+
fixes issues introduced in [PR #2199](https://github.com/pgjdbc/pgjdbc/pull/2199) closes [Issue #2196](https://github.com/pgjdbc/pgjdbc/issues/2196)
25+
- Fix NPE calling getTypeInfo when alias is null [PR #2220](https://github.com/pgjdbc/pgjdbc/pull/2220)
26+
- Backpatch [PR #2217](https://github.com/pgjdbc/pgjdbc/pull/2217) to fix [Issue #2215](https://github.com/pgjdbc/pgjdbc/issues/2215). OIDs are unsigned integers and were not being handled correctly when they exceeded the size of signed integers
27+
28+
29+
<!--more-->
30+
31+
**Commits by author**
32+
33+
Dave Cramer (7):
34+
35+
* fix: backpatch PR[PR 2217](https://github.com/pgjdbc/pgjdbc/pull/2217) to fix issue #2215. (#2218) [be1d4aa0](https://github.com/pgjdbc/pgjdbc/commit/be1d4aa05f818a1d64a58462413ac1291858a2b2)
36+
* fix: NPE calling getTypeInfo when alias is null [PR 2220](https://github.com/pgjdbc/pgjdbc/pull/2220) [77c7d94e](https://github.com/pgjdbc/pgjdbc/commit/77c7d94e05003db7bece1d7baeb059272e3bcda2)
37+
* remove old changelog information from post. Incorrectly added by development script that is clearly still in development [PR 2240](https://github.com/pgjdbc/pgjdbc/pull/2240) [a70834e8](https://github.com/pgjdbc/pgjdbc/commit/a70834e8c5c9c2c3ab7024c5c605d3a978c00272)
38+
* backpatch pr[PR 2245](https://github.com/pgjdbc/pgjdbc/pull/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](https://github.com/pgjdbc/pgjdbc/commit/f4928cee038543202e0f09a77348f249155fec12)
39+
* backpatch PR[PR 2247](https://github.com/pgjdbc/pgjdbc/pull/2247) (#2249) [7bf89c8b](https://github.com/pgjdbc/pgjdbc/commit/7bf89c8b2fa2218fc37f959753da2b01be09ffc2)
40+
* fix startup regressions caused by PR [PR 1949](https://github.com/pgjdbc/pgjdbc/pull/1949). Instead of checking all types by OID, we can return types for well known types (#2257) [88cfccab](https://github.com/pgjdbc/pgjdbc/commit/88cfccab1ce41c8fb9f238d2ff09eba969c41a02)
41+
* Bump version to 42.2.24 and update changelog [233c5181](https://github.com/pgjdbc/pgjdbc/commit/233c51810dc34d34ebb7efcd4d4b960d626b8c53)
42+
43+
Jens Peters (1):
44+
45+
* Backport PR2148 into 42.2.x [PR 2254](https://github.com/pgjdbc/pgjdbc/pull/2254) [2917c1f2](https://github.com/pgjdbc/pgjdbc/commit/2917c1f2d448f68419c89530ffc742a3d693ed1e)
46+
47+
Juha Syrjälä (1):
48+
49+
* PgDatabaseMetaData.getIndexInfo() cast operands to smallint [PR 2242](https://github.com/pgjdbc/pgjdbc/pull/2242) (#2253) [33af6a78](https://github.com/pgjdbc/pgjdbc/commit/33af6a780af0083b382d536c909a20145d5ff195)
50+
51+
Sehrope Sarkuni (3):
52+
53+
* test: Fix database metadata to handle older versions for function comment [bb1f7285](https://github.com/pgjdbc/pgjdbc/commit/bb1f7285b7884f3d8032a637b38f49f4b2faaac1)
54+
* test: Handle cleanup of connection creation in StatementTest [1c5f5271](https://github.com/pgjdbc/pgjdbc/commit/1c5f52712a5d6757b69effdb2c5d9eb06657a871)
55+
* test: Handle cleanup of privileged connection in DatabaseMetaDataTest [5c6041b4](https://github.com/pgjdbc/pgjdbc/commit/5c6041b49146cecee1e360a18789197827aa6adf)
56+
57+
chalmagr (1):
58+
59+
* Fix updateable result set when there are primary keys and unique keys [PR 2228](https://github.com/pgjdbc/pgjdbc/pull/2228) [c596587a](https://github.com/pgjdbc/pgjdbc/commit/c596587aa52db6573d5cf41f29f1f6b8afe29cb5)
60+
61+
<a name="contributors_{{ page.version }}"></a>
62+
### Contributors to this release
63+
64+
We thank the following people for their contributions to this release.
65+
66+
[chalmagr](https://github.com/chalmagr)
67+
[Dave Cramer](davec@postgresintl.com)
68+
[Jens Peters](https://github.com/jp7677)
69+
[Juha Syrjälä](https://github.com/jsyrjala)
70+
[Sehrope Sarkuni](https://github.com/sehrope)

‎gradle.properties‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@ kotlin.parallel.tasks.in.project=true
1414
# This is version for PgJdbc itself
1515
# Note: it should not include "-SNAPSHOT" as it is automatically added by build.gradle.kts
1616
# Release version can be generated by using -Prelease or -Prc=<int> arguments
17-
pgjdbc.version=42.2.23
17+
pgjdbc.version=42.2.24
1818

1919
# The options below configures the use of local clone (e.g. testing development versions)
2020
# You can pass un-comment it, or pass option -PlocalReleasePlugins, or -PlocalReleasePlugins=<path>

0 commit comments

Comments
 (0)