agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
6+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
@ 2005-12-20 21:17
0 siblings, 1 reply; 6+ messages in thread
From: @ 2005-12-20 21:17 UTC (permalink / raw)
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: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20051220/c9c05d5c/attachment.html;
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
@ 2005-12-20 22:59
parent:
0 siblings, 1 reply; 6+ messages in thread
From: @ 2005-12-20 22:59 UTC (permalink / raw)
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
@ 2005-12-20 23:14
parent:
0 siblings, 1 reply; 6+ messages in thread
From: @ 2005-12-20 23:14 UTC (permalink / raw)
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
> >
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
@ 2005-12-21 00:00
parent:
0 siblings, 1 reply; 6+ messages in thread
From: @ 2005-12-21 00:00 UTC (permalink / raw)
On 20-Dec-05, at 5:14 PM, Michael Zintakis wrote:
> 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?
Does ldd libpljava.so show any missing libraries?
Rakesh
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
@ 2005-12-21 06:28
parent:
0 siblings, 0 replies; 6+ messages in thread
From: @ 2005-12-21 06:28 UTC (permalink / raw)
Exactly what Linux is it you're running and on what platform? Would it
be possible for you to compile a new binary from source?
- thomas
Rakesh Vidyadharan wrote:
>
> On 20-Dec-05, at 5:14 PM, Michael Zintakis wrote:
>
>> 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?
>
> Does ldd libpljava.so show any missing libraries?
>
> Rakesh
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01) - SOLVED
@ 2005-12-21 19:17
0 siblings, 0 replies; 6+ messages in thread
From: @ 2005-12-21 19:17 UTC (permalink / raw)
Yep, solved today. It was me to blame...
It was all to do with ldconfig - it was picking up a wrong version of
libjvm.so (we have a separately, i.e. custom, built JVM so the
libjvm.so was picked up by ldconfig from there instead of Sun's
$JAVA_HOME). Our JVM has now been relocated to another server, after
which I installed pljava without a hitch...
There is another problem however, but I will raise a different thread for it.
Many thanks for your support guys.
On 12/21/05, Thomas Hallgren <thomas at tada.se> wrote:
> Exactly what Linux is it you're running and on what platform? Would it
> be possible for you to compile a new binary from source?
>
> - thomas
>
> Rakesh Vidyadharan wrote:
> >
> > On 20-Dec-05, at 5:14 PM, Michael Zintakis wrote:
> >
> >> 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?
> >
> > Does ldd libpljava.so show any missing libraries?
> >
> > Rakesh
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-12-21 19:17 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-20 21:17 [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01)
2005-12-20 22:59 `
2005-12-20 23:14 `
2005-12-21 00:00 `
2005-12-21 06:28 `
2005-12-21 19:17 [Pljava-dev] libpljava.so problem (pljava 1.2, PG 8.1, Java 1.5.0_01) - SOLVED
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox