[Pljava-dev] pljava 1.4.0 install problem

Kris Jurka books at ejurka.com
Sat Mar 8 16:14:39 UTC 2008


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




More information about the Pljava-dev mailing list