PostgreSQL JDBC Driver 42.7.9 Released

Notable changes

Added

• feat: query timeout property PR #3705
• feat: Add PEMKeyManager to handle PEM based certs and keys PR #3700

Changed

• perf: optimize PGInterval.getValue() by replacing String.format with StringBuilder
• chore: drop SpotBugs as we do not seem to use it
• doc: update property quoteReturningIdentifiers default value PR #3847
• security: Use a static method forName to load all user supplied classes. Use the Class.forName 3 parameter method and do not initilize it unless it is a subclass of the expected class

Fixed

• fix: incorrect pg_stat_replication.reply_time calculation PR #3906
• fix: close temporary lob descriptors that are used internally in PreparedStatement#setBlob
• fix: PGXAConnection.prepare(Xid) should return XA_RDONLY if the connection is read only PR #3897
• fix: make all Calendar instances proleptic Gregorian PR #3837
• fix: Simplify concurrency guards on QueryExecutorBase#transaction and QueryExecutorBase#standardConformingStrings PR #3897
• fix: avoid memory leaks in Java <= 21 caused by Thread.inheritedAccessControlContext PR #3886
• fix: Issue #3784 pgjdbc can’t decode numeric arrays containing special numbers like NaN PR #3838
• fix: use ssl_is_used() to check for ssl connection PR #3867
• fix: the classloader is nullable PR #3907
• deps: Update dependency org.junit:junit-bom to v5.14.1
• deps: Update dependency org.apache.bcel:bcel to v6.11.0
• deps: Update dependency org.mockito:mockito-bom to v5.20.0
• deps: Update dependency net.bytebuddy:byte-buddy-parent to v1.18.2
• deps: Update logback to v1.5.21
• deps: Update dependency jacoco to v0.8.14
• deps: Update dependency it.unimi.dsi:fastutil to v8.5.18
• deps: Update checkerframework

Commits by author

Vladimir Sitnikov (9 commits)

• close temporary lob descriptors that are used internally in PreparedStatement#setBlob
• avoid memory leaks caused by Thread.inheritedAccessControlContext
• rename LazyCleaner.java to LazyCleanerImpl.java to help Git track history
• move DriverSupportsClassUnloadingTest to pgjdbc-junit4 module so it tests with Java 8
• add CI tests with Java 26
• remove unused com.github.spotbugs Gradle plugin dependency
• optimize PGInterval.getValue() by replacing String.format with StringBuilder
• drop SpotBugs as we do not seem to use it
• bump version to 42.7.9 after 42.7.8 release

Dave Cramer (7 commits)

• the classloader is nullable, and remove a space
• fix: issue #3892, PGXAConnection.prepare(Xid) should return XA_RDONLY if the connection is read only
• fix badges for maven central and search paths. Sonatype has changed the search paths
• use ssl_is_used() to check for ssl connection
• Comment and simplify the complex state machine logic in QueryExecutorImpl #3850
• Revert “fix: Issue #3784 pgjdbc can’t decode numeric arrays containing specia…"
• create action to deploy docs to https://pgjdbc.github.io/
• fix homepage release note

Atsushi Torikoshi (1 commit)

• fix: incorrect pg_stat_replication.reply_time calculation

Manon van Tilburg (1 commit)

• fix: make all Calendar instances proleptic Gregorian

Harinath Kanchu (1 commit)

• Add PEMKeyManager to handle PEM based certs and keys

shenfeng (1 commit)

• fix: Issue #3784 pgjdbc can’t decode numeric arrays containing special numbers like NaN

Sanne Grinovero (2 commits)

• fix: Simplify concurrency guards on QueryExecutorBase#transaction and QueryExecutorBase#standardConformingStrings

Sodekim (1 commit)

• doc: update property quoteReturningIdentifiers default value

Christian Fredriksson (1 commit)

• feat: query timeout property