PL/Java brings functions, triggers, aggregates, types, operators, etc. in Java.

1.6.10 is the tenth minor update in the 1.6 series, for applications on PostgreSQL 9.5 or later and Java 9 or later. Legacy applications requiring older PostgreSQL or Java versions may be supported by the 1.5 series.

1.6.10 adds support for building and running with Java 25 and with PostgreSQL 18, and improvements to exception handling and logging that should be helpful in debugging the common developer mistake of catching a PostgreSQL exception and proceeding without rolling back to a prior savepoint. Further information on the changes may be found below.

When run on Java 24 or later, there is no security policy enforcement; please review the release notes for PL/Java 1.6.9 also for more detail on that.

PL/Java 1.6.10 still provides both a 'trusted' and an 'untrusted' "procedural language", with configurable permissions for both, when used with Java 23 or earlier at runtime. For applications where the latest language features are not needed and policy enforcement is of value, a Java version before 24, such as the long-term-support Java 21, should be used.

For more on how future PL/Java versions may adapt, please bookmark JEP 411 on the PL/Java wiki.

Current users of a 1.5.x release should also review the 1.6.0 release notes for changes that may require attention before updating to 1.6.x.

Project site: http://tada.github.io/pljava/
Release notes: http://tada.github.io/pljava/releasenotes.html

Selected changes

• Can be built and used with PostgreSQL 18
• Can be built and used with Java 25, if security policy enforcement is not needed
• Simplifies debugging of a common new-developer mistake in handling PostgreSQL exceptions

Please see the release notes for a more complete list of changes.

Availability:

1.6.10 is available from GitHub as a source release, which builds quickly using
Maven:

Release page: https://github.com/tada/pljava/releases/tag/V1_6_10

This wiki page will add links to prebuilt packages that become available:
https://github.com/tada/pljava/wiki/Prebuilt-packages