From: list at jaztek.co.uk (Michael Judd)
Date: Wed, 08 Jun 2005 08:21:13 +0100
Subject: [Pljava-dev] Re: [Fwd: Unable to load class
	org/postgresql/plsql/internal/Backend]
In-Reply-To: <thhal-0tCiCAw19zjYK7Bbntfoky5Ufpvq9eG@mailblocks.com>
References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
	<42A62AE9.8060309@globalera.com> <42A69030.6090708@mailblocks.com>
	<thhal-0tCiCAwt9zjYX4IUInwI062EhoWrM5a@mailblocks.com>
	<thhal-0tCiCAw19zjYK7Bbntfoky5Ufpvq9eG@mailblocks.com>
Message-ID: <1118215273.5061.589.camel@laptop01.jaztek.co.uk>

Apologies.  The list post included the typo you identified but the
system actually had the "/" as expected.

I'm following up on the issue about sun's 1.5 jvm and trying with
balckdown 1.4 (amd64 ) - unless there's some other solution?

Thanks for you help.

Mike

On Wed, 2005-06-08 at 08:29 +0200, Thomas Hallgren wrote:
> Michael,
> If you get so far that a complaint about "Unable to load class" is 
> issued, then your LD_LIBRARY_PATH and dynamic_library_path are both 
> correct. Your problem is in the CLASSPATH. It ends with 
> "build.pljava.jar", i.e. you have a dot before pljava.jar. It should end 
> with "build/pljava.jar".
> 
> Regards,
> Thomas Hallgren
> 
> 
> 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 <mailto:vclark at globalera.com>
> > www.globalera.com
> > 
> > 
> > ------------------------------------------------------------------------
> > 
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> 
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev