PL/Java brings functions, triggers, and types in Java.

1.6.0 is a notably refactored release that requires Java 9 or later and PostgreSQL 9.5 or later, and brings a number of changes from 1.5.x.

Current users of a 1.5.x release should review the 1.6.0 release notes for possibly necessary changes before updating to 1.6.0.

It includes configurable permissions (finer grained than just java versus javaU), a smarter SQL generator, and a much-improved build experience.

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

Selected changes

• The Java permissions available to java and javaU functions can be tailored for each case. Language 'aliases' beyond those two can also be set up with CREATE LANGUAGE and have their own associated permissions.

• The SQL generator no longer needs to be explicitly told about dependencies between a new type and the functions that use it, or are used in its implementation.

• PL/Java functions can now be variadic.

• The build system now takes pg_config values such as CFLAGS into account to match the compiler configuration used to build PostgreSQL.

• Two continuous integration services now routinely build PL/Java for Linux (x86_64 and ppc64le), Mac OS X, and Windows (MinGW-w64 and MSVC), with results visible at GitHub.

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

Availability:

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

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

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