From: makska at yandex.ru (Maxim)
Date: Tue, 15 Aug 2006 22:03:49 +0400
Subject: [Pljava-dev] Unable to load class
	org/postgresql/pljava/internal/Backend using CLASSPATH
	'-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
Message-ID: <8919.060815@yandex.ru>

Hello,

I've got troubles installing PlJava on FedoraCore4 x64.
I have PostgreSQL 8.1.4, jre 1.5.0_06 and compiled from sources PlJava
1.3.0 (with the same jdk - 1.5.0_06).
After deploying PlJava and running query like:

CREATE FUNCTION sqlj.getsysprop(VARCHAR)
  RETURNS VARCHAR
  AS 'java.lang.System.getProperty'
  LANGUAGE java;

SELECT sqlj.getsysprop('user.home');

I've got after fist time "Unable to load class
org/postgresql/pljava/internal/Backend using CLASSPATH 
'-Djava.class.path=/usr/lib64/pgsql/pljava.jar'" error,
after second - "Failed to create Java VM".

I've been trying a lot of different settings of LD_LIBRARY_PATH,
postgresql.conf, etc, but can't find solution.

My latest settings are:

postgresql.conf
dynamic_library_path = '$libdir:/usr/lib64/:/usr/java/jdk1.5.0_06/jre/lib/amd64/server/:/usr/lib64/pgsql/'
custom_variable_classes = 'pljava'
pljava.classpath = '/usr/lib64/pgsql/pljava.jar'
pljava.vmoptions = '-Xmx64M '
pljava.debug = false

echo $LD_LIBRARY_PATH
/usr/lib64/:/usr/java/jdk1.5.0_06/jre/lib/amd64/server/


I've been searching for the same error in google and in this mailing
list, but can't find solution for me... :(

Highly appreciate any help!!

-- 
Best regards,
 Maxim Karavaev