[From nobody Thu May  8 05:16:41 2008
Subject: Unable to load class org/postgresql/plsql/internal/Backend
From: Michael Judd <michael.judd@jaztek.co.uk>
To: pljava-dev@gborg.postgresql.org
Content-Type: text/plain
Date: Tue, 07 Jun 2005 23:46:25 +0100
Message-Id: <1118184385.5061.451.camel@laptop01.jaztek.co.uk>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.4 (2.0.4-4) 
Content-Transfer-Encoding: 7bit

Hi,

I'm having trouble installing plsql and I'm getting the following:

Unable to load class org/postgresql/plsql/internal/Backend using
CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'

when issuing the command to pgsql:

SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);

I have checked that:
- pljava.jar is in /opt/pgsql/pljava/build
- sqlj.jar is in  /opt/pgsql/lib

in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
$libdir' where libpljava.so, plpgsql.so resides.

my paths are:
 - postgres /opt/pgsql
 - pljava /opt/pgsql/pljava
 - data /opt/pgsql/pg_data

Fedora Core 3 x86_64smp

I've double checked that Backend is located in the jar exactly where it
is supposed to be - so the error being displayed doesn't seem to point
in the 'right' direction.

Any ideas ?





]