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.