[Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]

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