[Pljava-dev] pljava 1.4.0 install problem

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