perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns by john9x · Pull Request #2634 · pgjdbc/pgjdbc (original) (raw)
This PR contains the following updates:
| Package | Type | Package file | Manager | Update | Change |
|---|---|---|---|---|---|
| org.threeten:threetenbp | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.6.9 -> 1.7.0 |
||
| app.cash.tempest:tempest-bom | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2024.08.07.002316-64f40ef -> 2024.09.04.165019-8430cf3 |
|||||
| org.postgresql:postgresql | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 42.3.9 -> 42.7.4 |
||
| com.squareup.okio:okio | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | 3.9.0 |
|
-> 3.9.1 |
|||||
| org.mockito:mockito-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
5.13.0 -> 5.14.1 |
|||||
| ch.qos.logback:logback-core | |||||
| (source, | |||||
| changelog) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.4.14 -> 1.5.6 |
||
| ch.qos.logback:logback-classic | |||||
| (source, | |||||
| changelog) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.4.14 -> 1.5.6 |
||
| org.jetbrains.kotlinx:kotlinx-coroutines-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.8.1 -> 1.9.0 |
|||||
| org.jooq:jooq | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 3.18.2 -> 3.18.20 |
||
| redis.clients:jedis | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 5.1.5 -> 5.2.0 |
||
| com.google.guava:guava-bom | |||||
| (source) | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
33.3.0-jre -> 33.3.1-jre |
|||||
| io.grpc:grpc-stub | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.60.0 -> 1.68.0 |
||
| io.grpc:grpc-protobuf | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.60.0 -> 1.68.0 |
|||||
| io.grpc:grpc-netty | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.60.0 -> 1.68.0 |
||
| io.grpc:protoc-gen-grpc-java | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.60.0 -> 1.68.0 |
|||||
| io.grpc:grpc-bom | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.60.0 -> 1.68.0 |
||
| io.grpc:grpc-api | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 1.60.0 -> 1.68.0 |
||
| com.google.api.grpc:proto-google-common-protos | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.43.0 -> 2.45.1 |
|||||
| com.google.apis:google-api-services-storage | |||||
| (source) | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
v1-rev20240916-2.0.0 -> v1-rev20240924-2.0.0 |
|||||
| com.google.cloud:google-cloud-spanner | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
6.75.0 -> 6.76.0 |
|||||
| com.google.api:gax | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.52.0 -> 2.54.1 |
|||||
| com.google.errorprone:error_prone_annotations | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 2.31.0 -> 2.32.0 |
||
| com.netflix.concurrency-limits:concurrency-limits-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
0.5.1 -> 0.5.2 |
|||||
| org.apache.commons:commons-lang3 | |||||
| (source) | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
3.16.0 -> 3.17.0 |
|||||
| commons-io:commons-io | |||||
| (source) | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.16.1 -> 2.17.0 |
|||||
| app.cash.sqldelight:runtime | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | 2.0.0 |
|
-> 2.0.2 |
|||||
| app.cash.sqldelight:mysql-dialect | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
2.0.0 -> 2.0.2 |
|||||
| app.cash.sqldelight:jdbc-driver | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
2.0.0 -> 2.0.2 |
|||||
| app.cash.sqldelight:gradle-plugin | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
2.0.0 -> 2.0.2 |
|||||
| com.google.protobuf:protoc | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 3.25.4 -> 3.25.5 |
||
| com.google.protobuf:protobuf-java | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 3.25.4 -> 3.25.5 |
||
| com.squareup.okhttp3:mockwebserver | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 5.0.0-alpha.13 -> |
||
5.0.0-alpha.14 |
|||||
| com.squareup.okhttp3:okhttp | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 5.0.0-alpha.13 -> |
||
5.0.0-alpha.14 |
|||||
| io.netty:netty-handler | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 4.1.112.Final -> |
||
4.1.113.Final |
|||||
| io.netty:netty-bom | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 4.1.112.Final -> |
||
4.1.113.Final |
|||||
| io.micrometer:micrometer-registry-prometheus | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
1.12.9 -> 1.12.10 |
|||||
| io.micrometer:micrometer-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | patch | ||
1.12.9 -> 1.12.10 |
|||||
| com.vanniktech.maven.publish.base | |||||
| plugin | misk/gradle/libs.versions.toml | gradle | minor | 0.27.0 -> |
|
0.28.0 |
|||||
| com.vanniktech:gradle-maven-publish-plugin | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
0.27.0 -> 0.28.0 |
|||||
| org.junit.jupiter:junit-jupiter-params | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 5.11.0 -> 5.11.1 |
||
| org.junit.jupiter:junit-jupiter-engine | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 5.11.0 -> 5.11.1 |
||
| org.junit.jupiter:junit-jupiter-api | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 5.11.0 -> 5.11.1 |
||
| com.fasterxml.jackson.module:jackson-module-kotlin | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.17.2 -> 2.18.0 |
|||||
| com.fasterxml.jackson.datatype:jackson-datatype-jsr310 | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.17.2 -> 2.18.0 |
|||||
| com.fasterxml.jackson.dataformat:jackson-dataformat-yaml | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.17.2 -> 2.18.0 |
|||||
| com.fasterxml.jackson.core:jackson-databind | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | minor | 2.17.2 -> 2.18.0 |
||
| com.fasterxml.jackson.core:jackson-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.17.2 -> 2.18.0 |
|||||
| com.fasterxml.jackson:jackson-bom | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.17.2 -> 2.18.0 |
|||||
| com.fasterxml.jackson.core:jackson-annotations | |||||
| (source) | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.17.2 -> 2.18.0 |
|||||
| com.google.auth:google-auth-library-oauth2-http | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.24.1 -> 1.27.0 |
|||||
| com.google.auth:google-auth-library-credentials | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.24.1 -> 1.27.0 |
|||||
| io.gitlab.arturbosch.detekt:detekt-test-utils | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.23.6 -> 1.23.7 |
||
| io.gitlab.arturbosch.detekt:detekt-test | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.23.6 -> 1.23.7 |
||
| io.gitlab.arturbosch.detekt:detekt-psi-utils | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.23.6 -> 1.23.7 |
||
| io.gitlab.arturbosch.detekt:detekt-parser | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.23.6 -> 1.23.7 |
||
| io.gitlab.arturbosch.detekt:detekt-gradle-plugin | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.23.6 -> 1.23.7 |
||
| io.gitlab.arturbosch.detekt:detekt-api | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.23.6 -> 1.23.7 |
||
| com.datadoghq:dd-trace-api | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.38.1 -> 1.39.1 |
|||||
| com.datadoghq:dd-trace-ot | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
1.38.1 -> 1.39.1 |
|||||
| software.amazon.awssdk:sdk-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.27.14 -> 2.28.11 |
|||||
| software.amazon.awssdk:dynamodb-enhanced | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.27.14 -> 2.28.11 |
|||||
| software.amazon.awssdk:dynamodb | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.27.14 -> 2.28.11 |
|||||
| software.amazon.awssdk:aws-core | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.27.14 -> 2.28.11 |
|||||
| software.amazon.awssdk:bom | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.27.14 -> 2.28.11 |
|||||
| software.amazon.awssdk:auth | |||||
| dependencies | misk/gradle/libs.versions.toml | gradle | minor | ||
2.27.14 -> 2.28.11 |
|||||
| com.amazonaws:aws-java-sdk-sqs | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.12.770 -> |
||
1.12.772 |
|||||
| com.amazonaws:aws-java-sdk-s3 | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.12.770 -> |
||
1.12.772 |
|||||
| com.amazonaws:aws-java-sdk-dynamodb | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.12.770 -> |
||
1.12.772 |
|||||
| com.amazonaws:aws-java-sdk-core | |||||
| (source) | dependencies | ||||
| misk/gradle/libs.versions.toml | gradle | patch | 1.12.770 -> |
||
1.12.772 |
⚠️ Warning
Some dependencies could not be looked up. Check the Dependency Dashboard for more information.
Release Notes
pgjdbc/pgjdbc (org.postgresql:postgresql)
Added
- chore: SCRAM dependency to 3.1 and support channel binding [PR
#3188](https://github.com/pgjdbc/pgjdbc/pull/3188)
- chore: Add PostgreSQL 15, 16, and 17beta1 to CI tests [PR
#3299](https://github.com/pgjdbc/pgjdbc/pull/3299)
- test: Update to 17beta3 [PR
#3308](https://github.com/pgjdbc/pgjdbc/pull/3308)
- chore: Implement direct SSL ALPN connections [PR
#3252](https://github.com/pgjdbc/pgjdbc/pull/3252)
- translation: Add Korean translation file [PR
#3276](https://github.com/pgjdbc/pgjdbc/pull/3276)
Fixed
- fix: PgInterval ignores case for represented interval string [PR
#3344](https://github.com/pgjdbc/pgjdbc/pull/3344)
- perf: Avoid extra copies when receiving int4 and int2 in PGStream [PR
#3295](https://github.com/pgjdbc/pgjdbc/pull/3295)
- fix: Add support for Infinity::numeric values in ResultSet.getObject PR #3304
- fix: Ensure order of results for getDouble [PR
#3301](https://github.com/pgjdbc/pgjdbc/pull/3301)
- perf: Replace BufferedOutputStream with unsynchronized PgBufferedOutputStream, allow configuring different Java and SO_SNDBUF buffer sizes [PR
#3248](https://github.com/pgjdbc/pgjdbc/pull/3248)
- fix: Fix SSL tests [PR
#3260](https://github.com/pgjdbc/pgjdbc/pull/3260)
- fix: Support bytea in preferQueryMode=simple [PR
#3243](https://github.com/pgjdbc/pgjdbc/pull/3243)
- fix: Fix #3234
- Return -1 as update count for stored procedure calls [PR
#3235](https://github.com/pgjdbc/pgjdbc/pull/3235)
- fix: Fix #3224
- conversion for TIME '24:00' to LocalTime breaks in binary-mode [PR
#3225](https://github.com/pgjdbc/pgjdbc/pull/3225)
- perf: Speed up getDate by parsing bytes instead of String [PR
#3141](https://github.com/pgjdbc/pgjdbc/pull/3141)
- fix: support PreparedStatement.setBlob(1, Blob) and PreparedStatement.setClob(1, Clob) for lobs that return -1 for length PR #3136
- fix: Validates resultset Params in PGStatement constructor. uses assertThro… [PR
#3171](https://github.com/pgjdbc/pgjdbc/pull/3171)
- fix: Validates resultset parameters [PR
#3167](https://github.com/pgjdbc/pgjdbc/pull/3167)
- docs: Replace greater to with greater than [PR
#3315](https://github.com/pgjdbc/pgjdbc/pull/3315)
- docs: Clarify binaryTransfer and prepareThreshold [PR
#3338](https://github.com/pgjdbc/pgjdbc/pull/3338)
- docs: use.md, typo [PR
#3314](https://github.com/pgjdbc/pgjdbc/pull/3314)
- test: Use docker v2 which changes docker-compose to docker compose #3339
- refactor: Merge PgPreparedStatement#setBinaryStream int and long methods PR #3165
- test: Test both binaryMode=true,false when creating connections in DatabaseMetaDataTest [PR
#3231](https://github.com/pgjdbc/pgjdbc/pull/3231)
- docs: Fixed typos in all source code and documentations [PR
#3242](https://github.com/pgjdbc/pgjdbc/pull/3242)
- chore: Remove self-hosted runner [PR
#3227](https://github.com/pgjdbc/pgjdbc/pull/3227)
- docs: Add cancelSignalTimeout in README [PR
#3190](https://github.com/pgjdbc/pgjdbc/pull/3190)
- docs: Document READ_ONLY_MODE in README [PR
#3175](https://github.com/pgjdbc/pgjdbc/pull/3175)
- test: Test for +/- infinity double values [PR
#3294](https://github.com/pgjdbc/pgjdbc/pull/3294)
- test: Switch localhost and auth-test around for test-gss [PR
#3343](https://github.com/pgjdbc/pgjdbc/pull/3343)
- fix: remove preDescribe from internalExecuteBatch [PR
#2883](https://github.com/pgjdbc/pgjdbc/pull/2883)
Deprecated
- test: Deprecate all PostgreSQL versions older than 9.1 [PR
#3335](https://github.com/pgjdbc/pgjdbc/pull/3335)
Changed
- chore: gradle config enforces 17+ [PR
#3147](https://github.com/pgjdbc/pgjdbc/pull/3147)
Fixed
- fix: boolean types not handled in SimpleQuery mode [PR
#3146](https://github.com/pgjdbc/pgjdbc/pull/3146) - make sure we handle boolean types in simple query mode - support uuid as well
- handle all well known types in text mode and change
else iftoswitch - fix: released new versions of 42.2.29, 42.3.10, 42.4.5, 42.5.6, 42.6.2
to deal with
NoSuchMethodError on ByteBuffer#positionwhen running on Java 8
Security
- security: SQL Injection via line comment generation, it is possible in
SimpleQuerymode 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
- fix: Use simple query for isValid. Using Extended query sends two messages checkConnectionQuery was never ever set or used, removed [PR
#3101](https://github.com/pgjdbc/pgjdbc/pull/3101)
- perf: Avoid autoboxing bind indexes by @bokken in [PR
#1244](https://github.com/pgjdbc/pgjdbc/pull/1244)
- refactor: Document that encodePassword will zero out the password array, and remove driver's default encodePassword by @vlsi in [PR
#3084](https://github.com/pgjdbc/pgjdbc/pull/3084)
Added
- feat: Add PasswordUtil for encrypting passwords client side [PR
#3082](https://github.com/pgjdbc/pgjdbc/pull/3082)
Changed
- perf: improve performance of PreparedStatement.setBlob, BlobInputStream, and BlobOutputStream with dynamic buffer sizing [PR
#3044](https://github.com/pgjdbc/pgjdbc/pull/3044)
Fixed
- fix: Apply connectTimeout before SSLSocket.startHandshake to avoid infinite wait in case the connection is broken [PR
#3040](https://github.com/pgjdbc/pgjdbc/pull/3040)
- fix: support waffle-jna 2.x and 3.x by using reflective approach for ManagedSecBufferDesc [PR
#2720](https://github.com/pgjdbc/pgjdbc/pull/2720) Fixes Issue #2690.
- fix: NoSuchMethodError on ByteBuffer#position When Running on Java 8 when accessing arrays, fixes [Issue
#3014](https://github.com/pgjdbc/pgjdbc/issues/3014)
- Revert "PR #2925 Use canonical DateStyle name" [PR
#3035](https://github.com/pgjdbc/pgjdbc/pull/3035) Fixes Issue #3008
- Revert "PR ##2973 feat: support SET statements combining with other queries with semicolon in PreparedStatement" [PR
#3010](https://github.com/pgjdbc/pgjdbc/pull/3010) Fixes Issue #3007
- fix: avoid timezone conversions when sending LocalDateTime to the database #2852 Fixes Issue #1390 ,Issue #2850 Closes [Issue #1391(https://github.com/pgjdbc/pgjdbc/issues/1391)
Changed
- fix: Deprecate for removal PGPoint.setLocation(java.awt.Point) to cut
dependency to
java.desktopmodule. [PR
#2967](https://github.com/pgjdbc/pgjdbc/pull/2967)
- feat: return all catalogs for getCatalogs metadata query closes [ISSUE
#2949](https://github.com/pgjdbc/pgjdbc/issues/2949) PR #2953
- feat: support SET statements combining with other queries with semicolon in PreparedStatement [PR
##2973](https://github.com/pgjdbc/pgjdbc/pull/2973)
Fixed
- chore: add styleCheck Gradle task to report style violations [PR
#2980](https://github.com/pgjdbc/pgjdbc/pull/2980)
- fix: Include currentXid in "Error rolling back prepared transaction" exception message [PR
#2978](https://github.com/pgjdbc/pgjdbc/pull/2978)
- fix: add varbit as a basic type inside the TypeInfoCache [PR
#2960](https://github.com/pgjdbc/pgjdbc/pull/2960)
- fix: Fix failing tests for version 16. [PR
#2962](https://github.com/pgjdbc/pgjdbc/pull/2962)
- fix: allow setting arrays with ANSI type name [PR
#2952](https://github.com/pgjdbc/pgjdbc/pull/2952)
- feat: Use KeepAlive to confirm LSNs [PR
#2941](https://github.com/pgjdbc/pgjdbc/pull/2941)
- fix: put double ' around log parameter [PR
#2936](https://github.com/pgjdbc/pgjdbc/pull/2936) fixes ISSUE #2935
- fix: Fix Issue #2928 number of ports not equal to number of servers in datasource [PR
#2929](https://github.com/pgjdbc/pgjdbc/pull/2929)
- fix: Use canonical DateStyle name (#2925) fixes
- fix: Method getFastLong should be able to parse all longs [PR
#2881](https://github.com/pgjdbc/pgjdbc/pull/2881)
- docs: Fix typos in info.html [PR
#2860](https://github.com/pgjdbc/pgjdbc/pull/2860)
- fix: Return correct default from PgDatabaseMetaData.getDefaultTransactionIsolation [PR
#2992](https://github.com/pgjdbc/pgjdbc/pull/2992) fixes Issue #2991
- test: fix assertion in RefCursorFetchTestultFetchSize rows
- test: use try-with-resources in LogicalReplicationStatusTest
Changed
- fix: use PhantomReferences instead of
Obejct.finalize()to track Connection leaks [PR
#2847](https://github.com/pgjdbc/pgjdbc/pull/2847)
The change replaces all uses of Object.finalize with PhantomReferences. The leaked resources (Connections) are tracked in a helper thread that is active as long as there are connections in use. By default, the thread keeps running for 30 seconds after all the connections are released. The timeout is set with pgjdbc.config.cleanup.thread.ttl system property.
- refactor:(loom) replace the usages of synchronized with ReentrantLock PR #2635 Fixes Issue #1951
Fixed
- fix: fix testGetSQLTypeQueryCache by searching for xid type. We used to search for box type but it is now cached. xid is not cached, this nuance is required for the test.
- fix OidValueCorrectnessTest BOX_ARRAY OID, by adding BOX_ARRAY to the oidTypeName map [PR #2810]((https://github.com/pgjdbc/pgjdbc/pull/2810).
- fixes [Issue
#2804](https://github.com/pgjdbc/pgjdbc/issues/2804).
- fix: Make sure that github CI runs tests on all [PRs
#2809]((https://github.com/pgjdbc/pgjdbc/pull/2809\)).
Fixed
- fix: Add box to TypeInfoCache, fixes [Issue
#2746](https://github.com/pgjdbc/pgjdbc/issues/2746) PR #2747
- fix: regression in PgResultSet LONG_MIN copy and paste error fixes Issue #2748 PR#2749
Changed
- regression: This release has 2 known regressions which make it unusable see the notes above. We advise people to use 42.5.3 instead.
- docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes #Issue 2671 [PR
#2686](https://github.com/pgjdbc/pgjdbc/pull/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](https://github.com/pgjdbc/pgjdbc/pull/2700)
- feat: Define binary transfer for custom types dynamically/automatically fixes [Issue
#2554](https://github.com/pgjdbc/pgjdbc/issues/2554) PR #2556
Added
- fix: added gssResponseTimeout as part of [PR
#2687](https://github.com/pgjdbc/pgjdbc/pull/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](https://github.com/pgjdbc/pgjdbc/pull/2682)
- fix: Make sure socket is closed if an exception is thrown in createSocket fixes [Issue
#2684](https://github.com/pgjdbc/pgjdbc/issues/2684) PR #2685
- fix: Apply patch from [Issue
#2683](https://github.com/pgjdbc/pgjdbc/issues/2683) to fix hanging ssl connections PR #2687
- fix - binary conversion of (very) long numeric values (longer than 4 * 2^15 digits) [PR
#2697](https://github.com/pgjdbc/pgjdbc/pull/2697) fixes Issue #2695
- minor: enhance readability connection of startup params [PR
#2705](https://github.com/pgjdbc/pgjdbc/pull/2785)
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](https://github.com/pgjdbc/pgjdbc/issues/2552)
- fix: binary decoding of bool values [PR
#2640](https://github.com/pgjdbc/pgjdbc/pull/2640)
- perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns [PR
#2634](https://github.com/pgjdbc/pgjdbc/pull/2634)
- chore: fix various spelling errors [PR
#2592](https://github.com/pgjdbc/pgjdbc/pull/2592)
- chore: Feature/urlparser improve URLParser [PR
#2641](https://github.com/pgjdbc/pgjdbc/pull/2592)
Changed
- fix: revert change in [PR
#1986](https://github.com/pgjdbc/pgjdbc/pull/1986) where float was aliased to float4 from float8. float now aliases to float8 PR #2598 fixes Issue #2597
Changed
- fix: add alias to the generated getUDT() query for clarity (PR #2553)[https://github.com/pgjdbc/pgjdbc/pull/2553]
Added
- fix: make setObject accept UUID array [PR
#2587](https://github.com/pgjdbc/pgjdbc/pull/2587)
Fixed
- fix: regression with GSS. Changes introduced to support building with Java 17 caused failures [Issue
#2588](https://github.com/pgjdbc/pgjdbc/issues/2588)
- fix: set a timeout to get the return from requesting SSL upgrade. [PR
#2572](https://github.com/pgjdbc/pgjdbc/pull/2572)
- feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads)
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
- feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads)
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](https://github.com/pgjdbc/pgjdbc/pull/2425)
Fixed
- fix: queries with up to 65535 (inclusive) parameters are supported now (previous limit was 32767) PR #2525, [Issue
#1311](https://github.com/pgjdbc/pgjdbc/issues/1311)
- fix: workaround JarIndex parsing issue by using groupId/artifactId-version directory namings. Regression since 42.2.13. [PR
#2531](https://github.com/pgjdbc/pgjdbc/pull/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](https://github.com/pgjdbc/pgjdbc/pull/2520) Issue #2522
- perf: utcTz static and renamed to UTC_TIMEZONE [PR
#2519](https://github.com/pgjdbc/pgjdbc/pull/2520)
- doc: fix release version for #2377 (it should be 42.3.6, not 42.3.5)
square/okio (com.squareup.okio:okio)
2024-09-12
- Fix: Support paths containing a single dot (".") in
Path.relativeTo. - Fix: Do not read from the upstream source when a 0-byte read is requested.
- Fix: Update kotlinx.datetime to 0.6.0 to correct a Gradle module metadata problem with 0.5.0. Note: this artifact is only used in 'okio-fakefilesystem' and 'okio-nodefilesystem' and not in the Okio core.
mockito/mockito (org.mockito:mockito-core)
v5.14.1
Changelog generated by Shipkit Changelog Gradle Plugin
5.14.1
- 2024-09-30 - 2 commit(s) by Brice Dutheil, dependabot[bot]
- fix: gradle mockitoAgent configuration should not be transitive (#3454)
- Bump bytebuddy from 1.15.2 to 1.15.3 (#3452)
- Allow for installing a Java agent within the Mockito jar, without exposing Byte Buddy's attach mechanism. (#3437)
v5.14.0
Changelog generated by Shipkit Changelog Gradle Plugin
5.14.0
- 2024-09-27 - 9 commit(s) by Ali-Hassan, Brice Dutheil, David Saff, Rafael Winterhalter, dependabot[bot]
- Bump org.junit.platform:junit-platform-launcher from 1.11.0 to 1.11.1 (#3451)
- Bump bytebuddy from 1.15.1 to 1.15.2 (#3450)
- Update Documentation of ArgumentCaptor.java (#3448)
- Split subprojects (#3447)
- Separate extensions from integration tests (#3443)
- Bump org.eclipse.platform:org.eclipse.osgi from 3.20.0 to 3.21.0 (#3440)
- Bump com.gradle.enterprise from 3.18 to 3.18.1 (#3439)
- Allow for installing a Java agent within the Mockito jar, without exposing Byte Buddy's attach mechanism. (#3437)
- Bump bytebuddy from 1.15.0 to 1.15.1 (#3434)
- Fixes #3419: Disable mocks with an error message (#3424)
- Accessing a mock after clearInlineMocks could provide much more useful error message. (#3419)
Kotlin/kotlinx.coroutines (org.jetbrains.kotlinx:kotlinx-coroutines-core)
Features
- Wasm/WASI target support (#4064).
Thanks, @igoriakovlev!
limitedParallelismnow optionally accepts the name of the dispatcher view for easier debugging (#4023).- No longer initialize
Dispatchers.IOon the JVM when other standard dispatchers are accessed (#4166).
Thanks, @metalhead8816!
- Introduced the
Flow<T>.chunked(size: Int): Flow<List<T>>operator that groups emitted values into groups of the given size (#1290). - Closeable dispatchers are instances of
AutoCloseablenow (#4123).
Fixes
- Calling
hasNexton aChannel's iterator is idempotent (#4065).
Thanks, @gitpaxultek!
CoroutineScope()created without an explicit dispatcher usesDispatchers.Defaulton Native (#4074).
Thanks, @whyoleg!
- Fixed a bug that prevented non-Android
Dispatchers.Mainfrom initializing when the Firebase dependency is used (#3914). - Ensured a more intuitive ordering of tasks in
runBlocking(#4134). - Forbid casting a
MutextoSemaphore(#4176). - Worked around a stack overflow that may occur when calling
asDeferredon aFuturemany times (#4156).
Deprecations and promotions
- Advanced the deprecation levels for
BroadcastChannel-based API (#4197). - Advanced the deprecation levels for the old
kotlinx-coroutines-testAPI (#4198). - Deprecated
Job.cancelFutureOnCompletion(#4173). - Promoted
CoroutineDispatcher.limitedParallelismto stable (#3864). - Promoted
CoroutineStart.ATOMICfromExperimentalCoroutinesApitoDelicateCoroutinesApi(#4169). - Promoted
CancellableContinuation.resumewith anonCancellationlambda to stable, providing extra arguments to the lambda (#4088). - Marked the classes and interfaces that are not supposed to be
inherited from with the new
InternalForInheritanceCoroutinesApiopt-in (#3770). - Marked the classes and interfaces inheriting from which is not stable
with the new
ExperimentalForInheritanceCoroutinesApiopt-in (#3770).
Other
- Kotlin was updated to 2.0 (#4137).
- Reworked the documentation for
CoroutineStartandChannel-based API (#4147,
#4148, #4167). Thanks, @globsterg!
- Simplified the internal implementation of
Job(#4053). - Small tweaks, fixes, and documentation improvements.
redis/jedis (redis.clients:jedis)
v5.2.0:
5.2.0 GA
Enhanced Client-side caching
We are happy to announce that improved server-assisted, client-side caching is now generally available! Special thanks to all our beta testers for their valuable feedback, which helped us refine and improve the initial implementation.
Client-side caching is supported exclusively with the RESP3 protocol with Redis >= 7.4 and is available in UnifiedJedis, JedisPooled, and JedisCluster and other classes.
How to try Client-Side Caching
- Install Jedis 5.2.0
- Use the following code example to get started:
public class CSCExampleTest {
public static void main() {
HostAndPort node = HostAndPort.from("localhost:6379");
JedisClientConfig clientConfig = DefaultJedisClientConfig.builder()
.resp3() // RESP3 protocol is required for client-side caching
//.user("myuser") // Redis server username (optional)
//.password("mypass") // Redis user's password (optional)
.build();
CacheConfig cacheConfig = getCacheConfig();
Cache cache = CacheFactory.getCache(cacheConfig);
try (UnifiedJedis client = new UnifiedJedis(node, clientConfig, cache)) {
client.set("foo", "bar");
client.get("foo");
client.get("foo"); // Cache hit
System.out.println("Cache size: " + cache.getSize()); // 1
System.out.println(cache.getStats().toString());
//Let's change the value of "foo" to invalidate the value stored in the local cache
client.mset("foo", "new_value", "ignore_me:1", "another_value");
Thread.sleep(1000); // wait for the cache invalidation to happen
System.out.println(client.get("foo")); // Cache miss
System.out.println(cache.getStats().toString());
client.get("ignore_me:1"); // Client will ignore this key
System.out.println("Cache size: " + cache.getSize()); // still 1
// check the cache stats
System.out.println(cache.getStats().toString());
} catch (InterruptedException e) {
throw new RuntimeException(e);
}
}
private static CacheConfig getCacheConfig() {
// This is a simple cacheable implementation that ignores keys starting with "ignore_me"
Cacheable cacheable = new DefaultCacheable() {
final String IGNORE_PREFIX = "ignore_me";
@​Override
public boolean isCacheable(ProtocolCommand command, List<Object> keys) {
// assuming we'll only execute methods with string keys
List<String> stringKeys = keys.stream()
.filter(obj -> obj instanceof String)
.map(obj -> (String) obj)
.collect(Collectors.toList());
for (String key : stringKeys) {
if (key.startsWith(IGNORE_PREFIX)) {
return false;
}
}
return isDefaultCacheableCommand(command);
}
};
// Create a cache with a maximum size of 10000 entries
return CacheConfig.builder()
.maxSize(10000)
.cacheable(cacheable)
.build();
}
}It is possible to limit or ignore commands or keys for client-side
caching. The getCacheConfig method presented above provides an example
of how to achieve that.
🔥 Breaking Changes
- JedisConnectionException contains HostAndPort from DefaultJedisSocketFactory (#3896)
- Address change in JSON.GET command without path (#3858)
- Modify and fail-fast GeoSearchParam (#3827)
- Support transaction from UnifiedJedis without calling multi first (#3804)
- Reduce the log level of validateObject to WARN (#3750)
🧪 Experimental Features
- Support automatic namespacing (#3781)
- Added support for ADDSCORES argument in FT.AGGREGATE (#3908)
- Support IGNORE and other optional arguments for timeseries commands (#3860)
🚀 New Features
- Support Hash field expiration (#3826)
- Add equals and hashCode to Timeseries Params classes (#3959)
- Decoding FT.SEARCH reply can be disabled at field level (#3926)
- Get enriched Connection information (#3745)
- Support execute the read-only command on replica nodes (#3848)
- JedisConnectionException contains HostAndPort from DefaultJedisSocketFactory (#3896)
- Support [S]PUBLISH in pipelines and transactions (#3859)
- Support Hash field expiration (#3826)
- Custom connection pool to MultiClusterPooledConnectionProvider (#3801)
- PubSub handle array of messages for RESP2 (#3811)
- Support transaction from UnifiedJedis without calling multi first (#3804)
- Add last entry id for XREADs and support XREADs reply as map (#3791)
- Add Experimental, Internal and VisibleForTesting annotations (#3790)
- Implement equals and hashcode in Params classes (#3728)
- Add support for redis command: CLIENT TRACKINGINFO (#3751)
- Support the MAXAGE option for CLIENT KILL (#3754)
- Polish #3741 (#3746)
- Add support for the NOVALUES option of HSCAN (#3741)
- Support issuing Latency commands (#3729)
🐛 Bug Fixes
- Accept null replies for BZPOPMAX and BZPOPMIN commands (#3930)
- Fix empty LUA table reply (#3924)
- Ensure closing connection in Pipeline (#3865)
- Address change in JSON.GET command without path (#3858)
- Consider null values in empty StreamPendingSummary (#3793)
- Fix UnifiedJedis pexpireAt glitch (#3782)
- Use expiryOption in PipelineBase.expireAt (#3777)
- Stop connection fetching before sync/exec (#3756)
- Check for thread interrupt in subscribe process of PubSub (#3726)
- Avoid NPE in MultiNodePipelineBase.java (#3697)
- Fix probable missing (RESP3) protocol processing (#3692)
- Use circuit breaker fallback exception list (#3664)
🧰 Maintenance
- Deprecate Triggers and Functions feature (#3968)
- Bump org.apache.httpcomponents.client5:httpclient5-fluent from 5.3.1 to 5.4 (#3962)
- Bump org.apache.maven.plugins:maven-surefire-plugin from 3.3.1 to 3.5.0 (#3950)
- Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.8.0 to 3.10.0 (#3949)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.2.5 to 3.2.6 (#3957)
- Added JavaDoc for basic JedisCluster constructors (#3304)
- Bump org.locationtech.jts:jts-core from 1.19.0 to 1.20.0 (#3948)
- Add A-A failover scenario test (#3935)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.2.4 to 3.2.5 (#3936)
- Fix codecov upload (#3933)
- Rename readonly config param to specify Redis Cluster (#3932)
- Modify Connection.toIdentityString and test (#3931)
- Revert "Creating CODEOWNERS for the examples (#3570)"
(#3897)
- Bump org.apache.maven.plugins:maven-surefire-plugin from 3.2.5 to 3.3.1 (#3891)
- Bump org.hamcrest:hamcrest from 2.2 to 3.0 (#3914)
- Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.7.0 to 3.8.0 (#3909)
- Bump net.javacrumbs.json-unit:json-unit from 2.38.0 to 2.40.1 (#3903)
- Bump org.apache.maven.plugins:maven-release-plugin from 3.0.1 to 3.1.1 (#3890)
- Fixed typo in Javadoc (#3917)
- Bump org.apache.maven.plugins:maven-jar-plugin from 3.4.1 to 3.4.2 (#3910)
- Bump com.kohlschutter.junixsocket:junixsocket-core from 2.9.1 to 2.10.0 (#3901)
- Bump jackson.version from 2.17.1 to 2.17.2 (#3902)
- Add Scenario tests (#3847)
- Modify the judgment that reads a response as empty to isEmpty method (#3888)
- Replace
synchronizedwithj.u.c.l.ReentrantLockfor Loom (#3480) - Extract messages of unsupported exception as constants (#3887)
- Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.6.3 to 3.7.0 (#3851)
- Bump org.sonatype.plugins:nexus-staging-maven-plugin from 1.6.13 to 1.7.0 (#3850)
- Bump com.google.code.gson:gson from 2.10.1 to 2.11.0 (#3842)
- Merge doc tests into main branch to keep in-sync with the code (#3861)
- Deprecate unused Set builders (#3857)
- Disable Redis Graph tests (#3856)
- Introduce EndpointConfig and load endpoint settings from the endpoints.json file (#3836)
- Address Gears test fail - Cleanup Function libraries (#3840)
- Bump jackson.version from 2.17.0 to 2.17.1 (#3833)
- Add methods in CommandArguments and RawableFactory (#3834)
- Modify and fail-fast GeoSearchParam (#3827)
- Bump org.apache.maven.plugins:maven-jar-plugin from 3.4.0 to 3.4.1 (#3822)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.2.3 to 3.2.4 (#3823)
- Bump org.apache.maven.plugins:maven-jar-plugin from 3.3.0 to 3.4.0 (#3819)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.2.2 to 3.2.3 (#3818)
- Add more tests for the CommandObjects class (#3809)
- Resolve compile warnings (#3810)
- Bump com.kohlschutter.junixsocket:junixsocket-core from 2.9.0 to 2.9.1 (#3806)
- Bump org.jacoco:jacoco-maven-plugin from 0.8.11 to 0.8.12 (#3805)
- Bump org.apache.maven.plugins:maven-source-plugin from 3.3.0 to 3.3.1 (#3807)
- Deprecate unused JSON.ARRAPPEND in CommandObjects (#3798)
- Extensive unit tests for the CommandObjects class (#3796)
- Add extensive tests for UnifiedJedis (#3788)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.2.1 to 3.2.2 (#3794)
- Add Experimental, Internal and VisibleForTesting annotations (#3790)
- Add TS.INFO [DEGUB] and CF.MEXISTS in pipelined commands (#3787)
- Bump org.apache.maven.plugins:maven-compiler-plugin from 3.12.1 to 3.13.0 (#3786)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.2.0 to 3.2.1 (#3785)
- Pipelined tests for lists and sets, and API typo fix (#3772)
- Extensive unit tests for PipeliningBase (#3778)
- Bump jackson.version from 2.16.2 to 2.17.0 (#3776)
- Bump org.apache.maven.plugins:maven-gpg-plugin from 3.1.0 to 3.2.0 (#3775)
- Fix typo in SetPipelineCommands method name (#3773)
- Streamline test execution (#3760)
- Add pipelined tests for sorted sets (#3771)
- Geo pipelined tests (#3767)
- Reenable clustering tests (#3764)
- GETSET command is deprecated since Redis 6.2.0 (#3768)
- Add tests for Stream pipelined commands (#3763)
- Bump jackson.version from 2.16.1 to 2.16.2 (#3762)
- Bump org.json:json from
2024020to2024030(#3752) - Add Hashes pipeline commands unit tests (#3288)
- Add unit tests for pipelining - migrate and db commands (#3759)
- Reduce the log level of validateObject to WARN (#3750)
- Bump org.json:json from
2023101to2024020(#3706) - Bump com.kohlschutter.junixsocket:junixsocket-core from 2.8.3 to 2.9.0 (#3724)
- Running doctests also on emb-examples ([#&
GitOrigin-RevId: 8a275b1c484ffdcd889591afa909c0ac94f02667