From: jurka at ejurka.com (Kris Jurka)
Date: Tue, 21 Oct 2008 09:47:36 -0700
Subject: [Pljava-dev] Unable to load
	class	org/postgresql/pljava/internal/Backend
In-Reply-To: <6d7730550810210945v41758b50ve6eee86e01bde7eb@mail.gmail.com>
References: <6d7730550810201319h569e51bav5053dbee54500077@mail.gmail.com>
	<6d7730550810210705r745e2078i8d029890ce714543@mail.gmail.com>
	<6d7730550810210800m4f5294d9xe45457e5765fab4d@mail.gmail.com>
	<6d7730550810210802q4f1fdb65m244e979122be7ce3@mail.gmail.com>
	<6d7730550810210945v41758b50ve6eee86e01bde7eb@mail.gmail.com>
Message-ID: <48FE07A8.4020707@ejurka.com>

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