From: calvinrsmith at hotmail.com (Calvin Smith)
Date: Tue, 14 Sep 2004 12:06:15 -0500
Subject: [Pljava-dev] _getConfigOption
Message-ID: <BAY2-F38YIgoFT3kMUV0008bae3@hotmail.com>

I'm trying to get pl/java to work

i'm using these versions:
postgresql-7.4.2.tar.bz2
pljava-i686-pc-linux-gnu-pg7_4-1_0_0b4.tar.gz
j2sdk-1_4_2_05-linux-i586.bin

on gentoo linux

I get as far as deploying (ie
java org.postgresql.pljava.deploy.Deployer -install -user <your name>)
and everything seemed to be happy

I then did a:
CREATE FUNCTION getsysprop(VARCHAR)
RETURNS VARCHAR
AS ?java.lang.System.getProperty?
LANGUAGE java;

which had no errors so then I did:
SELECT getsysprop(?user.home?);

which crashed postgres with:
LOG:  Error occurred during initialization of VM
LOG:
LOG:  java.lang.UnsatisfiedLinkError
LOG:  : _getConfigOption
LOG:
LOG:  server process (PID 2082) exited with exit code 1
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing


What can I do to get past this?

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/