PL/Java is a free add-on module that brings Java™ Stored Procedures, Triggers, and Functions to the PostgreSQL™ backend.
The development started late 2003 and the first release of PL/Java arrived in January 2005. The project is released under the PLJava License license.
Features
- Ability to write both functions and triggers using Java 1.4 or higher.
- Standardized utilities (modeled after the SQL 2003 proposal) to install and maintain Java code in the database.
- Standardized mappings of parameters and result. Supports scalar and composite UDT's, pseudo types, arrays, and sets.
- An embedded, high performance, JDBC driver utilizing the internal PostgreSQL SPI routines.
- Metadata support for the JDBC driver. Both DatabaseMetaData and ResultSetMetaData are included.
- Full support for PostgreSQL 8.0 savepoints and exception handling.
- Ability to use IN, INOUT, and OUT parameters when used with PostgreSQL 8.1 or higher.
- Two language handlers, one TRUSTED (the default) and one that is not TRUSTED (language tag is javaU to conform with the defacto standard).
- Transaction and Savepoint listeners enabling code execution when a transaction or savepoint is committed or rolled back.
- Integration with GNU GCJ on selected platforms.
More information about this project can be found in the PL/Java Wiki
