From: thhal at mailblocks.com (Thomas Hallgren)
Date: Fri, 01 Apr 2005 08:11:55 +0200
Subject: [Pljava-dev] java.sql.SQLException: ERROR: could not load library
	"/usr/local/pgsql/lib/libpljava.so": libjvm.so
In-Reply-To: <200504010045.j310jRnn001537@localhost.localdomain>
References: <200504010045.j310jRnn001537@localhost.localdomain>
Message-ID: <424CE62B.6060300@mailblocks.com>

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