Stack Overflow
Stack Overflow

Questions tagged [pljava]

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

36 questions
0
votes
1 answer

Can I make a call to a java class/method from a Trigger in a PostgreSQL (in Heroku)?

I need to make my PostgreSQL database execute a java class called by a trigger. I read that you can install java on your PostgreSQL db, but to do this I might need superuser privileges, and don't know how to do this since PostgreSQL on Heroku…
SGj
  • 21
  • 5
0
votes
1 answer

How to avoid nullpointer exception on compiling pl/java?

I'm trying to build pljava sources on Linux Mint 17 Qiana (32bit) with maven 3.2.5, JDK 1.7.0_72-b14, gpp is installed (2.24) and all modules are compiled fine except one: pl/java server side library. The stacktrace is: [ERROR] Failed to execute…
Filosssof
  • 1,288
  • 3
  • 17
  • 37
0
votes
1 answer

Create so instead of dylib using nar maven plugin

I now have pljava building on the Mac. pljava uses maven and the maven nar plugin for building. This maven nar build is currently creating a dylib instead of a .so. It looks like that postgres wants an .so instead. This is the output from turning…
Gareth
  • 936
  • 6
  • 14
0
votes
1 answer

Postgres Error (Getting PLJava set up)

I have been struggling with a problem trying to get PLJava to work on PostgreSQL on RHEL. Here is what I have (based off of this: PL/Java README) .cshrc setenv JAVA_HOME /opt/jdk1.6.0_17/ setenv LD_LIBRARY_PATH ${JAVA_HOME}/jre/lib/i386 setenv…
mainstringargs
  • 13,563
  • 35
  • 109
  • 174
0
votes
1 answer

Using PL/Java with JPA or other persistence library

I'm wondering if it's possible to use JPA or other persistence library with PL/Java together? I mean using JPA persistence for manipulationg database over the special JDBC connection provided by PL/Java in stored Java procedures.
NagyI
  • 5,907
  • 8
  • 55
  • 83
-4
votes
1 answer

Connection to PostgreSQL using PL/Java in a trigger fails

I defined a trigger in PostgreSQL 9.1 that should fire whenever a record is updated using: CREATE OR REPLACE FUNCTION check() RETURNS TRIGGER AS $$ BEGIN SELECT doubletEngine.checkForDoublet(NEW.id); RETURN NEW; END; $$ LANGUAGE plpgsql; DROP…
Nico Haase
  • 11,420
  • 35
  • 43
  • 69
1 2
3