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: Wed, 16 Aug 2006 08:01:27 +0200
Message-ID: <44E2B4B7.3040709@tada.se> (raw)
In-Reply-To: <44E2597E.2000102@yandex.ru>
References: <8919.060815@yandex.ru>
	<44E2242A.2050003@tada.se>
	<44E2597E.2000102@yandex.ru>

Hmm, strange. Try setting the postgresql.conf variable log_min_messages 
to debug1. Then make a new attempt. That might produce some more trace 
in the backend log that might be helpful.

Regards,
Thomas Hallgren

Maxim wrote:
> Hi Thomas,
>
> Thanks you a lot for your answer!
>
> I've changed LD_LIBRARY_PATH to
> /usr/lib64:/usr/java/jdk1.5.0_06/jre/lib/amd64/server:/usr/java/jdk1.5.0_06/jre/lib/amd64 
> ,
> dynamic_library_path in postgresql.conf to '$libdir:/usr/lib64/pgsql' 
> and double checked read permissions and location of pljava.jar file.
>
> But error is still the same...
>
> All the best,
> Maxim Karavaev
>> 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!!
>>>
>>>     
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>   
>

view thread (15+ messages)  latest in thread

Message-ID: <44E2B4B7.3040709@tada.se>
Permalink:  ../44E2B4B7.3040709@tada.se/
Also on:    postgresql.org/message-id/44E2B4B7.3040709@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: <44E2B4B7.3040709@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