From: mark81 at gmail.com (Mark Mitchell)
Date: Tue, 9 Oct 2007 00:06:18 -0400
Subject: [Pljava-dev] [Fwd: Re: PL/Java and native classes]
In-Reply-To: <470AB107.40204@tomd.cc>
References: <470AB107.40204@tomd.cc>
Message-ID: <449f4cf70710082106i277bdaa4q53252491d5696886@mail.gmail.com>

More speculation here, but I thought that pl/java triggers/functions
couldn't access the disk, and maybe this is causing your library not
to load.

To do so you have to make them use the Java untrusted option. See

http://wiki.tada.se/display/pljava/Security

for more details (essentially just make the language javaU instead of
java and you can access the disk).

-Mark

On 10/8/07, Tom Dunstan <pgsql at tomd.cc> wrote:
> Forgot to CC list
>
> -------- Original Message --------
> Subject: Re: [Pljava-dev] PL/Java and native classes
> Date: Mon, 08 Oct 2007 23:35:26 +0100
> From: Tom Dunstan <pgsql at tomd.cc>
> To: Lucas Madar <lucas at mcsnw.com>
> References: <470AA089.9080102 at mcsnw.com>
>
> Hi Lucas
>
> I haven't used native methods with PL/Java before, so the best I can
> offer is generic debugging... What makes you think it isn't
> System.loadLibrary? Do you get a stack trace in the logs? Can we see the
> relevant bits of your postgresql.conf? Did you add the path to the
> library to LD_LIBRARY_PATH (or whatever the equivalent is on your platform)?
>
> Cheers
>
> Tom
>
> Lucas Madar wrote:
> > Hey everyone,
> >
> > I'm having a problem trying to get PL/Java to work with native methods.
> > I can't seem to get it to load a native library. When loading the
> > library, I get a NoClassDefFoundError, which as far as I can tell isn't
> > thrown by System.loadLibrary. I've tried setting VM Arguments to use a
> > -Djava.library.path= and putting the .so file into the postgres lib
> > directory.
> >
> > Anyone else have any luck or experience here?
> >
> > Thanks,
> > Lucas Madar
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>