[Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so

Gulden wrote:

> Hi,
>
> I?m geting this error when I?m deployng PLJava:
>
> export
> LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/:$JAVA_HOME/jre/lib/i386/native_threads:.
> ; java -cp
> /var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.jar
> org.postgresql.pljava.deploy.Deployer -reinstall -user compiere
> -database cmpcs
>
> java.sql.SQLException: ERROR: could not load library
> "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared
> object file: No such file or directory
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:313)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:305)
>
> at
> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:419)
>
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
> Any tips???
>
Yes, it seems you try to export the LD_LIBRARY_PATH for the benefit of
the client program. The client doesn't care about the LD_LIBRARY_PATH.
The postmaster backend does.

Regards,
Thomas Hallgren