From: michael.zintakis at googlemail.com (Michael Zintakis)
Date: Tue, 20 Dec 2005 23:14:11 +0000
Subject: [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1,
	Java 1.5.0_01)
In-Reply-To: <43A88CC2.9040205@tada.se>
References: <71622ed30512201317ub53ab7we59f8c9c63451b10@mail.gmail.com>
	<43A88CC2.9040205@tada.se>
Message-ID: <71622ed30512201514u5dae2070h99b1ea0a2ea0475c@mail.gmail.com>

Thomas,

Did that (that was my first assumption as well) - built pljava from
source on the same machine - nada! Same error occurs!

What I also can't figure out is what exactly does that error means? Is
this some sort of a link problem (between Java and plJava) or what?


On 12/20/05, Thomas Hallgren <thomas at tada.se> wrote:
> 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
> >
>
>