<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Here is my
dynamic_library_path in postgresql.conf<br>
dynamic_library_path =
'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'<br>
<br>
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)<br>
<br>
Here is what my LD_LIBRARY_PATH looks like:<br>
LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/
export LD_LIBRARY_PATH<br>
<br>
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<br>
<br>
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.<br>
<br>
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.<br>
</font></font><br>
Michael Judd wrote:
<blockquote cite="mid1118190465.5061.497.camel@laptop01.jaztek.co.uk"
type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">
____________________________________________________________________
Subject: Unable to load class org/postgresql/plsql/internal/Backend
From: Michael Judd <a class="moz-txt-link-rfc2396E" href="mailto:michael.judd@jaztek.co.uk"><michael.judd@jaztek.co.uk></a>
Date: Tue, 07 Jun 2005 23:46:25 +0100
To: <a class="moz-txt-link-abbreviated" href="mailto:pljava-dev@gborg.postgresql.org">pljava-dev@gborg.postgresql.org</a>
To: <a class="moz-txt-link-abbreviated" href="mailto:pljava-dev@gborg.postgresql.org">pljava-dev@gborg.postgresql.org</a>
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('<a class="moz-txt-link-freetext" href="file://opt/pgsql/lib/sqlj.jar">file://opt/pgsql/lib/sqlj.jar</a>','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
<a class="moz-txt-link-abbreviated" href="mailto:Pljava-dev@gborg.postgresql.org">Pljava-dev@gborg.postgresql.org</a>
<a class="moz-txt-link-freetext" href="http://gborg.postgresql.org/mailman/listinfo/pljava-dev">http://gborg.postgresql.org/mailman/listinfo/pljava-dev</a>
</pre>
</blockquote>
<pre wrap="">--
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
<a class="moz-txt-link-abbreviated" href="mailto:vclark@globalera.com">vclark@globalera.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.globalera.com">www.globalera.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<font face="helvetica, arial" size="small">Vince Clark
<br>
Global Era
<br>
The freedom of open source.
<br>
(303) 493-6723
<br>
(303) 455-2409 fax
<br>
<a href="mailto:vclark@globalera.com">vclark@globalera.com</a>
<br>
<a href="www.globalera.com">www.globalera.com</a>
</font></div>
</body>
</html>