[Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'

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