From: ambulimama at gmail.com (Nelli Vanan)
Date: Tue, 21 Oct 2008 13:01:44 -0400
Subject: [Pljava-dev] Unable to load class
	org/postgresql/pljava/internal/Backend
In-Reply-To: <48FE07A8.4020707@ejurka.com>
References: <6d7730550810201319h569e51bav5053dbee54500077@mail.gmail.com>
	<6d7730550810210705r745e2078i8d029890ce714543@mail.gmail.com>
	<6d7730550810210800m4f5294d9xe45457e5765fab4d@mail.gmail.com>
	<6d7730550810210802q4f1fdb65m244e979122be7ce3@mail.gmail.com>
	<6d7730550810210945v41758b50ve6eee86e01bde7eb@mail.gmail.com>
	<48FE07A8.4020707@ejurka.com>
Message-ID: <6d7730550810211001v29b436d6n40c6155947475d8d@mail.gmail.com>

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