[Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local

Yep, good tip!!!

Yep, with that tip I've finally overcame the problem!!!

I've changed the script "/etc/init.d/postgres", now I export the
LD_LIBRAY_PATH just before starting the postmaster:

#------ /etc/init.d/postgres --------------------------
echo -n "$PSQL_START"
$SU -l postgres -c "export
LD_LIBRARY_PATH=/usr/java/j2sdk1.4.2_08/jre/lib:/usr/java/j2sdk1.4.2_08/jre/
lib/i386/client:/usr/java/j2sdk1.4.2_08/jre/lib/i386/native_threads
;$PGENGINE/postmaster -p '$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG"
2>&1 < /dev/null
#------------------------------------------------------

There must be other solutions, but for now this one solves my problem :)

Thanks to all, without you I wouldn't be able to overcome that problem.

M.P.Garcia

> Where can I configure that???
>
You define the relevant LD_LIBRARY_PATH by exporting it just before you
start the postmaster deamon. That deamon will then propagate the setting
to all backend processes that it spawns, thus making the LD_LIBRARY_PATH
visible to libpljava.so.

- thomas