PL/Java installation failed: Undefined symbol "pthread_create"

[Bahman Movaqar]

Hi all,

I've ran into problems installing PL/Java on FreeBSD.  Below are the
software configurations I use:
$ uname -a 
FreeBSD movaqar 6.2-RELEASE FreeBSD 6.2-RELEASE #0: Fri Jan 12 11:05:30
UTC 2007     root at dessler.cse.buffalo.edu:/usr/obj/usr/src/sys/SMP  i386

$ psql --version
psql (PostgreSQL) 8.2.5
contains support for command-line editing

$ java -version
java version "1.5.0_13-p7"
Java(TM) 2 Runtime Environment, Standard Edition (build
1.5.0_13-p7-root_12_dec_2007_15_19) Java HotSpot(TM) Client VM (build
1.5.0_13-p7-root_12_dec_2007_15_19, mixed mode)

$ cat /etc/rc.conf | grep ldconfig
ldconfig_paths="/usr/lib/compat /usr/X11R6/lib /usr/local/lib /usr/local/lib/compat/pkg /usr/local/jdk1.5.0/jre/lib/i386 /usr/local/jdk1.5.0/jre/lib/i386/client /usr/local/jdk1.5.0/jre/lib/i386/native_threads"

I have also Diablo-JDK-1.5.0_07 installed.

PL/Java sources compile fine without any warnings; then I change
'postgresql.conf' to add the 'pljava' section.  No problems yet.
But when I run the deployer (JAR or SQL) program to install it into the
database, this is what I get:

psql:/usr/local/pljava/install.sql:6: ERROR:  could not load library
"/usr/local/pljava/lib/pljava.so": dlopen
(/usr/local/pljava/lib/pljava.so)
failed: /usr/local/jdk1.5.0/jre/lib/i386/client/libjvm.so: Undefined
symbol "pthread_create" psql:/usr/local/pljava/install.sql:8: ERROR:
function sqlj.java_call_handler() does not exist
psql:/usr/local/pljava/install.sql:12: ERROR:  could not load library
"/usr/local/pljava/lib/pljava.so": dlopen
(/usr/local/pljava/lib/pljava.so)
failed: /usr/local/jdk1.5.0/jre/lib/i386/client/libjvm.so: Undefined
symbol "pthread_create" psql:/usr/local/pljava/install.sql:14: ERROR:
function sqlj.javau_call_handler() does not exist

BTW, I have done PL/Java installation on PG 8.2.4 before without any
problems.  Could the version of PG be the source of the trouble?

Any idea/hint is highly appreciated.

TIA,

-- 
Bahman Movaqar
PGP KeyID: 0x0CE28F5C (keyserver2.pgp.com)

The most prevalent philosophy in application security is that security
should not be added as an after thought, but should be included by
design and default.
-Frank Nimphius
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-java/attachments/20071216/1b61ba09/signature.pgp