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

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