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

[Thomas Hallgren]

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