PL/Java
An implementation of Java as a procedural language
PL/Java is an implementation of Java as a PostgreSQL procedural language.
PL/Java was introduced in 2003.
Release history
This is a summary of recent significant releases; for a full and detailed list of releases, see the PL/Java release notes and the PL/Java release page.
- 1.6.2 (2020-11-27; release notes)
- bugfix release
- 1.6.1 (2020-11-16; release notes)
- bugfix release
- 1.6.0 (2020-10-18; release notes)
- substantial refactoring
- support for PostgreSQL 13
- 1.5.5 (2019-11-04)
- bugfix release
- 1.5.4 (2019-10-30)
- 1.5.3 (2019-10-04)
- support for PostgreSQL 12
- can be built with Java versions later than 8
- 1.5.2 (2018-11)
- 1.5.1 (2018-10)
- 1.5.0 (2016-03)
- 1.4.0 (2008-02)
- 1.3.0 (2006-06)
- 1.2.0 (2005-11)
- 1.1.0 (2005-04)
- 1.0.0 (2005-01)
Note there was a long hiatus in development between 1.4.0 and 1.5.0.
Trivia
Unusually for a non-core extension, the PostgreSQL core code as of commit f4aa3a18 (PostgreSQL 9.6, backported as far back as PostgreSQL 9.1) contains code (see src/backend/utils/misc/guc.c, function init_custom_variable()) to mitigate a possible security issue present in PL/Java versions prior to 1.5.0 .
Examples
For a classic "Hello World!" example, see: The obligatory Hello example
Useful links
- PostgreSQL documentation: Procedural Languages
- PostgreSQL PL/Java – A How-To, Part 1 - August 2021 blog article by Charly Batista / Percona