From: gulden at portugalmail.pt (Gulden)
Date: Sun, 3 Apr 2005 19:18:12 +0100
Subject: [Pljava-dev] java.sql.SQLException:
	ERROR:could	not	loadlibrary"/usr/local
In-Reply-To: <424DC1E7.4040803@mailblocks.com>
Message-ID: <200504031817.j33IH0nn008018@localhost.localdomain>

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