v42.7.3

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)

v42.7.2

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

v42.7.1

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)

v42.7.0

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)

v42.6.0

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)

v42.5.4

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

v42.5.3

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

v42.5.2

What's Changed

• Fix broken case in Maven XML snippet copied to clipboard by @dalbani in #2682
• move release date to Nov 23, update version number for next release by @davecramer in #2677
• fix: Make sure socket is closed if an exception is thrown in createSocket fixes Issue #2684 by @davecramer in #2685
• docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes #Issue 2671 by @davecramer in #2686
• fix: Apply patch from Issue #2683 to fix hanging ssl connections by @davecramer in #2687
• style: Style only change to use diamond operator in Oid by @rbygrave in #2691
• style: Style only change, use diamond operator in PGProperty by @rbygrave in #2692
• fix - binary conversion of (very) long numeric values by @bokken in #2697
• docs: clarify binaryTransfer and add it to README by @davecramer in #2698
• docs: Document the need to encode reserved characters in the connection URL by @davecramer in #2700
• minor: set private attribute as final by @AlaaAttya in #2704
• minor: enhance readability connection of startup params by @AlaaAttya in #2705
• minor: log warning on stream close failure by @AlaaAttya in #2708
• fix: make variables private final by @davecramer in #2707
• fix: Parser does not handle version 14 function syntax Issue #2507 by @davecramer in #2703
• fix: img src in README by @david-whs in #2712
• fix binary transfer floating point overflow by @bokken in #2710
• Revert "fix binary transfer floating point overflow" by @davecramer in #2716
• add redirects fixes issue #2608 by @davecramer in #2718
• update lastEditYear by @davecramer in #2721
• Revert "update lastEditYear" by @davecramer in #2727
• fix: improve thread safety of PgResultSet#getTimestamp by @sz-liva in #2726
• Update lastyear by @davecramer in #2728
• redo PR fix_binary_transfer_floating point from brett, removed BigDecimal where possible by @davecramer in #2719
• Bump GitHub action versions, replace deprecated set-output usage by @vlsi in #2731
• docs: remove generated docs from source control by @vlsi in #2734
• add ssl redirect by @davecramer in #2735
• Make sure all configuration settings have defaults documented by @davecramer in #2740
• feat: Define binary transfer for custom types dynamically (#2554) by @sebasbaumh in #2556
• Update CHANGELOG and website for release by @davecramer in #2742

New Contributors

• @AlaaAttya made their first contribution in #2704
• @david-whs made their first contribution in #2712
• @sz-liva made their first contribution in #2726
• @sebasbaumh made their first contribution in #2556

Full Changelog: REL42.5.1...REL42.5.2

v42.5.1

What's Changed

• Spelling by @jsoref in #2592
• docs: clarify we ship security fixes by default for the latest 42.x and 42.2 only by @vlsi in #2586
• Update README.md by @davecramer in #2609
• Ignore simplequery for postgresql 8.4 by @davecramer in #2614
• Single commit to move newdocs into master by @davecramer in #2618
• update versions by @davecramer in #2619
• Optimize png files by @utkar-sh-ukla in #2621
• fix grammar, fix downloads, minor edits by @davecramer in #2626
• fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes #Issue 2548 by @davecramer in #2552
• clarify prepared statement usage by @davecramer in #2629
• fix maven coordinates by @davecramer in #2631
• perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns by @john9x in #2634
• remove javadoc links for java 17 and above by @davecramer in #2637
• fix: binary decoding of bool values by @olavloite in #2640
• Feature/urlparser improve3 pr1 by @MarekUniq in #2641
• revert change to PGProperty.get() to keep the API consistent by @davecramer in #2644
• exclude ArrayTest versions less than 9.1 by @davecramer in #2645
• chore: add .git-blame-ignore-revst to hide reformatting commits from GitHub blame UI by @vlsi in #2650
• minor: Update the LeftCurly according to the updation in checkstyle by @Kevin222004 in #2661
• chore: bump Gradle to 7.5.1 by @vlsi in #2663

New Contributors

• @jsoref made their first contribution in #2592
• @john9x made their first contribution in #2634
• @olavloite made their first contribution in #2640
• @Kevin222004 made their first contribution in #2661

Full Changelog: REL42.5.0...REL42.5.1

v42.4.3

What's Changed

• backpatch 42.5.1 by @davecramer in #2675

Full Changelog: REL42.4.2...REL42.4.3