From: thomas at tada.se (Thomas Hallgren)
Date: Tue, 20 Dec 2005 23:59:14 +0100
Subject: [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1,
	Java 1.5.0_01)
In-Reply-To: <71622ed30512201317ub53ab7we59f8c9c63451b10@mail.gmail.com>
References: <71622ed30512201317ub53ab7we59f8c9c63451b10@mail.gmail.com>
Message-ID: <43A88CC2.9040205@tada.se>

Hi Michael,
Very odd indeed. Sounds like it could stem from version 
incompatibilities with the JVM. If you can, try an upgrade. I think the 
pre-compiled libpljava.so is compiled using jdk-1.5.0_05.

- thomas

Michael Zintakis wrote:
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>