Releases · pgjdbc/pgjdbc

@davecramer

Changes

Prepare release notes for release 42_7_6 (new format) @davecramer (#3628)
fix: isValid incorrectly called execute, instead of executeWithFlags fixes Issue #3630 @davecramer (#3631)
add override @davecramer (#3629)
add the ability to turn off automatic LSN flush @davecramer (#3403)
test: add tests with reWriteBatchedInserts=true @vlsi (#3616)
test: add CI executions with adaptive_fetch=true by default @vlsi (#3615)
test: simplify TestUtil.openDB, add tests with various assumeMinServerVersion values @vlsi (#3614)
Deprecate group startup parms @davecramer (#3613)
Add back application name setting @joejensen (#3509)
Copr: Use Java 21 as the build dependency @mkoncek (#3607)
fix indentation of return child to allow built pass in Checkstyle's CIs @mohitsatr (#3611)
Set column name explicitely when using current_database() in queries @kneth (#3526)
add PgMessageType and use static variables for protocol literals @davecramer (#3609)
Handle protocol 3.2 and wider cancel keys. @davecramer (#3592)
refactor empty resultset to use empty result set if the catalog is not correct @davecramer (#3588)
Use query to find the current catalog instead of relying on the database in the connection URL or connection properties as this could be different if connected through a pooler or proxy @davecramer (#3565)
ci: add Java 24 tests @davecramer (#3580)
docs: Relabel 42.7.4 as past version as it is no longer the latest @sehrope (#3586)
test: remove stale logging message from SslTest @vlsi (#3584)
chore: appply the latest byte-buddy version for tests so we support the latest Java versions @vlsi (#3583)
fix: make PgConnection#abort compatible with Java 24 @vlsi (#3582)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.8.5 @renovate-bot (#3573)
Fix JavadocTagContinuationIndentation in AfterBeforeParameterResolver @Anmol202005 (#3566)
Revert "use in row values instead of union all (#3510)" @vlsi (#3524)
use in row values instead of union all @davecramer (#3510)
feat: enhanced DatabaseMetadata.getIndexInfo() method, added index comment as REMARKS property @raminorujov (#3513)
Nit: correct message in main.yml test action @ecki (#3503)
chore: use import instead of require to support modern NodeJS @vlsi (#3502)
chore: use PostgreSQL 17 rather than 17rc1 for CI tests @vlsi (#3501)
chore: add ErrorProne verification to catch bugs ealier @vlsi (#3493)
fix: ArrayIndexOutOfBounds when write big object into GSS enabled connection, make GSSInputStream robust in face of streams that produce incomplete reads @vlsi (#3500)
refactor: factor out duplicated .getBytes() when converting date/time to Date/Time/Timestamp @vlsi (#3497)
chore: exclude Oracle Java 17 from CI tests @vlsi (#3499)
chore: remove unused Travis CI configuration @vlsi (#3498)
Undeprecate sslfactoryarg connection property @sehrope (#3496)
fix:Fix sending extra_float_digits @davecramer (#3491)

🐛 Bug Fixes

fix: EOFException on PreparedStatement#toString with unset bytea parameter since 42.7.4 @MrEasy (#3369)

🧰 Maintenance

chore: use Java 21 for building pgjdbc by default @vlsi (#3612)

⬆️ Dependencies

55 changes

chore(deps): update burrunan/gradle-cache-action action to v3 @renovate-bot (#3626)
chore(deps): update plugin com.gradle.develocity to v4 @renovate-bot (#3627)
fix(deps): update dependency org.openrewrite.rewrite:org.openrewrite.rewrite.gradle.plugin to v7.5.0 @renovate-bot (#3624)
fix(deps): update dependency net.ltgt.errorprone:net.ltgt.errorprone.gradle.plugin to v4.2.0 @renovate-bot (#3623)
fix(deps): update checkerframework to v3.49.3 @renovate-bot (#3618)
fix(deps): update dependency checkstyle to v10.23.1 @renovate-bot (#3619)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.10 @renovate-bot (#3620)
chore(deps): update dependency gradle to v8.14 @renovate-bot (#3621)
chore(deps): update codecov/codecov-action digest to ad3126e @renovate-bot (#3603)
fix(deps): update dependency net.bytebuddy:byte-buddy-parent to v1.17.5 @renovate-bot (#3596)
fix(deps): update dependency org.openrewrite.rewrite:org.openrewrite.rewrite.gradle.plugin to v7.4.1 @renovate-bot (#3602)
fix(deps): update dependency org.junit:junit-bom to v5.12.2 @renovate-bot (#3597)
fix(deps): update dependency jacoco to v0.8.13 @renovate-bot (#3595)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.9.0 @renovate-bot (#3598)
fix(deps): update dependency checkstyle to v10.23.0 @renovate-bot (#3599)
fix(deps): update dependency de.thetaphi.forbiddenapis:de.thetaphi.forbiddenapis.gradle.plugin to v3.9 @renovate-bot (#3600)
chore(deps): update codecov/codecov-action digest to f95a404 @renovate-bot (#3593)
fix(deps): update checkerframework @renovate-bot (#3594)
fix(deps): update dependency org.checkerframework:org.checkerframework.gradle.plugin to v0.6.52 @renovate-bot (#3576)
chore(deps): update dependency sbt/sbt to v1.10.11 @renovate-bot (#3571)
chore(deps): update oracle-actions/setup-java action to v1.4.1 @renovate-bot (#3572)
fix(deps): update dependency spotbugs to v4.9.3 @renovate-bot (#3577)
fix(deps): update dependency org.openrewrite.rewrite:org.openrewrite.rewrite.gradle.plugin to v7.3.0 @renovate-bot (#3579)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2.1.20 @renovate-bot (#3574)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.7 @renovate-bot (#3575)
chore(deps): update codecov/codecov-action digest to 3440e5e @renovate-bot (#3569)
chore(deps): update dependency com.typesafe.play:sbt-plugin to v2.9.7 @renovate-bot (#3570)
chore(deps): update dependency sbt/sbt to v1.10.10 @renovate-bot (#3554)
fix(deps): update dependency checkstyle to v10.21.4 @renovate-bot (#3555)
fix(deps): update dependency spotbugs to v4.9.2 @renovate-bot (#3556)
fix(deps): update dependency org.openrewrite.rewrite:org.openrewrite.rewrite.gradle.plugin to v7 @renovate-bot (#3553)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.36.0 @renovate-bot (#3547)
fix(deps): update dependency org.hamcrest:hamcrest to v3 @renovate-bot (#3552)
chore(deps): update dependency ubuntu to v24 @renovate-bot (#3550)
fix(deps): update dependency net.ltgt.errorprone:net.ltgt.errorprone.gradle.plugin to v4 @renovate-bot (#3551)
fix(deps): update checkerframework @renovate-bot (#3546)
chore(deps): update dependency sbt/sbt to v1.10.9 @renovate-bot (#3548)
chore(deps): update dependency gradle to v8.13 @renovate-bot (#3544)
fix(deps): update checkerframework @renovate-bot (#3545)
chore(deps): update codecov/codecov-action digest to 0565863 @renovate-bot (#3537)
chore(deps): update plugin com.gradle.develocity to v3.19.2 @renovate-bot (#3538)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.6 @renovate-bot (#3539)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.24 @renovate-bot (#3540)
chore(deps): update plugin me.champeau.jmh to v0.7.3 @renovate-bot (#3518)
fix(deps): update dependency org.ops4j.pax.url:pax-url-aether to v2.6.16 @renovate-bot (#3487)
chore(deps): update dependency gradle to v8.12.1 @renovate-bot (#3517)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2.1.10 @renovate-bot (#3519)
fix(deps): update dependency checkstyle to v10.21.3 @renovate-bot (#3520)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.4 @renovate-bot (#3521)
chore(deps): update codecov/codecov-action digest to 5efa07b @renovate-bot (#3516)
fix(deps): update checkerframework @renovate-bot (#3485)
chore(deps): update codecov/codecov-action digest to 0da7aa6 @renovate-bot (#3484)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.2 @renovate-bot (#3486)
fix(deps): update dependency checkstyle to v10.21.1 @renovate-bot (#3489)
chore(deps): update plugin com.gradle.develocity to v3.19.1 @renovate-bot (#3488)

What's Changed

fix:Fix sending extra_float_digits by @davecramer in #3491
chore(deps): update plugin com.gradle.develocity to v3.19.1 by @renovate-bot in #3488
Undeprecate sslfactoryarg connection property by @sehrope in #3496
fix(deps): update dependency checkstyle to v10.21.1 by @renovate-bot in #3489
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.2 by @renovate-bot in #3486
chore(deps): update codecov/codecov-action digest to 0da7aa6 by @renovate-bot in #3484
chore: remove unused Travis CI configuration by @vlsi in #3498
chore: exclude Oracle Java 17 from CI tests by @vlsi in #3499
refactor: factor out duplicated .getBytes() when converting date/time to Date/Time/Timestamp by @vlsi in #3497
fix: ArrayIndexOutOfBounds when write big object into GSS enabled connection, make GSSInputStream robust in face of streams that produce incomplete reads by @vlsi in #3500
chore: add ErrorProne verification to catch bugs ealier by @vlsi in #3493
fix(deps): update checkerframework by @renovate-bot in #3485
chore: use PostgreSQL 17 rather than 17rc1 for CI tests by @vlsi in #3501
chore: use import instead of require to support modern NodeJS by @vlsi in http...

@davecramer

Changes

update changelogs and increment version in gradle.properties for release @davecramer (#3478)
regression: revert change in fc60537 @davecramer (#3476)
Fix PgDatabaseMetaData implementation of catalog as param and return value @SophiahHo (#3390)
Support default GSS credentials in the Java Postgres client @nrhall (#3451)
fix: return only the transactions accessible by the current_user in XAResource.recover @vlsi (#3450)
feat: don't force send extra_float_digits for PostgreSQL >= 12 (#3432) @damienb-opt (#3446)
fix: exclude "include columns" from the list of primary keys @priteshranjan01 (#3434)
Enhance the meta query performance by specifying the oid. @dh-cloud (#3427)
feat: support getObject(int, byte[].class) for bytea @anesterenok (#3274)
docs: document infinity and some minor edits @davecramer (#3407)
Added way to check for major server version, fixed check for RULE @davecramer (#3402)
fixed remaining paragraphs @Zopsss (#3398)
fixed paragraphs in javadoc comments @Zopsss (#3397)
Reuse buffers and reduce allocations in GSSInputStream addresses Issue #3251 @davecramer (#3255)
chore: Update Gradle to 8.10.2 @jorsol (#3388)
ci: Test with Java 23 @jorsol (#3381)
Fix getSchemas() @SophiahHo (#3386)
Update rpm postgresql-jdbc.spec.tpl with scram-client @jorsol (#3324)
Clearing thisRow and rowBuffer on close() of ResultSet @reallyinsane (#3384)
Package was renamed to maven-bundle-plugin @ljavorsk (#3382)
As of version 18 the RULE privilege has been removed @davecramer (#3378)
fix: use buffered inputstream to create GSSInputStream @Sasasu (#3373)
get rid of 8.4, 9.0 pg versions and use >= jdk version 17 @davecramer (#3372)
Changed docker-compose version and renamed script file in instructions to match the real file name @MohanadKh03 (#3363)
Do not assume "test" database in DatabaseMetaDataTransactionIsolationTest @nvanbenschoten (#3364)
try to categorize dependencies @davecramer (#3362)

⬆️ Dependencies

32 changes

chore(deps): update dependency gradle to v8.12 @renovate-bot (#3473)
chore(deps): update codecov/codecov-action digest to adfacf2 @renovate-bot (#3468)
chore(deps): update dependency sbt/sbt to v1.10.7 @renovate-bot (#3470)
fix(deps): update dependency org.ops4j.pax.url:pax-url-aether to v2.6.15 @renovate-bot (#3471)
fix(deps): update junit5 monorepo to v5.11.4 @renovate-bot (#3472)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.1.0 @renovate-bot (#3469)
chore(deps): update plugin biz.aqute.bnd.builder to v7.1.0 @renovate-bot (#3455)
chore(deps): update dependency gradle to v8.11.1 @renovate-bot (#3454)
chore(deps): update dependency com.typesafe.play:sbt-plugin to v2.9.6 @renovate-bot (#3452)
chore(deps): update dependency sbt/sbt to v1.10.6 @renovate-bot (#3453)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2.1.0 @renovate-bot (#3456)
chore(deps): update codecov/codecov-action digest to 015f24e @renovate-bot (#3438)
chore(deps): update dependency sbt/sbt to v1.10.5 @renovate-bot (#3439)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.8.4 @renovate-bot (#3440)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.26 @renovate-bot (#3441)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.23 @renovate-bot (#3442)
chore(deps): update burrunan/gradle-cache-action action to v2 @renovate-bot (#3422)
fix(deps): update dependency de.thetaphi.forbiddenapis:de.thetaphi.forbiddenapis.gradle.plugin to v3.8 @renovate-bot (#3418)
fix(deps): update dependency org.roaringbitmap:roaringbitmap to v1.3.0 @renovate-bot (#3419)
fix(deps): update junit5 monorepo to v5.11.3 @renovate-bot (#3420)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.34.0 @renovate-bot (#3417)
fix(deps): update dependency it.unimi.dsi:fastutil to v8.5.15 @renovate-bot (#3414)
chore(deps): update codecov/codecov-action digest to 2b8b0e7 @renovate-bot (#3410)
fix(deps): update dependency checkstyle to v10.18.2 @renovate-bot (#3415)
chore(deps): update dependency sbt/sbt to v1.10.3 @renovate-bot (#3411)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2.0.21 @renovate-bot (#3412)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.25 @renovate-bot (#3413)
chore(deps): update oracle-actions/setup-java action to v1.4.0 @renovate-bot (#3393)
chore(deps): update codecov/codecov-action digest to b9fd7d1 @renovate-bot (#3374)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2.0.20 @renovate-bot (#3375)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.24 @renovate-bot (#3376)
chore(deps): update dependency sbt/sbt to v1.10.2 @renovate-bot (#3392)

@davecramer

Changes

Prepare for 42.7.4 release @davecramer (#3359)
fix: remove preDescribe from internalExecuteBatch @vlsi (#2883)
bug report: PgInterval ignores case for represented interval string @vishalvrv9 (#3344)
switch localhost and auth-test around @davecramer (#3343)
Update to 17beta3 @davecramer (#3308)
perf: avoid extra copies when receiving int4 and int2 in PGStream @vishalvrv9 (#3295)
Replace greater to with greater than @japinli (#3315)
Deprecate all PostgreSQL versions older than 9.1 @jorsol (#3335)
use docker v2 which changes docker-compose to docker compose @davecramer (#3339)
docs: clarify binaryTransfer and prepareThreshold @Chris-SP365 (#3338)
Clean up deps licenses, as they are now included in the original JARs @jorsol (#3330)
Update SCRAM dependency to 3.1 and support channel binding @jorsol (#3188)
Update use.md, typo @hginzel (#3314)
Add support for Infinity::numeric values in ResultSet.getObject @mmm444 (#3304)
chore: implement direct SSL ALPN connections @davecramer (#3252)
Ensure order of results for getDouble @davecramer (#3301)
chore: add PostgreSQL 15, 16, and 17beta1 to CI tests @davecramer (#3299)
Test for +/- infinity double values @davecramer (#3294)
perf: replace BufferedOutputStream with unsynchronized PgBufferedOutputStream, allow configuring different Java and SO_SNDBUF buffer sizes @vlsi (#3248)
Fix SSL tests @davecramer (#3260)
Add Korean translation file @SheerazMajeedM (#3276)
fix: support bytea in preferQueryMode=simple @vlsi (#3243)
refactor: merge PgPreparedStatement#setBinaryStream int and long methods @lucifer-Technoking (#3165)
test: test both binaryMode=true,false when creating connections in DatabaseMetaDataTest @vlsi (#3231)
Fixed typos in all source code and documentations @SheerazMajeedM (#3242)
Fix #3234 - Return -1 as update count for stored procedure calls @beikov (#3235)
Fix #3224 - conversion for TIME '24:00' to LocalTime breaks in binary-mode @pmenke-de (#3225)
remove self-hosted runner @davecramer (#3227)
Speed up getDate by parsing bytes instead of String @davecramer (#3141)
fix: support PreparedStatement.setBlob(1, Blob) and PreparedStatement.setClob(1, Clob) for lobs that return -1 for length @vlsi (#3136)
correct download for jre7 @davecramer (#3198)
Docs: Add cancelSignalTimeout in README @imranzaheer612 (#3190)
Document READ_ONLY_MODE in README @ajacob98 (#3175)
validates resultsetParams in PGStatement constructor. uses assertThro… @vishalvrv9 (#3171)
validates resultset parameters @vishalvrv9 (#3167)
bump version to 42.7.4 @davecramer (#3164)

⬆️ Dependencies

53 changes

fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.20 @renovate-bot (#3353)
chore(deps): update dependency gradle to v8.10 @renovate-bot (#3354)
fix(deps): update dependency org.roaringbitmap:roaringbitmap to v1.2.1 @renovate-bot (#3358)
chore(deps): update codecov/codecov-action digest to 2439dfc @renovate-bot (#3355)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.30.0 @renovate-bot (#3356)
fix(deps): update dependency spotbugs to v4.8.6 @renovate-bot (#3350)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.20 @renovate-bot (#3290)
chore(deps): update dependency sbt/sbt to v1.10.1 @renovate-bot (#3312)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2.0.10 @renovate-bot (#3347)
chore(deps): update codecov/codecov-action digest to bb81333 @renovate-bot (#3345)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.8.3 @renovate-bot (#3346)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v2 @renovate-bot (#3272)
fix(deps): update dependency it.unimi.dsi:fastutil to v8.5.14 @renovate-bot (#3332)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.22 @renovate-bot (#3333)
chore(deps): update codecov/codecov-action digest to 6f75c27 @renovate-bot (#3328)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v1.9.25 @renovate-bot (#3329)
chore(deps): update dependency com.typesafe.play:sbt-plugin to v2.9.5 @renovate-bot (#3311)
chore(deps): update codecov/codecov-action digest to a06c39c @renovate-bot (#3310)
fix(deps): update dependency checkstyle to v10.17.0 @renovate-bot (#3268)
fix(deps): update dependency com.igormaznitsa:jcp to v7.1.2 @renovate-bot (#3291)
chore(deps): update dependency gradle to v8.8 @renovate-bot (#3293)
chore(deps): update codecov/codecov-action digest to 9a146cf @renovate-bot (#3292)
chore(deps): update codecov/codecov-action digest to e28ff12 @renovate-bot (#3288)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.8.2 @renovate-bot (#3289)
chore(deps): update ubuntu docker tag to v24 @renovate-bot (#3273)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.28.0 @renovate-bot (#3270)
fix(deps): update dependency org.openrewrite.rewrite:org.openrewrite.rewrite.gradle.plugin to v6.15.1 @renovate-bot (#3271)
chore(deps): update dependency sbt/sbt to v1.10.0 @renovate-bot (#3266)
chore(deps): update codecov/codecov-action digest to a1504ae @renovate-bot (#3261)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v1.9.24 @renovate-bot (#3262)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.15 @renovate-bot (#3263)
fix(deps): update dependency spotbugs to v4.8.5 @renovate-bot (#3264)
chore(deps): update actions/setup-java action to v4 @renovate-bot (#3055)
chore(deps): update actions/checkout action to v4 @renovate-bot (#3054)
fix(deps): update dependency org.openrewrite.rewrite:org.openrewrite.rewrite.gradle.plugin to v6.13.0 @renovate-bot (#3098)
fix(deps): update dependency de.thetaphi.forbiddenapis:de.thetaphi.forbiddenapis.gradle.plugin to v3.7 @renovate-bot (#3214)
chore(deps): update codecov/codecov-action digest to f691d46 @renovate-bot (#3238)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.14 @renovate-bot (#3239)
chore(deps): update gradle/wrapper-validation-action action to v3 @renovate-bot (#3217)
chore(deps): update codecov/codecov-action digest to 86801cd @renovate-bot (#3216)
fix(deps): update dependency jacoco to v0.8.12 @renovate-bot (#3209)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.21 @renovate-bot (#3210)
chore(deps): update dependency gradle to v8.7 @renovate-bot (#3212)
fix(deps): update dependency spotbugs to v4.8.4 @renovate-bot (#3211)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v1.9.23 @renovate-bot (#3208)
chore(deps): update plugin org.gradlex.build-parameters to v1.4.4 @renovate-bot (#3207)
chore(deps): update dependency sbt/sbt to v1.9.9 @renovate-bot (#3205)
chore(deps): update oracle-actions/setup-java action to v1.3.4 @renovate-bot (#3206)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6.0.12 @renovate-bot (#3202)
fix(deps): update dependency checkstyle to v10.15.0 @renovate-bot (#3203)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.26.1 @renovate-bot (#3204)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.8.1 @renovate-bot (#3094)
chore(deps): update codecov/codecov-action digest to 8dff894 @renovate-bot (#3179)

@davecramer

Changes

bump version to 42.7.4 @davecramer (#3164)
fix Issue boolean types not handled in SimpleQuery mode @davecramer (#3146)
The Gradle config enforces 17+ @OrangeDog (#3147)
Fix 2 changelog entry titles @crunchyjohn (#3142)
chore: ensure CI jobs include tests for all the values of preferQueryMode, ssl, xa, gss @vlsi (#3137)
update jdbc website security page with latest security advisory @davecramer (#3135)

@bokken

Security

CVE-2024-1597 and Security Advisory addressed. The vulnerability occurs only in non-default preferQueryMode=simple mode and only if a negative place holder -? is used. See the security advisory for details

What's Changed

perf: avoid autoboxing bind indexes by @bokken in #1244
add: Add PasswordUtil for encrypting passwords client side by @sehrope in #3082
refactor: document that encodePassword will zero out the password array, and remove driver's default encodePassword by @vlsi in #3084
change: Use simple query for isValid. Using Extended query sends two messages by @davecramer in #3101

Full Changelog: REL42.7.1...REL42.7.2

@vlsi

Fixed regressions since 42.7.0

Revert "Use canonical DateStyle name (#2925)" @vlsi (#3035)
Revert "feat: support SET statements combining with other queries with semicolon in PreparedStatement" @vlsi (#3010)
chore: use java.release=8 when building pgjdbc from the generated source distribution @vlsi (#3038), the driver uses Java 8 methods only

Changes

Apply connectTimeout before SSLSocket.startHandshake to avoid infinite wait in case the connection is broken @davecramer (#3040)
perf: improve performance of PreparedStatement.setBlob, BlobInputStream, and BlobOutputStream with dynamic buffer sizing @vlsi (#3044)
fix: avoid timezone conversions when sending LocalDateTime to the database @vlsi (#2852)
fix: support waffle-jna 2.x and 3.x by using reflective approach for ManagedSecBufferDesc @chrullrich (#2720)

🧰 Maintenance

chore: bump Gradle to 8.5 @vlsi (#3045)
chore: use Java 17 for building pgjdbc, and use --release 8 to target Java 8, add tests with Java 21 and 22 @vlsi (#3026)
fedora/rpm: move source build to java-17-openjdk-devel @praiskup (#3036)
Update site 42 7 0 @davecramer (#3004)
prepared for release 42.7.1 update changelogs @davecramer (#3037)

⬆️ Dependencies

28 changes

fix(deps): update dependency org.checkerframework:org.checkerframework.gradle.plugin to v0.6.36 @renovate-bot (#3060)
chore(deps): update plugin biz.aqute.bnd.builder to v7 @renovate-bot (#3034)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v6 @renovate-bot (#3056)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v5.2.5 @renovate-bot (#3032)
chore(deps): update codecov/codecov-action digest to b0466b4 @renovate-bot (#3059)
fix(deps): update checkerframework to v3.41.0 @renovate-bot (#3058)
fix(deps): update logback to v1.2.13 @renovate-bot (#3053)
chore(deps): update codecov/codecov-action digest to 438fa9e @renovate-bot (#3051)
fix(deps): update dependency spotbugs to v4.8.2 @renovate-bot (#3052)
chore: bump Gradle to 8.5 @vlsi (#3045)
fix(deps): update dependency org.ops4j.pax.url:pax-url-aether to v2.6.14 @renovate-bot (#3030)
chore(deps): update plugin org.nosphere.gradle.github.actions to v1.4.0 @renovate-bot (#3031)
chore(deps): update dependency ubuntu to v22 @renovate-bot (#3033)
fix(deps): update checkerframework @renovate-bot (#3027)
fix(deps): update dependency spotbugs to v4.8.1 @renovate-bot (#3023)
fix(deps): update dependency uk.org.webcompere:system-stubs-jupiter to v2.1.5 @renovate-bot (#3024)
fix(deps): update jmh to v1.37 @renovate-bot (#3025)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.23.0 @renovate-bot (#3022)
fix(deps): update junit5 monorepo to v5.10.1 @renovate-bot (#3015)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.7 @renovate-bot (#3016)
chore(deps): update dependency com.typesafe.play:sbt-plugin to v2.9.0 @renovate-bot (#3021)
fix(deps): update dependency checkstyle to v10.12.5 @renovate-bot (#3020)
chore(deps): update codecov/codecov-action digest to 920a494 @renovate-bot (#3019)
chore(deps): update actions/github-script action to v7 @renovate-bot (#3018)
chore(deps): update actions/checkout action to v4 @renovate-bot (#3017)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v1.9.21 @renovate-bot (#2921)
chore(deps): update com.github.vlsi to v1.90 @renovate-bot (#2982)
chore(deps): update plugin me.champeau.jmh to v0.7.2 @renovate-bot (#2986)

@davecramer

Known issues

NoSuchMethodError on ByteBuffer#position When Running on Java 8 when accessing arrays, issue #3014, fixed in 42.7.1
SET followed by SHOW in one statement returns wrong result, issue #3007, fixed in 42.7.1
42.7.0 updated DateStyle from ISO to ISO, MDY (it aligns with PostgreSQL defaults), and it result in wrong results when server uses non-default DateStyle (see #3008), fixed in 42.7.1

Changes

update website for 42.7.0 @davecramer (#3003)
Update changelog for release 42.7.0 @davecramer (#3001)
Use a switch statement to compare transaction isolation levels and let the database do the toUpper @davecramer (#2998)
feat: support SET statements combining with other queries with semicolon in PreparedStatement @ng-galien (#2973)
Return correct default from PgDatabaseMetaData.getDefaultTransactionIsolation @nvanbenschoten (#2992)
only create function if V14 or greater @davecramer (#2996)
Fix problem when calling a procedure returning a refcursor more than 5 times (prepareThreshold) @davecramer (#2988)
chore: add styleCheck Gradle task to report style violations @vlsi (#2980)
Include currentXid in exception message @gastaldi (#2978)
Deprecate for removal PGPoint.setLocation(java.awt.Point) to cut dependency to java.desktop module @desruisseaux (#2967)
feat: return all catalogs for getCatalogs metadata query (#2949) @pip25 (#2953)
fix: add varbit as a basic type inside the TypeInfoCache @fqazi (#2960)
Fix failing tests for version 16. @davecramer (#2962)
fix: allow setting arrays with ANSI type name @bremac (#2952)
added ADOPTERS.md @davecramer (#2951)
feat: Use KeepAlive to confirm LSNs @decmurphy (#2941)
put double ' around log parameter @davecramer (#2936)
Fix Issue #2928 number of ports not equal to number of servers in datasource @davecramer (#2929)
Use canonical DateStyle name @JelteF (#2925)
un-deprecate SSL_FACTORY_ARG @davecramer (#2923)
Method getFastLong should be able to parse all longs @zhurs (#2881)
fix: typos in info.html @maffe (#2860)
bump version for next release @davecramer (#2859)
rename changelog for 42.6.0 to the correct name @davecramer (#2858)

⬆️ Dependencies

29 changes

fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.19 @renovate-bot (#2993)
fix(deps): update dependency jacoco to v0.8.11 @renovate-bot (#2990)
fix(deps): update dependency checkstyle to v10.12.4 @renovate-bot (#2989)
chore(deps): update codecov/codecov-action digest to f4993f1 @renovate-bot (#2981)
chore(deps): update dependency gradle to v7.6.3 @renovate-bot (#2985)
chore(deps): update dependency sbt/sbt to v1.9.7 @renovate-bot (#2984)
chore(deps): update plugin com.github.johnrengelman.shadow to v8 @renovate-bot (#2917)
chore(deps): update dependency sbt/sbt to v1 @renovate (#2915)
chore(deps): update com.github.vlsi to v1.88 @renovate (#2907)
fix(deps): update dependency com.google.errorprone:error_prone_core to v2.19.1 @renovate (#2910)
fix(deps): update dependency net.ltgt.errorprone:net.ltgt.errorprone.gradle.plugin to v3.1.0 @renovate (#2913)
fix(deps): update dependency checkstyle to v10.12.0 @renovate (#2909)
chore(deps): update codecov/codecov-action digest to eaaf4be @renovate (#2906)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.6 @renovate (#2898)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v1.8.21 @renovate (#2890)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.17 @renovate (#2892)
fix(deps): update junit5 monorepo to v5.9.3 @renovate (#2893)
fix(deps): update dependency jacoco to v0.8.10 @renovate (#2891)
chore(deps): update plugin me.champeau.jmh to v0.7.1 @renovate (#2889)
chore(deps): update codecov/codecov-action digest to b4dfea7 @renovate (#2888)
chore(deps): update plugin com.github.vlsi.gettext to v1.87 @renovate (#2870)
fix(deps): update logback to v1.2.12 @renovate (#2868)
chore(deps): update plugin org.gradlex.build-parameters to v1.4.3 @renovate (#2865)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v5.0.14 @renovate (#2866)
chore(deps): update plugin com.github.vlsi.crlf to v1.87 @renovate (#2869)
chore(deps): update plugin com.github.vlsi.gradle-extensions to v1.87 @renovate (#2871)
chore(deps): update plugin com.github.vlsi.ide to v1.87 @renovate (#2872)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.16 @renovate (#2867)
chore(deps): update codecov/codecov-action digest to fee4896 @renovate (#2864)

@davecramer

Changes

bump version for next release @davecramer (#2859)
rename changelog for 42.6.0 to the correct name @davecramer (#2858)
Update CHANGELOG for release @davecramer (#2851)
Fix pks12docs @davecramer (#2857)
Remove stray whitespace and use code formatting @dennis-benzinger-hybris (#2854)

🚀 Features

fix: use PhantomReferences instead of Obejct.finalize to track Connection leaks @vlsi (#2847)
fix: reduce memory overhead of .finalize() methods in PgConnection and StreamWrapper @vlsi (#2817)
refactor:(loom) replace the usages of synchronized with ReentrantLock @rbygrave (#2635)

📝 Documentation

Update site for release 42.5.4 @davecramer (#2813)
Update docs to reflect changes from 42.5.3 @davecramer (#2811)
Add copy examples @davecramer (#2762)
added alias /about/license.html @davecramer (#2765)
re-add slonik duke image @davecramer (#2760)
show snapshot dir instead of xml @davecramer (#2759)
make changelogs more compact, only show the link to the changelog @davecramer (#2758)
edit changelogs to make them correct and readable @davecramer (#2743)

🧰 Maintenance

chore: fix usage of deprecated APIs in tests @vlsi (#2849)
test: increase timeouts for resolving Maven dependencies in OSGi tests @vlsi (#2848)
chore: pass "same hashcode" to test task only @vlsi (#2822)
chore: resolve jacocoReport failure @vlsi (#2820)
chore: configure Release Drafter to use releases from a single branch only @vlsi (#2819)
feat: add Release Drafter for preparing release notes on GitHub @vlsi (#2818)
Make sure that github CI runs tests on all PRs @davecramer (#2808)
fix: Update function volatility in SchemaTest setup @rafiss (#2806)
chore: split /build.gradle.kts to build-logic/ plugins @vlsi (#2755)
chore: tune down the number of CI jobs for PR builds from 7 to 5 @vlsi (#2761)

⬆️ Dependencies

57 changes

fix(deps): update dependency com.google.errorprone:error_prone_core to v2.19.1 @renovate (#2910)
fix(deps): update dependency net.ltgt.errorprone:net.ltgt.errorprone.gradle.plugin to v3.1.0 @renovate (#2913)
fix(deps): update dependency checkstyle to v10.12.0 @renovate (#2909)
chore(deps): update codecov/codecov-action digest to eaaf4be @renovate (#2906)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.6 @renovate (#2898)
chore(deps): update plugin org.jetbrains.kotlin.jvm to v1.8.21 @renovate (#2890)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.17 @renovate (#2892)
fix(deps): update junit5 monorepo to v5.9.3 @renovate (#2893)
fix(deps): update dependency jacoco to v0.8.10 @renovate (#2891)
chore(deps): update plugin me.champeau.jmh to v0.7.1 @renovate (#2889)
chore(deps): update codecov/codecov-action digest to b4dfea7 @renovate (#2888)
chore(deps): update plugin com.github.vlsi.gettext to v1.87 @renovate (#2870)
fix(deps): update logback to v1.2.12 @renovate (#2868)
chore(deps): update plugin org.gradlex.build-parameters to v1.4.3 @renovate (#2865)
fix(deps): update dependency com.github.spotbugs:com.github.spotbugs.gradle.plugin to v5.0.14 @renovate (#2866)
chore(deps): update plugin com.github.vlsi.crlf to v1.87 @renovate (#2869)
chore(deps): update plugin com.github.vlsi.gradle-extensions to v1.87 @renovate (#2871)
chore(deps): update plugin com.github.vlsi.ide to v1.87 @renovate (#2872)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.16 @renovate (#2867)
chore(deps): update codecov/codecov-action digest to fee4896 @renovate (#2864)
chore: bump classloader-leak-test-framework to 1.1.2 @vlsi (#2855)
chore(deps): update codecov/codecov-action digest to 13d8b07 @renovate (#2830)
chore(deps): update plugin me.champeau.jmh to v0.7.0 @renovate (#2831)
fix(deps): update dependency checkstyle to v10.8.1 @renovate (#2840)
chore: bump com.github.lburgazzoli.karaf to 0.5.6 to fix deprecations @vlsi (#2843)
chore(deps): update dependency sbt/sbt to v0.13.18 @renovate (#2839)
chore: reduce Renovate frequency to once every 3 weeks @vlsi (#2832)
chore(deps): bump Gradle to 8.0.1 @vlsi (#2821)
chore(deps): update codecov/codecov-action digest to 83bb3d0 @renovate (#2803)
fix(deps): update dependency org.checkerframework:checker-qual to v3.31.0 @renovate (#2816)
fix(deps): update dependency org.checkerframework:checker to v3.31.0 @renovate (#2815)
chore(deps): update ubuntu docker tag to v22 @renovate (#2795)
fix(deps): update dependency org.osgi:org.osgi.core to v6 @renovate (#2798)
fix(deps): update dependency javax:javaee-api to v8 @renovate (#2797)
chore(deps): update plugin org.owasp.dependencycheck to v8 @renovate (#2794)
chore(deps): update plugin com.github.johnrengelman.shadow to v7 @renovate (#2793)
fix(deps): update jmh to v1.36 @renovate (#2790)
fix(deps): update dependency spotbugs to v4.7.3 @renovate (#2789)
fix(deps): update dependency junit:junit to v4.13.2 @renovate (#2786)
fix(deps): update dependency org.checkerframework:checker-qual to v3.30.0 @renovate (#2787)
chore(deps): update plugin org.nosphere.gradle.github.actions to v1.3.2 @renovate (#2784)
fix(deps): update dependency de.thetaphi.forbiddenapis:de.thetaphi.forbiddenapis.gradle.plugin to v3.4 @renovate (#2785)
chore(deps): update plugin biz.aqute.bnd.builder to v6.4.0 @renovate (#2781)
chore(deps): update plugin com.github.johnrengelman.shadow to v5.2.0 @renovate (#2782)
chore(deps): update plugin com.github.burrunan.s3-build-cache to v1.5 @renovate (#2780)
fix(deps): update dependency jacoco to v0.8.8 @renovate (#2777)
chore(deps): update dependency com.typesafe.play:sbt-plugin to v2.8.19 @renovate (#2779)
fix(deps): update dependency org.codehaus.groovy:groovy-all to v3.0.15 @renovate (#2778)
chore(deps): update plugin org.owasp.dependencycheck to v5.3.2.1 @renovate (#2775)
fix(deps): update dependency com.igormaznitsa:jcp to v7.0.5 @renovate (#2776)
fix(deps): update dependency uk.org.webcompere:system-stubs-jupiter to v2.0.2 @renovate (#2774)
chore(deps): update plugin org.gradlex.build-parameters to v1.4.2 @renovate (#2771)
chore(deps): update actions/checkout action to v3 @renovate (#2772)
fix(deps): update junit5 monorepo to v5.9.2 @renovate (#2769)
chore(deps): update dependency com.typesafe.play:anorm to v2.5.3 @renovate (#2767)
chore(deps): update codecov/codecov-action digest to 742000a @renovate (#2766)
Configure Renovate @renovate (#2756)

@davecramer

What's Changed

apply doc changes from PR #2743 to release/42.5.x by @davecramer in #2753
fix: fix testGetSQLTypeQueryCache by searching for xid type. by @davecramer in #2805
Revert "fix: fix testGetSQLTypeQueryCache by searching for xid type." by @davecramer in #2807
Make sure that github CI runs tests on all PRs by @davecramer in #2809
fix: fix testGetSQLTypeQueryCache by searching for xid type instead of box. by @davecramer in #2810
Update docs for Release 42.5.4 by @davecramer in #2812

Full Changelog: REL42.5.3...REL42.5.4

@davecramer

What's Changed

Add box to TypeInfoCache, fixes Issue #2746 by @davecramer in #2747
update changelog and docs for release by @davecramer in #2751
minor changes by @davecramer in #2752

Full Changelog: REL42.5.2...REL42.5.3

Releases: pgjdbc/pgjdbc

v42.7.6

Changes

🐛 Bug Fixes

🧰 Maintenance

⬆️ Dependencies

What's Changed

Contributors

Uh oh!

v42.7.5

Changes

⬆️ Dependencies

Contributors

Uh oh!

v42.7.4

Changes

⬆️ Dependencies

Contributors

Uh oh!

v42.7.3

Changes

Contributors

Uh oh!

v42.7.2

Security

What's Changed

Contributors

Uh oh!

v42.7.1

Fixed regressions since 42.7.0

Changes

🧰 Maintenance

⬆️ Dependencies

Contributors

Uh oh!

v42.7.0

Known issues

Changes

⬆️ Dependencies

Contributors

Uh oh!

v42.6.0

Changes

🚀 Features

📝 Documentation

🧰 Maintenance

⬆️ Dependencies

Contributors

Uh oh!

v42.5.4

What's Changed

Contributors

Uh oh!

v42.5.3

What's Changed

Contributors

Uh oh!