pljava on postgres 9.3, mac & windows - Mailing list pgsql-general

From Marc Brazeau
Subject pljava on postgres 9.3, mac & windows
Date
Msg-id CAKuZ-Ag2tLOHLpxM-0hvhGmaw7SD4rxnTB7pR4JsR8GVJcG9cA@mail.gmail.com
Whole thread Raw
List pgsql-general
Is pljava totally dead?  Is anyone still contributing to this?

Buildling pljava is becoming increasingly difficult and impossible.

We're looking into converting our Oracle base to psql, but this is a real obstacle for us as we've got a number of oracle java stored procedures, and would truly prefer to minimize migration efforts.

I had about a year or so ago managed to get pljava working on Mac, but can't even get that working with the maven build available on the pljava download website... getting linker errors on missing objects. (maven output below)
[DEBUG] Execute:Java13CommandLauncher: Executing 'gcc' with arguments:
'-dynamiclib'
'-o'
'libpljava-so-0.0.2-SNAPSHOT.dylib'
'/Users/t890479/Desktop/pljava/pljava-master/pljava-so/target/nar/obj/x86_64-MacOSX-gpp/AclId.o'
'/Users/t890479/Desktop/pljava/pljava-master/pljava-so/target/nar/obj/x86_64-MacOSX-gpp/Any.o'
... a bunch more of these ...
/Users/t890479/Desktop/pljava/pljava-master/pljava-so/target/nar/obj/x86_64-MacOSX-gpp/XactListener.o'
'/Users/t890479/Desktop/pljava/pljava-master/pljava-so/target/nar/obj/x86_64-MacOSX-gpp/backports.o'
'/Users/t890479/Desktop/pljava/pljava-master/pljava-so/target/nar/obj/x86_64-MacOSX-gpp/byte_array.o'
'-L../../../../../../../../../../../../System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Libraries'
'-ljvm'
'-L../../../../../../../../../../../../Library/PostgreSQL/9.3/lib'
'-lpostgres'
'-shared-libgcc'

The ' characters around the executable and arguments are
not part of the command.
[ERROR] ld: library not found for -lpostgres
[ERROR] clang: error: linker command failed with exit code 1 (use -v to see invocation)
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] PostgreSQL pl/java ................................ SUCCESS [0.002s]
[INFO] PL/JAVA API ....................................... SUCCESS [0.354s]
[INFO] pl/java implementation ............................ SUCCESS [0.155s]
[INFO] pl/java deploy .................................... SUCCESS [0.023s]
[INFO] pl/java Ant Tasks ................................. SUCCESS [0.025s]
[INFO] pl/java examples .................................. SUCCESS [0.058s]
[INFO] pl/java server side library ....................... FAILURE [8.947s]

Removing '-L../../../../../../../../../../../../Library/PostgreSQL/9.3/lib', I get even more linker errors.

We're pretty close on having to replicate a whole lot of java code into plsql, or worse forgetting this postgres thing.

pgsql-general by date:

Previous
From: Kenneth Buckler
Date:
Subject: Re: High Level Committers Wanted
Next
From: Bhim Kumar
Date:
Subject: SQL Query for Foreign constraint