From: makska at yandex.ru (Maxim)
Date: Wed, 16 Aug 2006 03:32:14 +0400
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: <44E2242A.2050003@tada.se>
References: <8919.060815@yandex.ru> <44E2242A.2050003@tada.se>
Message-ID: <44E2597E.2000102@yandex.ru>

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