From: zz_11 at mail.bg (zz_11 at mail.bg) Date: Sun, 09 Mar 2008 14:43:35 +0200 Subject: [Pljava-dev] pljava 1.4.0 install problem In-Reply-To: <47D2BB6F.3090505@ejurka.com> References: <20080308132820.b615t2hy2ooggs48@mail.bg> <20080308143719.7h8hsv96ec8wcs40@mail.bg> <47D2BB6F.3090505@ejurka.com> Message-ID: <20080309144335.kndqe5x9kosko0s0@mail.bg> Thank you Kris. It is working now. regards, ivan. ????? ?? Kris Jurka : > You need all 32bit or all 64bit versions of postgresql, pljava, and > java. Since it appears you have a 64bit postgresql and a 32bit java, > it doesn't matter what pljava version you use, it won't work. I'd > suggest getting a 64bit java version. > > Kris Jurka > > zz_11 at mail.bg wrote: >> 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 ??./??????! >> ????????????.?? - ???? ????????? ??????? ??????! >> >> >> _______________________________________________ >> Pljava-dev mailing list >> Pljava-dev at pgfoundry.org >> http://pgfoundry.org/mailman/listinfo/pljava-dev ------------------------------------- ???????? ?????? ?? ?????? ????? ? ???-????????????? ??????? ?? 8-?? ????! ???? ?? 5 ?? 14 ???? - ??????????? ?? ?????? (.com) - 13,50 ??./??????! ????????????.?? - ???? ????????? ??????? ??????!