From: vclark at globalera.com (Vince Clark)
Date: Tue, 07 Jun 2005 17:16:57 -0600
Subject: [Pljava-dev] [Fwd: Unable to load
	class	org/postgresql/plsql/internal/Backend]
In-Reply-To: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
Message-ID: <42A62AE9.8060309@globalera.com>

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050607/28c2dbc4/attachment.html>