[Pljava-dev] pljava 1.4.0 install problem

Thank you Kris.
It is working now.

regards,
ivan.

????? ?? Kris Jurka <books at 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

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

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