Home
##Overview## 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 commited or rolled back.
- Integration with GNU GCJ on selected platforms.
##Documentation##
Installation Guide
User Guide
Contribution Guide
##Resources##
Downloads
Mailing List
Bug Tracking
Older bug tracker at PgFoundry
##Technology##
Technoloy in Brief
The choice of JNI