From: | vclark at globalera(dot)com (Vince Clark) |
---|---|
To: | |
Subject: | [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend] |
Date: | 2005-06-08 01:08:58 |
Message-ID: | 42A6452A.3000503@globalera.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2005-06-08 06:23:22 | [Pljava-dev] Obtaining Query from Trigger |
Previous Message | Michael Judd | 2005-06-08 00:27:45 | [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend] |