From: thomas at tada.se (Thomas Hallgren)
Date: Wed, 16 Aug 2006 08:01:27 +0200
Subject: [Pljava-dev] Unable to load class
 org/postgresql/pljava/internal/Backend using CLASSPATH
 '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
In-Reply-To: <44E2597E.2000102@yandex.ru>
References: <8919.060815@yandex.ru> <44E2242A.2050003@tada.se>
	<44E2597E.2000102@yandex.ru>
Message-ID: <44E2B4B7.3040709@tada.se>

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
>>
>>   
>