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

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>