| Lists: | pljava-dev |
|---|
| From: | zz_11 at mail(dot)bg (zz_11 at mail(dot)bg) |
|---|---|
| To: | |
| Subject: | [Pljava-dev] pljava 1.4.0 install problem |
| Date: | 2008-03-08 11:28:20 |
| Message-ID: | 20080308132820.b615t2hy2ooggs48@mail.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pljava-dev |
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 ??./??????!
????????????.?? - ???? ????????? ??????? ??????!
| From: | zz_11 at mail(dot)bg (zz_11 at mail(dot)bg) |
|---|---|
| To: | |
| Subject: | [Pljava-dev] pljava 1.4.0 install problem |
| Date: | 2008-03-08 12:37:19 |
| Message-ID: | 20080308143719.7h8hsv96ec8wcs40@mail.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | PostgreSQL : PostgreSQL 메일 링리스트 : 2008-03-08 이후 범퍼카 토토Dev 12:37 |
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 ??./??????!
????????????.?? - ???? ????????? ??????? ??????!
| From: | books at ejurka(dot)com (Kris Jurka) |
|---|---|
| To: | |
| Subject: | [Pljava-dev] pljava 1.4.0 install problem |
| Date: | 2008-03-08 16:14:39 |
| Message-ID: | 47D2BB6F.3090505@ejurka.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pljava-dev |
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
| From: | zz_11 at mail(dot)bg (zz_11 at mail(dot)bg) |
|---|---|
| To: | |
| Subject: | [Pljava-dev] pljava 1.4.0 install problem |
| Date: | 2008-03-09 12:43:35 |
| Message-ID: | 20080309144335.kndqe5x9kosko0s0@mail.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pljava-dev |
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 ??./??????!
????????????.?? - ???? ????????? ??????? ??????!