PL/Java brings functions, triggers, aggregates, types, operators, etc. in Java.
1.6.9 is the ninth 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.9 adds support for building and running with Java 24 but only with no security policy enforcement, as explained below. Other than some minor bug fixes, that is the most notable change. Further information on the changes may be found in the release notes.
PL/Java 1.6.9 still provides both a 'trusted' and an 'untrusted' "procedural language", with configurable permissions for both, when used with Java 23 or earlier at runtime. The necessary Java language features making that possible have been removed by the developers of Java, first in Java 24. When used with Java 24 or later, PL/Java 1.6.9 provides access to the latest Java language features in a purely 'untrusted' environment with no policy enforcement. The release notes should be reviewed carefully before using PL/Java in that mode.
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 Java 24, if security policy enforcement is not needed
- A
pljava-examplesjar built with the Saxon XML examples included is no longer impossible to deploy in a database without Saxon - Continuous integration now covers Ubuntu, Mac OS on Intel and ARM, and Windows using MSVC and MinGW-w64 in the single GitHub Actions workflow
Please see the release notes for a more complete list of changes.
Availability:
1.6.9 is available from GitHub as a source release, which builds quickly using
Maven:
Release page: https://github.com/tada/pljava/releases/tag/V1_6_9
This wiki page will add links to prebuilt packages that become available:
https://github.com/tada/pljava/wiki/Prebuilt-packages