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

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