agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
Date: Tue, 07 Jun 2005 19:08:58 -0600
Message-ID: <42A6452A.3000503@globalera.com> (raw)
In-Reply-To: <1118190465.5061.497.camel@laptop01.jaztek.co.uk>
References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
<42A62AE9.8060309@globalera.com>
<1118190465.5061.497.camel@laptop01.jaztek.co.uk>
Here is my dynamic_library_path in postgresql.conf
dynamic_library_path =
'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
Note that I am running an AMD64 so things will look slightly different.
The key in this line is that this path points to a directory that
contains a file called libjvm.so. In some JVM's I have seen that file
under jre/lib/client (rather than /server)
Here is what my LD_LIBRARY_PATH looks like:
LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/
export LD_LIBRARY_PATH
In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
created soft links with the proper file name of pljava.so
Also, you may run into another problem once you get past the library
path issue. I was unable to install pljava using a 1.5.x JDK. I ended up
using Blackdown 1.4.2. It has something to do with being able to spawn a
VM from within Postgres. I don't remember exactly.
Finally, I'm serious about restarting postgres. I did two installations
where the path settings were right but I had to restart postgres before
I could successfully add pljava as a language in the database.
Michael Judd wrote:
>Hi,
>
>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
>This now matches my dynamic_library_path in postgresql.conf
>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
>
>I'm still getting exactly the same problem.
>
>Thanks for your help.
>
>
>
>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
>
>
>>Michael
>>
>>You said you were having trouble installing plsql. Do you mean pljava?
>>
>>Be sure you also have LD_LIBRARY_PATH set with the same values.
>>
>>Once the library path is established in both places (LD_LIBRARY_PATH)
>>and postgresql.conf) I found that restarting postgres before trying to
>>install pljava solved the problem.
>>
>>Michael Judd wrote:
>>
>>
>>>____________________________________________________________________
>>>
>>>Subject: Unable to load class org/postgresql/plsql/internal/Backend
>>>From: Michael Judd <michael.judd at jaztek.co.uk>
>>>Date: Tue, 07 Jun 2005 23:46:25 +0100
>>>To: pljava-dev at gborg.postgresql.org
>>>To: pljava-dev at gborg.postgresql.org
>>>
>>>Hi,
>>>
>>>I'm having trouble installing plsql and I'm getting the following:
>>>
>>>Unable to load class org/postgresql/plsql/internal/Backend using
>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>>
>>>when issuing the command to pgsql:
>>>
>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>>
>>>I have checked that:
>>>- pljava.jar is in /opt/pgsql/pljava/build
>>>- sqlj.jar is in /opt/pgsql/lib
>>>
>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>>$libdir' where libpljava.so, plpgsql.so resides.
>>>
>>>my paths are:
>>> - postgres /opt/pgsql
>>> - pljava /opt/pgsql/pljava
>>> - data /opt/pgsql/pg_data
>>>
>>>Fedora Core 3 x86_64smp
>>>
>>>I've double checked that Backend is located in the jar exactly where it
>>>is supposed to be - so the error being displayed doesn't seem to point
>>>in the 'right' direction.
>>>
>>>Any ideas ?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>____________________________________________________________________
>>>
>>>_______________________________________________
>>>Pljava-dev mailing list
>>>Pljava-dev at gborg.postgresql.org
>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>
>>>
>>>
>>--
>>Vince Clark
>>Global Era
>>The freedom of open source.
>>(303) 493-6723
>>(303) 455-2409 fax
>>vclark at globalera.com
>>www.globalera.com
>>
>>
>
>
>
--
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
vclark at globalera.com <mailto:vclark at globalera.com>
www.globalera.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050607/74be5cd4/attachment.html;
view thread (14+ messages) latest in thread
Message-ID: <42A6452A.3000503@globalera.com>
Permalink: ../42A6452A.3000503@globalera.com/
Also on: postgresql.org/message-id/42A6452A.3000503@globalera.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
In-Reply-To: <42A6452A.3000503@globalera.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox