[Pljava-dev] Re: ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so

Rodrigo,

> First, thank you for your response. I'm very interested in your
> project.
> I will go write my Oracle Stored Procedures (PL/SQL) and PL/PGSQL
> Stored Procedures in JAVA.
> 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
> i try now $JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client
> but the error continue.
> I'm executing "java org.postgresql.pljava.deploy.Deployer -install
> -user postgres -database teste" as user postgres. Correct ? Are
> permissions maybe ?

I doubt it's a permission problem. I'm not fluent in Spanish but I guess
that "Arquivo ou diret?o n?encontrado" is "No such file or directory"?
If that is the case, it means the it does find libjava.so and then
either does not find the libjvm.so or one of it's dependents.

For what process is the LD_LIBRARY_PATH in effect? Perhaps you set it
for the client process (i.e. the java command)? If so, that's the
problem. The LD_LIBRARY_PART must be exported so that it is available to
the postmaster server process. The client java process doesn't need it
at all.

Regards,

Thomas Hallgren