agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
Date: Tue, 15 Aug 2006 21:44:42 +0200
Message-ID: <44E2242A.2050003@tada.se> (raw)
In-Reply-To: <8919.060815@yandex.ru>
References: <8919.060815@yandex.ru>

Hi Maxim,
Your LD_LIBRARY_PATH seems a bit off. Normally you need the both jre/lib/amd64/server and 
the parent directory jre/lib/amd64. The dynamic_library_path is also incorrect. It should 
only appoint the directory of the pljava.so file, (so '$libdir:/usr/lib64/pgsql' is probably 
more accurate).

The problem you encounter however, seems to be related to the pljava.classpath setting in 
the postgresql.conf file. Double check this setting and that the pljava.jar really is at 
that location. Verify that the PostgreSQL backend process has read permissions on the 
directory and the pljava.jar file.

Regards,
Thomas Hallgren


Maxim wrote:
> Hello,
> 
> I've got troubles installing PlJava on FedoraCore4 x64.
> I have PostgreSQL 8.1.4, jre 1.5.0_06 and compiled from sources PlJava
> 1.3.0 (with the same jdk - 1.5.0_06).
> After deploying PlJava and running query like:
> 
> CREATE FUNCTION sqlj.getsysprop(VARCHAR)
>   RETURNS VARCHAR
>   AS 'java.lang.System.getProperty'
>   LANGUAGE java;
> 
> SELECT sqlj.getsysprop('user.home');
> 
> I've got after fist time "Unable to load class
> org/postgresql/pljava/internal/Backend using CLASSPATH 
> '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'" error,
> after second - "Failed to create Java VM".
> 
> I've been trying a lot of different settings of LD_LIBRARY_PATH,
> postgresql.conf, etc, but can't find solution.
> 
> My latest settings are:
> 
> postgresql.conf
> dynamic_library_path = '$libdir:/usr/lib64/:/usr/java/jdk1.5.0_06/jre/lib/amd64/server/:/usr/lib64/pgsql/'
> custom_variable_classes = 'pljava'
> pljava.classpath = '/usr/lib64/pgsql/pljava.jar'
> pljava.vmoptions = '-Xmx64M '
> pljava.debug = false
> 
> echo $LD_LIBRARY_PATH
> /usr/lib64/:/usr/java/jdk1.5.0_06/jre/lib/amd64/server/
> 
> 
> I've been searching for the same error in google and in this mailing
> list, but can't find solution for me... :(
> 
> Highly appreciate any help!!
> 

view thread (15+ messages)  latest in thread

Message-ID: <44E2242A.2050003@tada.se>
Permalink:  ../44E2242A.2050003@tada.se/
Also on:    postgresql.org/message-id/44E2242A.2050003@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
  In-Reply-To: <44E2242A.2050003@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox