[Pljava-dev] could not access file " libpljava " : No such file or directory

Alex,
My guess is that the LD_LIBRARY_PATH that you export in the .bashrc
isn't available to the PostgreSQL backend. Only the backend process (the
postmaster) needs the LD_LIBRARY_PATH setting. .bashrc for the root
account doesn't seemt to be the right place to put it.

The error you get from PostgreSQL is probably propagated from the
loader. The loader does find the libpljava.so but when it tries to load
it, it fails to find the stuff that's needed from the Java installation.

Regards,
Thomas Hallgren

JAlex Alex wrote:

>Hello everyone
>Really hope to get a peace of advice from you.
>Searching this maillist didn't help me anyhow.
>----------------
>Linux 2.6.12-1.1387_FC4 #1 Fri Jul 1 12:40:13 EDT 2005 x86_64 x86_64 x86_64 GNU/Linu
>
>(PostgreSQL) 8.0.3
>
>Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_04-b05)
>Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_04-b05, mixed mode)
>
>pljava-1.1.0
>
>-----------------
>/home/root/.bashrc
>
>export JAVA_HOME=/usr/local/java/jdk1.5
>export ANT_HOME=/usr/local/java/ant
>export PATH=${ANT_HOME}/bin:${PATH}
>export LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/amd64:$JAVA_HOME/jre/lib/amd64/native_threads:$JAVA_HOME/jre/lib/amd64/server
>
>-----------------
>/var/lib/pgsql/data/postgresql.conf
>
>dynamic_library_path = '$libdir:/usr/local/java/javalibs/pljava-1.1.0/build/objs'
>custom_variable_classes = 'pljava'
>pljava.classpath = '/usr/local/java/javalibs/pljava-1.1.0/build/pljava.jar'
>------------------
>
>when trying to run
>java org.postgresql.pljava.deploy.Deployer -install
>
>jjava.sql.SQLException: ERROR: could not access file "libpljava": 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)
>....
>-------------------
>the postgresql log file
>
>DEBUG: ProcessUtility
>DEBUG: find_in_dynamic_libpath: trying "/usr/lib64/pgsql/libpljava"
>DEBUG: find_in_dynamic_libpath: trying "/usr/local/java/javalibs/pljava-1.1.0/build/objs/libpljava"
>DEBUG: find_in_dynamic_libpath: trying "/usr/lib64/pgsql/libpljava.so"
>DEBUG: find_in_dynamic_libpath: trying "/usr/local/java/javalibs/pljava-1.1.0/build/objs/libpljava.so"
>ERROR: could not access file "libpljava": No such file or directory
>-------------------
>
>Of course there is such file /usr/local/java/javalibs/pljava-1.1.0/build/objs/libpljava.so
>But there is no such file libpljava
>Why does it looks for that file?
>
>Can anyone explain me what's happening ?
>How to fight this problem?
>
>thanks in advance
>
>Alex
>
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>