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

Ahh, InternalError. I should have caught this earlier. The Sun JDK has a
bug specifically on the AMD64 that causes clashes in the zlib routines.
It's fixed in the coming 6.0 release and it's also no longer an issue in
the in the coming 8.2 version of PostgreSQL since the backend no longer
links with zlib. In fact, there's no reason for it to link with zlib in
8.1 either. So a safe workaround is to:

1. preserve your current pg_dump/pg_restore (the only two programs that use zlib)
2. configure using --without-zlib and rebuild and rebuild + reinstall PostgreSQL
3. restore pg_dump/pg_restore

Kind Regards,
Thomas Hallgren

Maxim wrote:
> 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
>>>>
>>>>
>>>
>>
>>
>