[Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM

Hi guys!

I try install pljava unsuccesfully, my problem is :

vpj:/app/PostgreSQL/pljava # java
-cp ../postgresql-8.0-310.jdbc3.jar:deploy.jar
org.postgresql.pljava.deploy.Deployer -install -user postgres -password
postgres -database cmpcs -host vpj
java.sql.SQLException: ERROR: could not load library
"/usr/local/pgsql/lib/libpljava.so": /usr/local/pgsql/lib/libpljava.so:
undefined symbol: JNI_CreateJavaVM
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:313)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:305)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandler(Deployer.java:389)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:273)

my enveroment :

Linux vpj 2.6.8-24.11-default #1 Fri Jan 14 13:01:26 UTC 2005 x86_64
x86_64 x86_64 GNU/Linux

java version "1.4.2_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)
Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)

Postgresql 8.0.1

export
LD_LIBRARy_PATH=/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386/client:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386/native_threads:/usr/local/pgsql/lib/libpljava.so

Some one can help me with this problem?

Best regards

Victor P?rez Ju?rez
e-Evolutiuon, S.C.
www.e-evolution.com
victor.perez at e-evolution.com
Tel: (52)7711070937

Victor wrote:

>java.sql.SQLException: ERROR: could not load library
>"/usr/local/pgsql/lib/libpljava.so": /usr/local/pgsql/lib/libpljava.so:
>undefined symbol: JNI_CreateJavaVM
>...
>
>LD_LIBRARy_PATH=/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386/client:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386/native_threads:/usr/local/pgsql/lib/libpljava.so
>
>Some one can help me with this problem?
>
>
Your LD_LIBRARY_PATH contains "jre/jre". That is probably incorrect. One
"jre" should be sufficient. Also, the character 'Y' is smallcaps and
Linux environment names are case sensitive.

Regards,
Thomas Hallgren

On Fri, 11 Feb 2005 19:15:59 -0600
Victor <victor.perez at e-evolution.com.mx> wrote:

> java.sql.SQLException: ERROR: could not load library
> Linux vpj 2.6.8-24.11-default #1 Fri Jan 14 13:01:26 UTC 2005 x86_64
> x86_64 x86_64 GNU/Linux

This tells me you are on an AMD64 platform.

> LD_LIBRARy_PATH=/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/jre/lib/i386

But you are trying to load 32-bit libraries.

Did you build PostgreSQL and PL/Java from source or are you running
binaries? Are you running a 32-bit or 64-bit Java?

I'm running PostgreSQL and PL/Java that I compiled from source on an
AMD64 Linux 64-bit platform (Gentoo) with the Sun Java 1.5.0 for 64-bit
Linux downloaded from the Sun site. Everything works fine.

--
Guy Rouillier

Hi guys!

yes, I set my
LD_LIBRARY_PATH=:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/lib/i386:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/lib/i386/client:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/lib/i386/native_threads

this is my java environment
java -version
java version "1.4.2_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)
Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)

I compiled postgresql 8.0.1 and pljava for linux amd64

I am using SUSE 9.2 for AMD64, but I get the same problem (ERROR: could
not load library
"/usr/local/pgsql/lib/libpljava.so": /usr/local/pgsql/lib/libpljava.so:
undefined symbol: JNI_CreateJavaVM) any idea ?

El s?b, 12-02-2005 a las 17:08 -0500, Guy Rouillier escribi?:
> rg.postgresql.org
Victor P?rez Ju?rez
e-Evolutiuon, S.C.
www.e-evolution.com.mx
victor.perez at e-evolution.com
Tel: (52)7711070937

Victor wrote:

>Hi guys!
>
>yes, I set my
>LD_LIBRARY_PATH=:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/lib/i386:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/lib/i386/client:/usr/lib/jvm/java-1.4.2-sun-1.4.2.06/jre/lib/i386/native_threads
>
>this is my java environment
>java -version
>java version "1.4.2_06"
>Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)
>Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)
>
>
>I compiled postgresql 8.0.1 and pljava for linux amd64
>
>I am using SUSE 9.2 for AMD64, but I get the same problem (ERROR: could
>not load library
>"/usr/local/pgsql/lib/libpljava.so": /usr/local/pgsql/lib/libpljava.so:
>undefined symbol: JNI_CreateJavaVM) any idea ?
>
>
Your LD_LIBRARY_PATH indicates that you're using a 32-bit JVM. My JDK
installation has an amd64 directory under lib, not an i386.

What JAVA_HOME are you using when you build? Does it appoint the same
JVM? One cause of this problem could be that you link using a 64bit JVM
and then try running it using a 32bit JVM.

Regards,
Thomas Hallgren

Hi!

I complied pljava with this environment :

java version "1.5.0_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_01-b08)
Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_01-b08, mixed mode)

Now I recived this error:

java.sql.SQLException: ERROR: could not load library
"/usr/local/pgsql/lib/libpljava.so": libjvm.so: no se puede abrir el
fichero del objeto compartido: No existe el fichero o el directorio
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:313)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:305)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandler(Deployer.java:417)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)

or this via psql:

CREATE SCHEMA
GRANT
ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so":
libjvm.so: no se puede abrir el fichero del objeto compartido: No existe
el fichero o el directorio
ERROR: function sqlj.java_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"
CREATE TABLE
GRANT
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"
CREATE TABLE
GRANT
ALTER TABLE
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"classpath_entry_pkey" for table "classpath_entry"
CREATE TABLE
GRANT
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

LD_LIBRARY_PATH=/usr/lib/jvm/jdk1.5.0_01/jre/lib/amd64:/usr/lib/jvm/jdk1.5.0_01/jre/lib/amd64/server:/usr/lib/jvm/jdk1.5.0_01/jre/lib/amd64/native_threads:/usr/local/pgsql/lib

I do not understand what is happening?

I will appreciate any help!!!

El lun, 14-02-2005 a las 10:05 -0600, Victor escribi?:
>
>
> pljava-dev at gborg.postgresql.org
Victor P?rez Ju?rez
e-Evolutiuon, S.C.
www.e-evolution.com.mx
victor.perez at e-evolution.com
Tel: (52)7711070937

Victor wrote:

>Hi!
>
>I complied pljava with this environment :
>
>java version "1.5.0_01"
>Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_01-b08)
>Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_01-b08, mixed mode)
>
>Now I recived this error:
>
>java.sql.SQLException: ERROR: could not load library
>"/usr/local/pgsql/lib/libpljava.so": libjvm.so: no se puede abrir el
>fichero del objeto compartido: No existe el fichero o el directorio
>
>
Good, now you have compiled towards a 64bit 1.5.0 JVM. Now I suspect
that your LD_LIBRARY_PATH lacks a directory where a maching libjvm.so
can be found.

- thomas

Hi guys!

Thank you very much, Is working fine now!

Best Regards

El lun, 14-02-2005 a las 19:20 +0100, Thomas Hallgren escribi?:
> pljava-dev at gborg.postgresql.org
Victor P?rez Ju?rez
e-Evolutiuon, S.C.