[Pljava-dev] pljava 1.4.0 install problem

Hi,
I continued to solve my problem.

I try to install the 64-bit pljava version:
pljava-x86_64-unknown-linux-gnu-pg8.2-1.4.0.tar.gz

But after running install.sql i receive:

ERROR: could not load library "/usr/share/pljava/pljava.so":
libjvm.so: cannot open shared object file: No such file or directory
ERROR: function sqlj.java_call_handler() does not exist
ERROR: could not load library "/usr/share/pljava/pljava.so":
libjvm.so: cannot open shared object file: No such file or directory
ERROR: function sqlj.javau_call_handler() does not exist
NOTICE: CREATE TABLE will create implicit sequence
"jar_repository_jarid_seq" for serial column "jar_repository.jarid"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"jar_repository_pkey" for table "jar_repository"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"jar_repository_jarname_key" for table "jar_repository"
NOTICE: CREATE TABLE will create implicit sequence
"jar_entry_entryid_seq" for serial column "jar_entry.entryid"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"jar_entry_pkey" for table "jar_entry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"jar_entry_jarid_key" for table "jar_entry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"classpath_entry_pkey" for table "classpath_entry"
NOTICE: CREATE TABLE will create implicit sequence
"typemap_entry_mapid_seq" for serial column "typemap_entry.mapid"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"typemap_entry_pkey" for table "typemap_entry"
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist
ERROR: language "java" does not exist

I think the problem is into libjvm.so, but :
If i execute :
set | grep LD_LIBRARY_PATH
LD_LIBRARY_PATH=/usr/local/java/j2sdk/jre/lib/i386:/usr/local/java/j2sdk/jre/lib/i386/client:/usr/local/java/j2sdk/jre/lib/i386/native_threads

And also :
ls /usr/local/java/j2sdk/jre/lib/i386/client
libjsig.so libjvm.so Xusage.txt

I think I made some small mistake, but can not find it !

????? ?? zz_11 at mail.bg:

> Hi,
> i try to install pljava on my pg 8.2.6 box.
>
> My config:
> pg 8.2.6
>
> uname -a:
> Linux testbox 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64
> x86_64 x86_64 GNU/Linux
>
> It is 64-bit CentOs 5.1
>
> java -version:
> java version "1.4.2_16"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_16-b05)
> Java HotSpot(TM) Client VM (build 1.4.2_16-b05, mixed mode)
>
> I readet the install giude
> and first selected to use the binary
> http://pgfoundry.org/frs/download.php/1597/pljava-i686-pc-linux-gnu-pg8.2-1.4.0.tar.gz
> ( I think it is for 32-bit java)
>
> After running the install.sql script, I receive:
>
> ERROR: could not load library "/usr/share/pljava/pljava.so":
> /usr/share/pljava/pljava.so: wrong ELF class: ELFCLASS32
> ERROR: function sqlj.java_call_handler() does not exist
> ERROR: could not load library "/usr/share/pljava/pljava.so":
> /usr/share/pljava/pljava.so: wrong ELF class: ELFCLASS32
> ERROR: function sqlj.javau_call_handler() does not exist
>
>
>
> After this problems I try to compile pljava from sources. After
> compiling (without errors) I try to run install.sql.
> As result I received :
>
> ERROR: could not load library "/usr/share/pljava/pljava.so":
> /usr/share/pljava/pljava.so: undefined symbol: JNI_CreateJavaVM
> ERROR: function sqlj.java_call_handler() does not exist
> ERROR: could not load library "/usr/share/pljava/pljava.so":
> /usr/share/pljava/pljava.so: undefined symbol: JNI_CreateJavaVM
> ERROR: function sqlj.javau_call_handler() does not exist
> NOTICE: CREATE TABLE will create implicit sequence
> "jar_repository_jarid_seq1" for serial column "jar_repository.jarid"
> ERROR: relation "jar_repository" already exists
> NOTICE: CREATE TABLE will create implicit sequence
> "jar_entry_entryid_seq1" for serial column "jar_entry.entryid"
> ERROR: relation "jar_entry" already exists
> ERROR: relation "classpath_entry" already exists
> NOTICE: CREATE TABLE will create implicit sequence
> "typemap_entry_mapid_seq1" for serial column "typemap_entry.mapid"
>
>
>
> Pls. help me to correct this problem.
>
>
> -------------------------------------
>
> ???????? ?????? ?? ?????? ????? ? ???-????????????? ??????? ?? 8-?? ????!
> ???? ?? 5 ?? 14 ???? - ??????????? ?? ?????? (.com) - 13,50 ??./??????!
> ????????????.?? - ???? ????????? ??????? ??????!
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>

-------------------------------------

???????? ?????? ?? ?????? ????? ? ???-????????????? ??????? ?? 8-?? ????!
???? ?? 5 ?? 14 ???? - ??????????? ?? ?????? (.com) - 13,50 ??./??????!
????????????.?? - ???? ????????? ??????? ??????!