pljava on postgres 9.3, mac & windows

From: Marc Brazeau <litespeedmarc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pljava on postgres 9.3, mac & windows
Date: 2014-03-20 18:14:22
Message-ID: CAKuZ-Ag2tLOHLpxM-0hvhGmaw7SD4rxnTB7pR4JsR8GVJcG9cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Venkata Balaji Nagothi 2014-03-20 21:42:48 Re: Dead rows not getting removed during vacuum
Previous Message Kenneth Buckler 2014-03-20 15:54:13 Re: High Level Committers Wanted