agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
15+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-15 18:03
2006-08-15 19:44 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
0 siblings, 1 reply; 15+ messages in thread
From: @ 2006-08-15 18:03 UTC (permalink / raw)
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!!
--
Best regards,
Maxim Karavaev
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-15 19:44 `
2006-08-15 23:32 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
0 siblings, 1 reply; 15+ messages in thread
From: @ 2006-08-15 19:44 UTC (permalink / raw)
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!!
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 19:44 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-15 23:32 `
2006-08-16 06:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
0 siblings, 1 reply; 15+ messages in thread
From: @ 2006-08-15 23:32 UTC (permalink / raw)
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
>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 19:44 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 23:32 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-16 06:01 `
2006-08-16 06:50 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
0 siblings, 1 reply; 15+ messages in thread
From: @ 2006-08-16 06:01 UTC (permalink / raw)
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
>>
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 19:44 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 23:32 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-16 06:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-16 06:50 `
2006-08-16 08:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
0 siblings, 1 reply; 15+ messages in thread
From: @ 2006-08-16 06:50 UTC (permalink / raw)
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
>>>
>>>
>>
>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 19:44 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 23:32 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-16 06:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-16 06:50 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-16 08:02 `
2006-08-16 11:32 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
0 siblings, 1 reply; 15+ messages in thread
From: @ 2006-08-16 08:02 UTC (permalink / raw)
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
>>>>
>>>>
>>>
>>
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 19:44 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 23:32 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-16 06:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-16 06:50 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-16 08:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
@ 2006-08-16 11:32 `
0 siblings, 0 replies; 15+ messages in thread
From: @ 2006-08-16 11:32 UTC (permalink / raw)
Hello Thomas,
Yes! The problem is solved after recompiling Postgres with
"--without-zlib" option.
Thanks you a lot for advice!!
Best wishes,
Maxim Karavaev
TH> Ahh, InternalError. I should have caught this earlier. The Sun JDK has a
TH> bug specifically on the AMD64 that causes clashes in the zlib routines.
TH> It's fixed in the coming 6.0 release and it's also no longer an issue in
TH> the in the coming 8.2 version of PostgreSQL since the backend no longer
TH> links with zlib. In fact, there's no reason for it to link with zlib in
TH> 8.1 either. So a safe workaround is to:
TH> 1. preserve your current pg_dump/pg_restore (the only two programs that use zlib)
TH> 2. configure using --without-zlib and rebuild and rebuild + reinstall PostgreSQL
TH> 3. restore pg_dump/pg_restore
TH> Kind Regards,
TH> Thomas Hallgren
TH> 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
>>>>>
>>>>>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-20 20:19
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-20 20:19 UTC (permalink / raw)
Hi there,
I am having some problem when trying to experiment with a hello world
example. When I run the following command I am getting this error
message.
I am not sure what I am doing wrong.
The class path seems to be correct. I have the pljava.jar file in /root/mydir
How can I resolve this. Thanks,
SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
'helloworld_jar', false);
WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
ERROR: Unable to load class org/postgresql/pljava/internal/Backend
using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 14:05 `
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-21 14:05 UTC (permalink / raw)
Hi there,
I have read through some of the mail threads, and noticed that people
had the same problem before. I am using postgres 8.1.11 and plJava
1.4.0 and am running in a variant of CentOS. e-smith server. I am not
sure if I have the same problem that was mentioned in other threads(
about zlib conflict). Please let me know. Thank you very much.
On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Hi there,
>
> I am having some problem when trying to experiment with a hello world
> example. When I run the following command I am getting this error
> message.
> I am not sure what I am doing wrong.
> The class path seems to be correct. I have the pljava.jar file in /root/mydir
> How can I resolve this. Thanks,
>
> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
> 'helloworld_jar', false);
> WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 15:00 `
2008-10-21 15:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-21 15:00 UTC (permalink / raw)
Here are the info I got in the server logs.
LOCATION: SetTransactionIdLimit, varsup.c:234
DEBUG: 00000: Not using integer_datetimes
LOCATION: checkIntTimeType,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:538
DEBUG: 00000: Added JVM option string
"-Djava.class.path=/root/thanesh/pljava.jar"
LOCATION: JVMOptList_add,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
DEBUG: 00000: Added JVM option string
"-Dsqlj.defaultconnection=jdbc:default:connection"
LOCATION: JVMOptList_add,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
DEBUG: 00000: Added JVM option string "vfprintf"
LOCATION: JVMOptList_add,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
DEBUG: 00000: Added JVM option string "-Xrs"
LOCATION: JVMOptList_add,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
DEBUG: 00000: Creating JavaVM
LOCATION: initializeJavaVM,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:640
DEBUG: 00000: JavaVM created
LOCATION: initializeJavaVM,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:660
DEBUG: 00000: Getting Backend class pljava.jar
LOCATION: initPLJavaClasses,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
WARNING: XX000: java.lang.NoClassDefFoundError:
org/postgresql/pljava/internal/Backend
LOCATION: elogExceptionMessage,
/home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
DEBUG: 00000: Destroying JavaVM...
LOCATION: _destroyJavaVM,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
c DEBUG: 00000: JavaVM destroyed
LOCATION: _destroyJavaVM,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
ERROR: XX000: Unable to load class
org/postgresql/pljava/internal/Backend using CLASSPATH
'-Djava.class.path=/root/thanesh/pljava.jar'
LOCATION: PgObject_getJavaClass,
/home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
On Tue, Oct 21, 2008 at 10:05 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Hi there,
>
> I have read through some of the mail threads, and noticed that people
> had the same problem before. I am using postgres 8.1.11 and plJava
> 1.4.0 and am running in a variant of CentOS. e-smith server. I am not
> sure if I have the same problem that was mentioned in other threads(
> about zlib conflict). Please let me know. Thank you very much.
>
>
> On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com> wrote:
>> Hi there,
>>
>> I am having some problem when trying to experiment with a hello world
>> example. When I run the following command I am getting this error
>> message.
>> I am not sure what I am doing wrong.
>> The class path seems to be correct. I have the pljava.jar file in /root/mydir
>> How can I resolve this. Thanks,
>>
>> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
>> 'helloworld_jar', false);
>> WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
>> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 15:02 `
2008-10-21 16:45 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-21 15:02 UTC (permalink / raw)
Actually my classpath is set to /root/thanesh/pljava.jar and not
/root/mydir/pljava.jar as in the first mail.
On Tue, Oct 21, 2008 at 11:00 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Here are the info I got in the server logs.
>
> LOCATION: SetTransactionIdLimit, varsup.c:234
> DEBUG: 00000: Not using integer_datetimes
> LOCATION: checkIntTimeType,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:538
> DEBUG: 00000: Added JVM option string
> "-Djava.class.path=/root/thanesh/pljava.jar"
> LOCATION: JVMOptList_add,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
> DEBUG: 00000: Added JVM option string
> "-Dsqlj.defaultconnection=jdbc:default:connection"
> LOCATION: JVMOptList_add,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
> DEBUG: 00000: Added JVM option string "vfprintf"
> LOCATION: JVMOptList_add,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
> DEBUG: 00000: Added JVM option string "-Xrs"
> LOCATION: JVMOptList_add,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
> DEBUG: 00000: Creating JavaVM
> LOCATION: initializeJavaVM,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:640
> DEBUG: 00000: JavaVM created
> LOCATION: initializeJavaVM,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:660
> DEBUG: 00000: Getting Backend class pljava.jar
> LOCATION: initPLJavaClasses,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
> java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
> WARNING: XX000: java.lang.NoClassDefFoundError:
> org/postgresql/pljava/internal/Backend
> LOCATION: elogExceptionMessage,
> /home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
> DEBUG: 00000: Destroying JavaVM...
> LOCATION: _destroyJavaVM,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
> c DEBUG: 00000: JavaVM destroyed
> LOCATION: _destroyJavaVM,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
> ERROR: XX000: Unable to load class
> org/postgresql/pljava/internal/Backend using CLASSPATH
> '-Djava.class.path=/root/thanesh/pljava.jar'
> LOCATION: PgObject_getJavaClass,
> /home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
>
>
> On Tue, Oct 21, 2008 at 10:05 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
>> Hi there,
>>
>> I have read through some of the mail threads, and noticed that people
>> had the same problem before. I am using postgres 8.1.11 and plJava
>> 1.4.0 and am running in a variant of CentOS. e-smith server. I am not
>> sure if I have the same problem that was mentioned in other threads(
>> about zlib conflict). Please let me know. Thank you very much.
>>
>>
>> On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com> wrote:
>>> Hi there,
>>>
>>> I am having some problem when trying to experiment with a hello world
>>> example. When I run the following command I am getting this error
>>> message.
>>> I am not sure what I am doing wrong.
>>> The class path seems to be correct. I have the pljava.jar file in /root/mydir
>>> How can I resolve this. Thanks,
>>>
>>> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
>>> 'helloworld_jar', false);
>>> WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>>> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
>>> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>>>
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 16:45 `
2008-10-21 16:47 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-21 16:45 UTC (permalink / raw)
Sorry to be spamming your mailbox. I am struggling to get this
resolved. I am using jdk1.5.0_11 so the zlib conflict might not be
the problem.
On Tue, Oct 21, 2008 at 11:02 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Actually my classpath is set to /root/thanesh/pljava.jar and not
> /root/mydir/pljava.jar as in the first mail.
>
>
> On Tue, Oct 21, 2008 at 11:00 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
>> Here are the info I got in the server logs.
>>
>> LOCATION: SetTransactionIdLimit, varsup.c:234
>> DEBUG: 00000: Not using integer_datetimes
>> LOCATION: checkIntTimeType,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:538
>> DEBUG: 00000: Added JVM option string
>> "-Djava.class.path=/root/thanesh/pljava.jar"
>> LOCATION: JVMOptList_add,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>> DEBUG: 00000: Added JVM option string
>> "-Dsqlj.defaultconnection=jdbc:default:connection"
>> LOCATION: JVMOptList_add,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>> DEBUG: 00000: Added JVM option string "vfprintf"
>> LOCATION: JVMOptList_add,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>> DEBUG: 00000: Added JVM option string "-Xrs"
>> LOCATION: JVMOptList_add,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>> DEBUG: 00000: Creating JavaVM
>> LOCATION: initializeJavaVM,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:640
>> DEBUG: 00000: JavaVM created
>> LOCATION: initializeJavaVM,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:660
>> DEBUG: 00000: Getting Backend class pljava.jar
>> LOCATION: initPLJavaClasses,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
>> java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>> WARNING: XX000: java.lang.NoClassDefFoundError:
>> org/postgresql/pljava/internal/Backend
>> LOCATION: elogExceptionMessage,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
>> DEBUG: 00000: Destroying JavaVM...
>> LOCATION: _destroyJavaVM,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
>> c DEBUG: 00000: JavaVM destroyed
>> LOCATION: _destroyJavaVM,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
>> ERROR: XX000: Unable to load class
>> org/postgresql/pljava/internal/Backend using CLASSPATH
>> '-Djava.class.path=/root/thanesh/pljava.jar'
>> LOCATION: PgObject_getJavaClass,
>> /home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
>>
>>
>> On Tue, Oct 21, 2008 at 10:05 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
>>> Hi there,
>>>
>>> I have read through some of the mail threads, and noticed that people
>>> had the same problem before. I am using postgres 8.1.11 and plJava
>>> 1.4.0 and am running in a variant of CentOS. e-smith server. I am not
>>> sure if I have the same problem that was mentioned in other threads(
>>> about zlib conflict). Please let me know. Thank you very much.
>>>
>>>
>>> On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com> wrote:
>>>> Hi there,
>>>>
>>>> I am having some problem when trying to experiment with a hello world
>>>> example. When I run the following command I am getting this error
>>>> message.
>>>> I am not sure what I am doing wrong.
>>>> The class path seems to be correct. I have the pljava.jar file in /root/mydir
>>>> How can I resolve this. Thanks,
>>>>
>>>> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
>>>> 'helloworld_jar', false);
>>>> WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>>>> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
>>>> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>>>>
>>>
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:45 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 16:47 `
2008-10-21 17:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-21 16:47 UTC (permalink / raw)
Is /root accessible by the user the postgresql server is running as?
Nelli Vanan wrote:
> Sorry to be spamming your mailbox. I am struggling to get this
> resolved. I am using jdk1.5.0_11 so the zlib conflict might not be
> the problem.
>
> On Tue, Oct 21, 2008 at 11:02 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
>> Actually my classpath is set to /root/thanesh/pljava.jar and not
>> /root/mydir/pljava.jar as in the first mail.
>>
>>
>> On Tue, Oct 21, 2008 at 11:00 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
>>> Here are the info I got in the server logs.
>>>
>>> LOCATION: SetTransactionIdLimit, varsup.c:234
>>> DEBUG: 00000: Not using integer_datetimes
>>> LOCATION: checkIntTimeType,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:538
>>> DEBUG: 00000: Added JVM option string
>>> "-Djava.class.path=/root/thanesh/pljava.jar"
>>> LOCATION: JVMOptList_add,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>> DEBUG: 00000: Added JVM option string
>>> "-Dsqlj.defaultconnection=jdbc:default:connection"
>>> LOCATION: JVMOptList_add,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>> DEBUG: 00000: Added JVM option string "vfprintf"
>>> LOCATION: JVMOptList_add,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>> DEBUG: 00000: Added JVM option string "-Xrs"
>>> LOCATION: JVMOptList_add,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>> DEBUG: 00000: Creating JavaVM
>>> LOCATION: initializeJavaVM,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:640
>>> DEBUG: 00000: JavaVM created
>>> LOCATION: initializeJavaVM,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:660
>>> DEBUG: 00000: Getting Backend class pljava.jar
>>> LOCATION: initPLJavaClasses,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
>>> java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>>> WARNING: XX000: java.lang.NoClassDefFoundError:
>>> org/postgresql/pljava/internal/Backend
>>> LOCATION: elogExceptionMessage,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
>>> DEBUG: 00000: Destroying JavaVM...
>>> LOCATION: _destroyJavaVM,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
>>> c DEBUG: 00000: JavaVM destroyed
>>> LOCATION: _destroyJavaVM,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
>>> ERROR: XX000: Unable to load class
>>> org/postgresql/pljava/internal/Backend using CLASSPATH
>>> '-Djava.class.path=/root/thanesh/pljava.jar'
>>> LOCATION: PgObject_getJavaClass,
>>> /home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
>>>
>>>
>>> On Tue, Oct 21, 2008 at 10:05 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
>>>> Hi there,
>>>>
>>>> I have read through some of the mail threads, and noticed that people
>>>> had the same problem before. I am using postgres 8.1.11 and plJava
>>>> 1.4.0 and am running in a variant of CentOS. e-smith server. I am not
>>>> sure if I have the same problem that was mentioned in other threads(
>>>> about zlib conflict). Please let me know. Thank you very much.
>>>>
>>>>
>>>> On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com> wrote:
>>>>> Hi there,
>>>>>
>>>>> I am having some problem when trying to experiment with a hello world
>>>>> example. When I run the following command I am getting this error
>>>>> message.
>>>>> I am not sure what I am doing wrong.
>>>>> The class path seems to be correct. I have the pljava.jar file in /root/mydir
>>>>> How can I resolve this. Thanks,
>>>>>
>>>>> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
>>>>> 'helloworld_jar', false);
>>>>> WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>>>>> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
>>>>> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>>>>>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:45 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:47 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 17:01 `
2008-10-21 17:13 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
0 siblings, 1 reply; 15+ messages in thread
From: @ 2008-10-21 17:01 UTC (permalink / raw)
Hi Kris,
I am not sure. But, I tried to move the files over to /usr/lib/pgsql
which should be accessible and tried again.
Still I am getting the same error. I believe I am missing something
fundamental.
Thanks for the response, here are the new logs.
DEBUG: 00000: Getting Backend class pljava.jar
LOCATION: initPLJavaClasses,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
WARNING: XX000: java.lang.NoClassDefFoundError:
org/postgresql/pljava/internal/Backend
LOCATION: elogExceptionMessage,
/home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
DEBUG: 00000: Destroying JavaVM...
LOCATION: _destroyJavaVM,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
DEBUG: 00000: JavaVM destroyed
LOCATION: _destroyJavaVM,
/home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
ERROR: XX000: Unable to load class
org/postgresql/pljava/internal/Backend using CLASSPATH
'-Djava.class.path=/usr/lib/pgsql/pljava.jar'
LOCATION: PgObject_getJavaClass,
/home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
On Tue, Oct 21, 2008 at 12:47 PM, Kris Jurka <jurka at ejurka.com> wrote:
> Is /root accessible by the user the postgresql server is running as?
>
> Nelli Vanan wrote:
>>
>> Sorry to be spamming your mailbox. I am struggling to get this
>> resolved. I am using jdk1.5.0_11 so the zlib conflict might not be
>> the problem.
>>
>> On Tue, Oct 21, 2008 at 11:02 AM, Nelli Vanan <ambulimama at gmail.com>
>> wrote:
>>>
>>> Actually my classpath is set to /root/thanesh/pljava.jar and not
>>> /root/mydir/pljava.jar as in the first mail.
>>>
>>>
>>> On Tue, Oct 21, 2008 at 11:00 AM, Nelli Vanan <ambulimama at gmail.com>
>>> wrote:
>>>>
>>>> Here are the info I got in the server logs.
>>>>
>>>> LOCATION: SetTransactionIdLimit, varsup.c:234
>>>> DEBUG: 00000: Not using integer_datetimes
>>>> LOCATION: checkIntTimeType,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:538
>>>> DEBUG: 00000: Added JVM option string
>>>> "-Djava.class.path=/root/thanesh/pljava.jar"
>>>> LOCATION: JVMOptList_add,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>> DEBUG: 00000: Added JVM option string
>>>> "-Dsqlj.defaultconnection=jdbc:default:connection"
>>>> LOCATION: JVMOptList_add,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>> DEBUG: 00000: Added JVM option string "vfprintf"
>>>> LOCATION: JVMOptList_add,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>> DEBUG: 00000: Added JVM option string "-Xrs"
>>>> LOCATION: JVMOptList_add,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>> DEBUG: 00000: Creating JavaVM
>>>> LOCATION: initializeJavaVM,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:640
>>>> DEBUG: 00000: JavaVM created
>>>> LOCATION: initializeJavaVM,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:660
>>>> DEBUG: 00000: Getting Backend class pljava.jar
>>>> LOCATION: initPLJavaClasses,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
>>>> java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>>>> WARNING: XX000: java.lang.NoClassDefFoundError:
>>>> org/postgresql/pljava/internal/Backend
>>>> LOCATION: elogExceptionMessage,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
>>>> DEBUG: 00000: Destroying JavaVM...
>>>> LOCATION: _destroyJavaVM,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
>>>> c DEBUG: 00000: JavaVM destroyed
>>>> LOCATION: _destroyJavaVM,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
>>>> ERROR: XX000: Unable to load class
>>>> org/postgresql/pljava/internal/Backend using CLASSPATH
>>>> '-Djava.class.path=/root/thanesh/pljava.jar'
>>>> LOCATION: PgObject_getJavaClass,
>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
>>>>
>>>>
>>>> On Tue, Oct 21, 2008 at 10:05 AM, Nelli Vanan <ambulimama at gmail.com>
>>>> wrote:
>>>>>
>>>>> Hi there,
>>>>>
>>>>> I have read through some of the mail threads, and noticed that people
>>>>> had the same problem before. I am using postgres 8.1.11 and plJava
>>>>> 1.4.0 and am running in a variant of CentOS. e-smith server. I am not
>>>>> sure if I have the same problem that was mentioned in other threads(
>>>>> about zlib conflict). Please let me know. Thank you very much.
>>>>>
>>>>>
>>>>> On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com>
>>>>> wrote:
>>>>>>
>>>>>> Hi there,
>>>>>>
>>>>>> I am having some problem when trying to experiment with a hello world
>>>>>> example. When I run the following command I am getting this error
>>>>>> message.
>>>>>> I am not sure what I am doing wrong.
>>>>>> The class path seems to be correct. I have the pljava.jar file in
>>>>>> /root/mydir
>>>>>> How can I resolve this. Thanks,
>>>>>>
>>>>>> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
>>>>>> 'helloworld_jar', false);
>>>>>> WARNING: java.lang.NoClassDefFoundError:
>>>>>> org/postgresql/pljava/internal/Backend
>>>>>> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
>>>>>> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>>>>>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:45 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:47 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 17:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
@ 2008-10-21 17:13 `
0 siblings, 0 replies; 15+ messages in thread
From: @ 2008-10-21 17:13 UTC (permalink / raw)
My bad. Sorry, your last hint solved the problem Kris. Thanks a lot.
When I was doing the last test, I did not have pljava.jar in
/usr/lib/pgsql.
Thanks a lot.
On Tue, Oct 21, 2008 at 1:01 PM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Hi Kris,
>
> I am not sure. But, I tried to move the files over to /usr/lib/pgsql
> which should be accessible and tried again.
> Still I am getting the same error. I believe I am missing something
> fundamental.
> Thanks for the response, here are the new logs.
>
> DEBUG: 00000: Getting Backend class pljava.jar
> LOCATION: initPLJavaClasses,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
> java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
> WARNING: XX000: java.lang.NoClassDefFoundError:
> org/postgresql/pljava/internal/Backend
> LOCATION: elogExceptionMessage,
> /home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
> DEBUG: 00000: Destroying JavaVM...
> LOCATION: _destroyJavaVM,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
> DEBUG: 00000: JavaVM destroyed
> LOCATION: _destroyJavaVM,
> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
> ERROR: XX000: Unable to load class
> org/postgresql/pljava/internal/Backend using CLASSPATH
> '-Djava.class.path=/usr/lib/pgsql/pljava.jar'
> LOCATION: PgObject_getJavaClass,
> /home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
>
>
>
>
> On Tue, Oct 21, 2008 at 12:47 PM, Kris Jurka <jurka at ejurka.com> wrote:
>> Is /root accessible by the user the postgresql server is running as?
>>
>> Nelli Vanan wrote:
>>>
>>> Sorry to be spamming your mailbox. I am struggling to get this
>>> resolved. I am using jdk1.5.0_11 so the zlib conflict might not be
>>> the problem.
>>>
>>> On Tue, Oct 21, 2008 at 11:02 AM, Nelli Vanan <ambulimama at gmail.com>
>>> wrote:
>>>>
>>>> Actually my classpath is set to /root/thanesh/pljava.jar and not
>>>> /root/mydir/pljava.jar as in the first mail.
>>>>
>>>>
>>>> On Tue, Oct 21, 2008 at 11:00 AM, Nelli Vanan <ambulimama at gmail.com>
>>>> wrote:
>>>>>
>>>>> Here are the info I got in the server logs.
>>>>>
>>>>> LOCATION: SetTransactionIdLimit, varsup.c:234
>>>>> DEBUG: 00000: Not using integer_datetimes
>>>>> LOCATION: checkIntTimeType,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:538
>>>>> DEBUG: 00000: Added JVM option string
>>>>> "-Djava.class.path=/root/thanesh/pljava.jar"
>>>>> LOCATION: JVMOptList_add,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>>> DEBUG: 00000: Added JVM option string
>>>>> "-Dsqlj.defaultconnection=jdbc:default:connection"
>>>>> LOCATION: JVMOptList_add,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>>> DEBUG: 00000: Added JVM option string "vfprintf"
>>>>> LOCATION: JVMOptList_add,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>>> DEBUG: 00000: Added JVM option string "-Xrs"
>>>>> LOCATION: JVMOptList_add,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:436
>>>>> DEBUG: 00000: Creating JavaVM
>>>>> LOCATION: initializeJavaVM,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:640
>>>>> DEBUG: 00000: JavaVM created
>>>>> LOCATION: initializeJavaVM,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:660
>>>>> DEBUG: 00000: Getting Backend class pljava.jar
>>>>> LOCATION: initPLJavaClasses,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:124
>>>>> java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
>>>>> WARNING: XX000: java.lang.NoClassDefFoundError:
>>>>> org/postgresql/pljava/internal/Backend
>>>>> LOCATION: elogExceptionMessage,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/JNICalls.c:74
>>>>> DEBUG: 00000: Destroying JavaVM...
>>>>> LOCATION: _destroyJavaVM,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:374
>>>>> c DEBUG: 00000: JavaVM destroyed
>>>>> LOCATION: _destroyJavaVM,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/Backend.c:383
>>>>> ERROR: XX000: Unable to load class
>>>>> org/postgresql/pljava/internal/Backend using CLASSPATH
>>>>> '-Djava.class.path=/root/thanesh/pljava.jar'
>>>>> LOCATION: PgObject_getJavaClass,
>>>>> /home/jurka/pg/pljava/pljava/src/C/pljava/PgObject.c:116
>>>>>
>>>>>
>>>>> On Tue, Oct 21, 2008 at 10:05 AM, Nelli Vanan <ambulimama at gmail.com>
>>>>> wrote:
>>>>>>
>>>>>> Hi there,
>>>>>>
>>>>>> I have read through some of the mail threads, and noticed that people
>>>>>> had the same problem before. I am using postgres 8.1.11 and plJava
>>>>>> 1.4.0 and am running in a variant of CentOS. e-smith server. I am not
>>>>>> sure if I have the same problem that was mentioned in other threads(
>>>>>> about zlib conflict). Please let me know. Thank you very much.
>>>>>>
>>>>>>
>>>>>> On Mon, Oct 20, 2008 at 4:19 PM, Nelli Vanan <ambulimama at gmail.com>
>>>>>> wrote:
>>>>>>>
>>>>>>> Hi there,
>>>>>>>
>>>>>>> I am having some problem when trying to experiment with a hello world
>>>>>>> example. When I run the following command I am getting this error
>>>>>>> message.
>>>>>>> I am not sure what I am doing wrong.
>>>>>>> The class path seems to be correct. I have the pljava.jar file in
>>>>>>> /root/mydir
>>>>>>> How can I resolve this. Thanks,
>>>>>>>
>>>>>>> SELECT sqlj.install_jar('file:///root/mydir/hello.jar',
>>>>>>> 'helloworld_jar', false);
>>>>>>> WARNING: java.lang.NoClassDefFoundError:
>>>>>>> org/postgresql/pljava/internal/Backend
>>>>>>> ERROR: Unable to load class org/postgresql/pljava/internal/Backend
>>>>>>> using CLASSPATH '-Djava.class.path=/root/mydir/pljava.jar'
>>>>>>>
>>> _______________________________________________
>>> Pljava-dev mailing list
>>> Pljava-dev at pgfoundry.org
>>> http://pgfoundry.org/mailman/listinfo/pljava-dev
>>
>>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2008-10-21 17:13 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-15 18:03 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/usr/lib64/pgsql/pljava.jar'
2006-08-15 19:44 `
2006-08-15 23:32 `
2006-08-16 06:01 `
2006-08-16 06:50 `
2006-08-16 08:02 `
2006-08-16 11:32 `
2008-10-20 20:19 [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 14:05 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:00 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 15:02 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:45 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 16:47 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 17:01 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
2008-10-21 17:13 ` [Pljava-dev] Unable to load class org/postgresql/pljava/internal/Backend
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox