From: michael.zintakis at googlemail.com (Michael Zintakis) Date: Tue, 20 Dec 2005 21:17:49 +0000 Subject: [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01) Message-ID: <71622ed30512201317ub53ab7we59f8c9c63451b10@mail.gmail.com> Hi, my OS is Linux 8, 32bit, PostgreSQL 8.1.1 (operating successfully) and Java 1.5.0._01 also running Ok as well. When I use the pre-compiled binary for pljava 1.2 and trying to run the sql statement in install.sql for installing the language handler (which in turns refers to libpljava) I get the following error: ERROR: could not load library "/usr/local/pg81/lib/libpljava.so": /usr/local/pg81/lib/libpljava.so: symbol JNI_CreateJavaVM, version SUNWprivate_1.1 not defined in file libjvm.so with link time reference I am baffled! I checked the following: JAVA_HOME is set PGDATA is also set LD_LIBRARY_PATH is also set as per the instructions in the readme file for pljava. For good measure I also included the 3 directories (including the 'native_threads' one) in the /etc/ld.so.conf file and executed ldconfig. I can see all java libraries in the list (ldconfig -p | grep jvm) - no problem there. In postgresql.conf I have dynamic_library_path set to '$libdir:' (I know it wouldn't make any difference, but I added it anyway). What could that be? Any ideas would be very much appreciated!! Michael -------------- next part -------------- An HTML attachment was scrubbed... URL: