From: list at jaztek.co.uk (Michael Judd)
Date: Wed, 08 Jun 2005 01:27:45 +0100
Subject: [Pljava-dev] [Fwd: Unable to load
	class	org/postgresql/plsql/internal/Backend]
In-Reply-To: <42A62AE9.8060309@globalera.com>
References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
	<42A62AE9.8060309@globalera.com>
Message-ID: <1118190465.5061.497.camel@laptop01.jaztek.co.uk>

Hi,

At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
This now matches my dynamic_library_path in postgresql.conf
in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?

I'm still getting exactly the same problem.

Thanks for your help.



On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> Michael
> 
> You said you were having trouble installing plsql. Do you mean pljava?
> 
> Be sure you also have LD_LIBRARY_PATH set with the same values. 
> 
> Once the library path is established in both places (LD_LIBRARY_PATH)
> and postgresql.conf) I found that restarting postgres before trying to
> install pljava solved the problem.
> 
> Michael Judd wrote: 
> > 
> > 
> > ____________________________________________________________________
> > 
> > Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> > From:  Michael Judd <michael.judd at jaztek.co.uk>
> > Date:  Tue, 07 Jun 2005 23:46:25 +0100
> > To:  pljava-dev at gborg.postgresql.org
> > To:  pljava-dev at gborg.postgresql.org
> > 
> > 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 ?
> > 
> > 
> > 
> > 
> > 
> >   
> > 
> > ____________________________________________________________________
> > 
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >   
> 
> -- 
> Vince Clark 
> Global Era 
> The freedom of open source. 
> (303) 493-6723 
> (303) 455-2409 fax 
> vclark at globalera.com 
> www.globalera.com