[Pljava-dev] PL/Java deploy error

Hi all,

After successful compilation, I'm receiving error on deploying pl/java
"libjvm.so: open failed: No such file or directory"

I found similar error on

http://gborg.postgresql.org/project/pljava/genpage.php?readme
http://gborg.postgresql.org/pipermail/pljava-dev/2004/000025.html

So, tried to set LD_LIBRARY_PATH and JAVA_HOME but error remains the
same.

Please suggest on that how should I correct it.

Thanks in advance.

YinYin

# java -version
java version "1.5.0_07"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03)
Java HotSpot(TM) Server VM (build 1.5.0_07-b03, mixed mode)

# echo $JAVA_HOME
/usr/jdk/instances/jdk1.5.0

# echo $LD_LIBRARY_PATH
/lib:/usr/lib:/usr/X/lib:/usr/local/lib:/usr/local/apr/lib:/usr/local/ss
l/lib:/usr/jdk/instances/jdk1.5.0/jre/lib:/usr/jdk/instances/jdk1.5.0/jr
e/lib/sparc:/usr/jdk/instances/jdk1.5.0/jre/lib/sparc/client:/usr/jdk/in
stances/jdk1.5.0/jre/lib/sparc/native_threads:/usr/jdk/instances/jdk1.5.
0/lib:/usr/local/apache-tomcat-5.5.17/lib

# ls -l /usr/jdk/instances/jdk1.5.0/jre/lib/sparc/client/libjvm.so
-rwxr-xr-x 1 root bin 6879100 May 3 2006
/usr/jdk/instances/jdk1.5.0/jre/lib/sparc/client/libjvm.so

# ls -l /usr/lib/pljava/pljava.so
-rwxr-xr-x 1 root bin 465636 Aug 7 13:49
/usr/lib/pljava/pljava.so

# java -cp /ir/dspace/lib/postgresql.jar:/usr/lib/pljava/deploy.jar
org.postgresql.pljava.deploy.Deployer -install -database dspace
org.postgresql.util.PSQLException: ERROR: could not load library
"/usr/lib/pljava/pljava.so": ld.so.1: postgres: fatal: libjvm.so: open
failed: No such file or directory
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:332)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474
)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)

-----Original Message-----
From: Thomas Hallgren [mailto:thomas at tada.se]
Sent: Wednesday, 1 August 2007 6:55 p.m.
To: bill.rea at canterbury.ac.nz
Cc: Kris Jurka; Yin Latt
Subject: Re: [Pljava-dev] PL/Java 1.3 compilation error on Solaris

Hi Bill,
Anonymous unions is not a GNU invention. It's supported by many C
compilers besides the GNU compiler. HP, AIX, Windows, to name a few. The

Solaris compiler is actually the first compiler I've encountered that is

incapable of handling this. The compiler Kris is using is quite old (he
claimed it was) and the brand new compiler you use is incapable of
anonymous unions. So I stick to my opion :-)

- thomas

Bill Rea wrote:
> Thomas,
>
>
>> Although I'm somewhat unhappy with the ugliness introduced when we
are
>> forced to compile with very old (or incapable) compilers, I'm fine
with
>> the patch and I agree that PL/Java should compile on this platform.
>> Please apply this patch.
>>
>
> I was using Sun's Studio 11 with the latest patch set applied. This is
the
> latest compiler release from Sun. So the compilers are neither old nor
> incapable. Just an observation on my part, this software does seem to
> have been developed on the assumption that people will be using the
gnu
> development tools to compile and install it. This is a common practice
in
> the open software community but, rightly or wrongly, not all the world
has
> gone down the path of GNU/Linux.
>
> Kris's patch fixed the compile problems and the software is now
> installed.
>
> Thanks for your help.
>
> Bill Rea, ICT Services, University of Canterbury \_
> E-Mail bill.rea at canterbury.ac.nz </ New
> Phone 64-3-364-2331, Fax 64-3-364-2332 /) Zealand
> Unix Systems Administrator (/'
>