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

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