<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><BASE
href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\">
<STYLE>BODY {
BACKGROUND-POSITION: left top; MARGIN-TOP: 130px; FONT-SIZE: 10pt; MARGIN-LEFT: 10px; COLOR: #000080; BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Tahoma
}
</STYLE>
<META content="MSHTML 6.00.2737.800" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff background=cid:00fd01c47fc0$4da601f0$0164a8c0@ipe>
<DIV>Hi Thomas,</DIV>
<DIV> </DIV>
<DIV>> I am getting the following error message when i am trying to deploy
<BR>> pl/java<BR>> <BR>> java.sql.SQLException: ERROR:
could not load library <BR>> "/postgresql-7.4.2/libpljava.so": libjvm.so:
cannot open shared object <BR>> file: Arquivo ou diret?o
n?encontrado<BR>> <BR>>Your LD_LIBRARY_PATH points to the
$JAVA_HOME/jre/lib/i386/server but <BR>>not to the directory above it where a
lot of neede shared object files <BR>>reside. The error reported from the
shared object loader is probably <BR>>somewhat misleading. It does indeed
find the libjvm.so but it fails on <BR>>one of its dependencies. Try this
setting
instead:<BR>>$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client<BR>>Regards,<BR>><BR>>Thomas
Hallgren</DIV>
<DIV> </DIV>
<DIV>
<DIV> First, thank you for your response. I'm very interested
in your project. </DIV>
<DIV> I will go write my Oracle Stored Procedures
(PL/SQL) and PL/PGSQL Stored Procedures in JAVA.</DIV>
<DIV> I was tested three days ago
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client and how
not run I put "/server" because I found libjvm.so in this directory. It was a
tentative. Not Run, then</DIV>
<DIV> i try now
$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client but the error continue.
</DIV>
<DIV> I'm executing "java
org.postgresql.pljava.deploy.Deployer -install -user postgres -database teste"
as user postgres. Correct ? Are permissions maybe ? </DIV>
<DIV> </DIV></DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV>Rodrigo - Syspoint<BR></DIV></BODY></HTML>