From: ambulimama at gmail.com (Nelli Vanan)
Date: Tue, 21 Oct 2008 13:13:04 -0400
Subject: [Pljava-dev] Unable to load class
	org/postgresql/pljava/internal/Backend
In-Reply-To: <6d7730550810211001v29b436d6n40c6155947475d8d@mail.gmail.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>
	<6d7730550810211001v29b436d6n40c6155947475d8d@mail.gmail.com>
Message-ID: <6d7730550810211013q5453ced4raaa86d78da40ef58@mail.gmail.com>

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