From: makska at yandex.ru (Maxim)
Date: Wed, 16 Aug 2006 10:50:30 +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: <44E2B4B7.3040709@tada.se>
References: <8919.060815@yandex.ru> <44E2242A.2050003@tada.se>
	<44E2597E.2000102@yandex.ru> <44E2B4B7.3040709@tada.se>
Message-ID: <44E2C036.4000404@yandex.ru>

Thomas, thanks for your help!

I've changed log_min_message to debug1 and got the following trace:

DEBUG:  Not using integer_datetimes
DEBUG:  Added JVM option string "-Xmx64M"
DEBUG:  Added JVM option string 
"-Djava.class.path=/usr/lib64/pgsql/pljava.jar"
DEBUG:  Added JVM option string 
"-Dsqlj.defaultconnection=jdbc:default:connection"
DEBUG:  Added JVM option string "vfprintf"
DEBUG:  Added JVM option string "-Xrs"
DEBUG:  Creating JavaVM
DEBUG:  JavaVM created
DEBUG:  Getting Backend class pljava.jar
WARNING:  java.lang.InternalError
DEBUG:  Destroying JavaVM...
DEBUG:  JavaVM destroyed
ERROR:  Unable to load class org/postgresql/pljava/internal/Backend 
using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'

Best regards,
Maxim Karavaev
> 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
>>>
>>>   
>>
>
>