From: cs at m0n0.co.uk (Christopher Snow)
Date: Wed, 16 Apr 2008 07:24:11 +0100
Subject: [Pljava-dev] install problems
Message-ID: <1208327051.29448.4.camel@ac.coralms.com>

Deployer is failing on the following call.  Any ideas?


CREATE FUNCTION sqlj.java_call_handler() 
RETURNS language_handler 
AS 'pljava' 
LANGUAGE C


ERROR:  could not access file "pljava": No such file or directory

********** Error **********

ERROR: could not access file "pljava": No such file or directory
SQL state: 58P01

My setup:

ld.so.conf (+ ldconfig ran):
 
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386/client
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386/native_threads
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386/server

postgresql.conf:

dynamic_library_path =
'$libdir:/home/snowch/Apps/pljava-i686-pc-linux-gnu-pg8.3-1.4.0'
custom_variable_classes = 'pljava'
pljava.classpath =
'/home/snowch/Apps/pljava-i686-pc-linux-gnu-pg8.3-1.4.0/pljava.jar'