From: books at ejurka.com (Kris Jurka) Date: Sat, 08 Mar 2008 09:14:39 -0700 Subject: [Pljava-dev] pljava 1.4.0 install problem In-Reply-To: <20080308143719.7h8hsv96ec8wcs40@mail.bg> References: <20080308132820.b615t2hy2ooggs48@mail.bg> <20080308143719.7h8hsv96ec8wcs40@mail.bg> Message-ID: <47D2BB6F.3090505@ejurka.com> 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