agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
31+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
@ 2005-02-12 01:15
0 siblings, 2 replies; 31+ messages in thread
From: @ 2005-02-12 01:15 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
@ 2005-02-12 08:48
parent:
1 sibling, 0 replies; 31+ messages in thread
From: @ 2005-02-12 08:48 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
@ 2005-02-12 22:08
parent:
1 sibling, 1 reply; 31+ messages in thread
From: @ 2005-02-12 22:08 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
@ 2005-02-14 16:05
parent:
0 siblings, 2 replies; 31+ messages in thread
From: @ 2005-02-14 16:05 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
@ 2005-02-14 16:44
parent:
1 sibling, 0 replies; 31+ messages in thread
From: @ 2005-02-14 16:44 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
@ 2005-02-14 17:00
parent:
1 sibling, 2 replies; 31+ messages in thread
From: @ 2005-02-14 17:00 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
@ 2005-02-14 18:20
parent:
1 sibling, 0 replies; 31+ messages in thread
From: @ 2005-02-14 18:20 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
@ 2005-02-14 19:11
parent:
1 sibling, 0 replies; 31+ messages in thread
From: @ 2005-02-14 19:11 UTC (permalink / raw)
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.
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
@ 2005-04-01 00:46
0 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 00:46 UTC (permalink / raw)
Hi,
I?m geting this error when I?m deployng PLJava:
export
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386
/client/:$JAVA_HOME/jre/lib/i386/native_threads:. ; java -cp
/var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.ja
r org.postgresql.pljava.deploy.Deployer -reinstall -user compiere -database
cmpcs
java.sql.SQLException: ERROR: could not load library
"/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared object
file: No such file or directory
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:313)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:305)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:419)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
Any tips???
-----------------------------------------------------------
SO:
Red Hat 9.0
Java Version and RPM:
java version "1.4.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_02-b06)
Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode)
j2sdk-1.4.1_02-fcs.rpm
Postgres Version (RPM?S):
postgresql-8.0.1-2PGDG
postgresql-server-8.0.1-2PGDG
postgresql-libs-8.0.1-2PGDG
postgresql-devel-8.0.1-2PGDG
postgresql-jdbc-8.0.1-2PGDG
Thanks in advance,
M.P.Garcia
___________________________________________
Mentes Virtuais, Lda
Consultoria Inform?tica e Solu??es Multim?dia
3810-106 AVEIRO
Tel.234422875 Fax.234422875
mgarcia at mentesvirtuais.com Visite-nos em http://www.mentesvirtuais.com
<http://www.mentesvirtuais.com/;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050401/9e40291d/attachment.html;
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
@ 2005-04-01 06:11
parent:
0 siblings, 0 replies; 31+ messages in thread
From: @ 2005-04-01 06:11 UTC (permalink / raw)
Gulden wrote:
> Hi,
>
> I?m geting this error when I?m deployng PLJava:
>
> export
> LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/:$JAVA_HOME/jre/lib/i386/native_threads:.
> ; java -cp
> /var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.jar
> org.postgresql.pljava.deploy.Deployer -reinstall -user compiere
> -database cmpcs
>
> java.sql.SQLException: ERROR: could not load library
> "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared
> object file: No such file or directory
>
> 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.initJavaHandlers(Deployer.java:419)
>
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
> Any tips???
>
Yes, it seems you try to export the LD_LIBRARY_PATH for the benefit of
the client program. The client doesn't care about the LD_LIBRARY_PATH.
The postmaster backend does.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 12:08
0 siblings, 3 replies; 31+ messages in thread
From: @ 2005-04-01 12:08 UTC (permalink / raw)
That won't solve my problem, I've already done that.
This is my export:
$ export
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386
/client/:$JAVA_HOME/jre/lib/i386/native_threads:.;
JVM Shared Library:
$ ls -la /usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
-rwxr-xr-x 1 root bin 6098298 Feb 20 2003
/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
Deploy command (as root):
java -cp
/var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.ja
r org.postgresql.pljava.deploy.Deployer -reinstall -user compiere -database
cmpcs
Exception:
java.sql.SQLException: ERROR: could not load library
"/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared object
file: No such file or directory
-----Original Message-----
From: Antonio Carlos de Andrade Brito [mailto:acabhgg at hotmail.com]
Sent: sexta-feira, 1 de Abril de 2005 11:47
To: gulden at portugalmail.pt
Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not load
library"/usr/local
Ola Gulden,
tamb?m estou come?ando a ler sobre pljava, s? que uso postgresql para
windows... Pelo que vi vc n?o est? apontando para sua JVM, que deve estar
dentro do diretorio do \j2sdk1.4.2_05\jre\bin\client...
Um abra?o e espero te ajudado...
Bom dia,
Antonio - Rio de Janeiro - Brazil
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 12:43
parent:
2 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 12:43 UTC (permalink / raw)
Sorry everybody becase write in portuguese to Gulden, now, if i will meet
brazilian or portuguese here, i will try write english...
Well Gulden,
Did you change pljava.classpath in postgresql.conf ? It need is linked
with your jvm directory...
Please, put your postgresql.conf in your next message..
Thanks,
Antonio - Rio - Brazil
>From: "Gulden" <gulden at portugalmail.pt>
>To: "'Antonio Carlos de Andrade Brito'" <acabhgg at hotmail.com>,
><pljava-dev at gborg.postgresql.org>
>Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not load
>library"/usr/local
>Date: Fri, 1 Apr 2005 13:08:53 +0100
>
>That won't solve my problem, I've already done that.
>
>This is my export:
>
>$ export
>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386
>/client/:$JAVA_HOME/jre/lib/i386/native_threads:.;
>
>
>JVM Shared Library:
>$ ls -la /usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
>-rwxr-xr-x 1 root bin 6098298 Feb 20 2003
>/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
>
>
>Deploy command (as root):
>java -cp
>/var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.ja
>r org.postgresql.pljava.deploy.Deployer -reinstall -user compiere -database
>cmpcs
>
>Exception:
>java.sql.SQLException: ERROR: could not load library
>"/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared object
>file: No such file or directory
>
>
>
>-----Original Message-----
>From: Antonio Carlos de Andrade Brito [mailto:acabhgg at hotmail.com]
>Sent: sexta-feira, 1 de Abril de 2005 11:47
>To: gulden at portugalmail.pt
>Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not load
>library"/usr/local
>
>Ola Gulden,
>tamb?m estou come?ando a ler sobre pljava, s? que uso postgresql para
>windows... Pelo que vi vc n?o est? apontando para sua JVM, que deve estar
>dentro do diretorio do \j2sdk1.4.2_05\jre\bin\client...
>Um abra?o e espero te ajudado...
>Bom dia,
>Antonio - Rio de Janeiro - Brazil
>
>
_________________________________________________________________
MSN Messenger: converse online com seus amigos .
http://messenger.msn.com.br
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 13:06
parent:
2 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 13:06 UTC (permalink / raw)
Are you sure that the postgresql *service* (not client) sees this
LD_LIBRARY_PATH?
Filip
----- Original Message -----
From: "Gulden" <gulden at portugalmail.pt>
To: "'Antonio Carlos de Andrade Brito'" <acabhgg at hotmail.com>;
<pljava-dev at gborg.postgresql.org>
Sent: Friday, April 01, 2005 2:08 PM
Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not
loadlibrary"/usr/local
> That won't solve my problem, I've already done that.
>
> This is my export:
>
> $ export
>
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386
> /client/:$JAVA_HOME/jre/lib/i386/native_threads:.;
>
>
> JVM Shared Library:
> $ ls -la /usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
> -rwxr-xr-x 1 root bin 6098298 Feb 20 2003
> /usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
>
>
> Deploy command (as root):
> java -cp
>
/var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.ja
> r org.postgresql.pljava.deploy.Deployer -reinstall -user
compiere -database
> cmpcs
>
> Exception:
> java.sql.SQLException: ERROR: could not load library
> "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared object
> file: No such file or directory
>
>
>
> -----Original Message-----
> From: Antonio Carlos de Andrade Brito [mailto:acabhgg at hotmail.com]
> Sent: sexta-feira, 1 de Abril de 2005 11:47
> To: gulden at portugalmail.pt
> Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not load
> library"/usr/local
>
> Ola Gulden,
> tamb?m estou come?ando a ler sobre pljava, s? que uso postgresql para
> windows... Pelo que vi vc n?o est? apontando para sua JVM, que deve estar
> dentro do diretorio do \j2sdk1.4.2_05\jre\bin\client...
> Um abra?o e espero te ajudado...
> Bom dia,
> Antonio - Rio de Janeiro - Brazil
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 13:07
parent:
2 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 13:07 UTC (permalink / raw)
Gulden wrote:
>That won't solve my problem, I've already done that.
>
>This is my export:
>
>$ export
>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386
>/client/:$JAVA_HOME/jre/lib/i386/native_threads:.;
>
>
Why do you use $JAVA_HOME in one place and then /usr/java/j2sdk1.4.1_02
in the next? Is $JAVA_HOME set to /usr/java/j2sdk1.4.1_02 or is it
something else?
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 13:16
parent:
0 siblings, 0 replies; 31+ messages in thread
From: @ 2005-04-01 13:16 UTC (permalink / raw)
The problem persists....
$ export
LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jre
/lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/:. ;
$ which java
/usr/java/j2sdk1.4.1_02/bin/java
-----Original Message-----
From: Thomas Hallgren [mailto:ironjug at hotmail.com]
Sent: sexta-feira, 1 de Abril de 2005 13:08
To: Gulden
Cc: 'Antonio Carlos de Andrade Brito'; pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not load
library"/usr/local
Gulden wrote:
>That won't solve my problem, I've already done that.
>
>This is my export:
>
>$ export
>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i38
6
>/client/:$JAVA_HOME/jre/lib/i386/native_threads:.;
>
>
Why do you use $JAVA_HOME in one place and then /usr/java/j2sdk1.4.1_02
in the next? Is $JAVA_HOME set to /usr/java/j2sdk1.4.1_02 or is it
something else?
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 13:24
parent:
0 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 13:24 UTC (permalink / raw)
I've added these lines to postgres.conf:
dynamic_library_path =
'$libdir:/var/lib/pgsql/pljava:/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/'
custom_variable_classes = 'pljava'
pljava.classpath =
'/var/lib/pgsql/pljava/pljava.jar:/var/lib/pgsql/pljava:/usr/java/j2sdk1.4.1
_02/jre/lib/i386/client/'
pljava.release_lingering_savepoints = true
pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 13:27
parent:
0 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 13:27 UTC (permalink / raw)
How can i do that?
In one experience I've put this line in the /etc/init.d/postgres file
export
LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jre
/lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
and it didn't solve the problem.
-----Original Message-----
From: Filip Hrbek [mailto:filip.hrbek at plz.comstar.cz]
Sent: sexta-feira, 1 de Abril de 2005 13:06
To: Gulden; 'Antonio Carlos de Andrade Brito';
pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not
loadlibrary"/usr/local
Are you sure that the postgresql *service* (not client) sees this
LD_LIBRARY_PATH?
Filip
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 13:47
parent:
0 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 13:47 UTC (permalink / raw)
Gulden, remove /usr/java/j2sdk1.4.1_02/jre/lib/i386/client/ from
dynamic_library_path...
Antonio
>From: "Gulden" <gulden at portugalmail.pt>
>To: "'Antonio Carlos de Andrade Brito'" <acabhgg at hotmail.com>,
><pljava-dev at gborg.postgresql.org>
>Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not load
>library"/usr/local
>Date: Fri, 1 Apr 2005 14:24:10 +0100
>
>I've added these lines to postgres.conf:
>
>
>dynamic_library_path =
>'$libdir:/var/lib/pgsql/pljava:/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/'
>
>custom_variable_classes = 'pljava'
>
>pljava.classpath =
>'/var/lib/pgsql/pljava/pljava.jar:/var/lib/pgsql/pljava:/usr/java/j2sdk1.4.1
>_02/jre/lib/i386/client/'
>
>pljava.release_lingering_savepoints = true
>
>pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'
>
>
>
_________________________________________________________________
MSN Messenger: converse online com seus amigos .
http://messenger.msn.com.br
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 13:47
parent:
0 siblings, 2 replies; 31+ messages in thread
From: @ 2005-04-01 13:47 UTC (permalink / raw)
Gulden wrote:
>How can i do that?
>
>In one experience I've put this line in the /etc/init.d/postgres file
>
>export
>LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jre
>/lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
>
>and it didn't solve the problem.
>
>
Well, this is the one and only place where the LD_LIBRARY_PATH should be
set. The client doesn't need it and there's no point in including the
jvm in the dynamic_library_path in postgresql.conf either (it's sole
purpose is to find the postgresql module, the dynamic loader will never
see it). So make sure this setting is in place and that it is correct. I
suggest you try removing the trailing '/' from all path's. You don't
need them.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
@ 2005-04-01 14:01
parent:
0 siblings, 0 replies; 31+ messages in thread
From: @ 2005-04-01 14:01 UTC (permalink / raw)
Without success
-----Original Message-----
From: Antonio Carlos [mailto:acabhgg at hotmail.com]
Sent: sexta-feira, 1 de Abril de 2005 13:47
To: gulden at portugalmail.pt; pljava-dev at gborg.postgresql.org
Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could not load
library"/usr/local
Gulden, remove /usr/java/j2sdk1.4.1_02/jre/lib/i386/client/ from
dynamic_library_path...
Antonio
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 14:06
parent:
1 sibling, 2 replies; 31+ messages in thread
From: @ 2005-04-01 14:06 UTC (permalink / raw)
Removing the trailing '/' is not the solution.
Could be the problem be related with the way the postresql were
"compiled"!!!
I've installed postgresql with the RPM's from postgresql.org
-----Original Message-----
From: Thomas Hallgren [mailto:ironjug at hotmail.com]
Sent: sexta-feira, 1 de Abril de 2005 13:48
To: Gulden
Cc: 'Filip Hrbek'; 'Antonio Carlos de Andrade Brito';
pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not
loadlibrary"/usr/local
Gulden wrote:
>How can i do that?
>
>In one experience I've put this line in the /etc/init.d/postgres file
>
>export
>LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jr
e
>/lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
>
>and it didn't solve the problem.
>
>
Well, this is the one and only place where the LD_LIBRARY_PATH should be
set. The client doesn't need it and there's no point in including the
jvm in the dynamic_library_path in postgresql.conf either (it's sole
purpose is to find the postgresql module, the dynamic loader will never
see it). So make sure this setting is in place and that it is correct. I
suggest you try removing the trailing '/' from all path's. You don't
need them.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 14:12
parent:
1 sibling, 0 replies; 31+ messages in thread
From: @ 2005-04-01 14:12 UTC (permalink / raw)
Gulden wrote:
>Removing the trailing '/' is not the solution.
>
>Could be the problem be related with the way the postresql were
>"compiled"!!!
>I've installed postgresql with the RPM's from postgresql.org
>
>
Don't think so. The backend loads the libpljava.so succesfully and then
makes an attempt to load the libjvm.so and fail on a "no such file or
directory" . This tells me that the backend doesn't see a correct
LD_LIBRARY_PATH. If the linker had problems, the error message would be
different.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 14:14
parent:
1 sibling, 1 reply; 31+ messages in thread
From: @ 2005-04-01 14:14 UTC (permalink / raw)
Thomas Hallgren wrote:
> Gulden wrote:
>
>> How can i do that?
>>
>> In one experience I've put this line in the /etc/init.d/postgres file
>>
>> export
>> LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jre
>>
>> /lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
>>
>> and it didn't solve the problem.
>
Hmm, b.t.w. the first entry in the above path is incorrect. It's missing
the i386 at the end..
- thomas
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 14:20
parent:
1 sibling, 1 reply; 31+ messages in thread
From: @ 2005-04-01 14:20 UTC (permalink / raw)
I think no... it seems the matter is jvm....
Try to link again your libraries...
ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libjava.so
/usr/lib/libjava.so
ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libawt.so
/usr/lib/libawt.so
ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libverify.so
/usr/lib/libverify.so
ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libmlib_image.so
/usr/lib/libmlib_image.s
Try again http://gagravarr.livejournal.com/83889.html it will to help to
debugger in Postgresql...
Antonio - Rio - Brazil
>From: "Gulden" <gulden at portugalmail.pt>
>To: "'Thomas Hallgren'" <ironjug at hotmail.com>
>CC: "'Filip Hrbek'" <filip.hrbek at plz.comstar.cz>, "'Antonio Carlos de
>Andrade Brito'" <acabhgg at hotmail.com>, <pljava-dev at gborg.postgresql.org>
>Subject: RE: [Pljava-dev] java.sql.SQLException: ERROR: could
>not loadlibrary"/usr/local
>Date: Fri, 1 Apr 2005 15:06:55 +0100
>
>Removing the trailing '/' is not the solution.
>
>Could be the problem be related with the way the postresql were
>"compiled"!!!
>I've installed postgresql with the RPM's from postgresql.org
>
>
>
>-----Original Message-----
>From: Thomas Hallgren [mailto:ironjug at hotmail.com]
>Sent: sexta-feira, 1 de Abril de 2005 13:48
>To: Gulden
>Cc: 'Filip Hrbek'; 'Antonio Carlos de Andrade Brito';
>pljava-dev at gborg.postgresql.org
>Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not
>loadlibrary"/usr/local
>
>Gulden wrote:
>
> >How can i do that?
> >
> >In one experience I've put this line in the /etc/init.d/postgres file
> >
> >export
> >LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jr
>e
> >/lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
> >
> >and it didn't solve the problem.
> >
> >
>Well, this is the one and only place where the LD_LIBRARY_PATH should be
>set. The client doesn't need it and there's no point in including the
>jvm in the dynamic_library_path in postgresql.conf either (it's sole
>purpose is to find the postgresql module, the dynamic loader will never
>see it). So make sure this setting is in place and that it is correct. I
>suggest you try removing the trailing '/' from all path's. You don't
>need them.
>
>Regards,
>Thomas Hallgren
>
_________________________________________________________________
MSN Messenger: converse online com seus amigos .
http://messenger.msn.com.br
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 15:33
parent:
0 siblings, 0 replies; 31+ messages in thread
From: @ 2005-04-01 15:33 UTC (permalink / raw)
Antonio Carlos wrote:
> I think no... it seems the matter is jvm....
>
> Try to link again your libraries...
>
> ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libjava.so
> /usr/lib/libjava.so
> ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libawt.so
> /usr/lib/libawt.so
> ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libverify.so
> /usr/lib/libverify.so
> ln -s /usr/local/share/jsdk1.4/j2sdk1.4.0_02/lib/libmlib_image.so
> /usr/lib/libmlib_image.s
These links are not relevant. A correct LD_LIBRARY_PATH is all that is
needed. Nothing more, nothing less. So far, the LD_LIBRARY_PATH has been
incorrect.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 18:20
parent:
0 siblings, 2 replies; 31+ messages in thread
From: @ 2005-04-01 18:20 UTC (permalink / raw)
I've added this entry on classpath:
/usr/java/j2sdk1.4.1_02/jre/lib/i386
Without success!!
export
LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib:/usr/java/j2sdk1.4.1_02/jre/
lib/i386:/usr/java/j2sdk1.4.1_02/jre/lib/i386/client ; java -cp
/var/lib/pgsql/pljava/deploy.jar:/usr/share/java/postgresql-8.0-310.jdbc3.ja
r org.postgresql.pljava.deploy.Deployer -reinstall -user compiere -database
cmpcs
java.sql.SQLException: ERROR: could not load library
"/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared object
file: No such file or directory
-----Original Message-----
From: Thomas Hallgren [mailto:thhal at mailblocks.com]
Sent: sexta-feira, 1 de Abril de 2005 14:14
To: Thomas Hallgren
Cc: Gulden; pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not
loadlibrary"/usr/local
Thomas Hallgren wrote:
> Gulden wrote:
>
>> How can i do that?
>>
>> In one experience I've put this line in the /etc/init.d/postgres file
>>
>> export
>>
LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jre
>>
>> /lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
>>
>> and it didn't solve the problem.
>
Hmm, b.t.w. the first entry in the above path is incorrect. It's missing
the i386 at the end..
- thomas
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 18:53
parent:
1 sibling, 1 reply; 31+ messages in thread
From: @ 2005-04-01 18:53 UTC (permalink / raw)
Gulden wrote:
>I've added this entry on classpath:
>
>/usr/java/j2sdk1.4.1_02/jre/lib/i386
>
>Without success!!
>
>
The call to dlopen fails with "No such file or directory" when
attempting to load the libjvm.so. This indicates that the loader either
fails to locate the libjvm.so or something that it in turn requires.
Barring a corrupt Java installation, the error you encounter can only
come from an insufficient LD_LIBRARY_PATH or from setting the
LD_LIBRARY_PATH so that the backend process doesn't see it.
From your previous postings, I deduct that the correct LD_LIBRARY_PATH
should be something like:
/usr/java/j2sdk1.4.1_02/jre/lib/i386/client:/usr/java/j2sdk1.4.1_02/jre/lib/i386
perhaps with the addition of
:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads
although the lack of the latter would normally yield another error relating to HPI. So, please verify that your LD_LIBRARY_PATH indeed is correct, that the backend (postmaster) really is started using this path, and that your Java installation is correct. The Java you're using is quite old so a reinstallation might be a good idea anyway. The latest 1.4 is 1.4.2_07 if I remember correctly.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local
@ 2005-04-01 19:07
parent:
1 sibling, 1 reply; 31+ messages in thread
From: @ 2005-04-01 19:07 UTC (permalink / raw)
Guessing again!!!
The problem is on loading the library. So it could be related to:
1. Permissions of the file libjvm.so, postgres can't access that
lib.
-rwxr-xr-x 1 root bin 6098298 Feb 20 2003
/usr/java/j2sdk1.4.1_02/jre/lib/i386/client/libjvm.so
2. LD_LIBRARY_PATH incorrect
I think I've tried all.
3. Postgresql doesn't care about the LD_LIBRARY_PATH, it has it own
LD_LIBRARY_PATH!!! Where can I configure that???
What else could it be???? I could only think in a very "stupid" problem.
Regards,
M.P.Garcia
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
@ 2005-04-01 19:14
parent:
0 siblings, 0 replies; 31+ messages in thread
From: @ 2005-04-01 19:14 UTC (permalink / raw)
I'll try to install a new version of java
-----Original Message-----
From: Thomas Hallgren [mailto:thhal at mailblocks.com]
Sent: sexta-feira, 1 de Abril de 2005 18:54
To: Gulden
Cc: pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not
loadlibrary"/usr/local
Gulden wrote:
>I've added this entry on classpath:
>
>/usr/java/j2sdk1.4.1_02/jre/lib/i386
>
>Without success!!
>
>
The call to dlopen fails with "No such file or directory" when
attempting to load the libjvm.so. This indicates that the loader either
fails to locate the libjvm.so or something that it in turn requires.
Barring a corrupt Java installation, the error you encounter can only
come from an insufficient LD_LIBRARY_PATH or from setting the
LD_LIBRARY_PATH so that the backend process doesn't see it.
From your previous postings, I deduct that the correct LD_LIBRARY_PATH
should be something like:
/usr/java/j2sdk1.4.1_02/jre/lib/i386/client:/usr/java/j2sdk1.4.1_02/jre/lib/
i386
perhaps with the addition of
:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads
although the lack of the latter would normally yield another error relating
to HPI. So, please verify that your LD_LIBRARY_PATH indeed is correct, that
the backend (postmaster) really is started using this path, and that your
Java installation is correct. The Java you're using is quite old so a
reinstallation might be a good idea anyway. The latest 1.4 is 1.4.2_07 if I
remember correctly.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local
@ 2005-04-01 21:49
parent:
0 siblings, 1 reply; 31+ messages in thread
From: @ 2005-04-01 21:49 UTC (permalink / raw)
Gulden wrote:
> 3. Postgresql doesn't care about the LD_LIBRARY_PATH, it has it own
>LD_LIBRARY_PATH!!!
>
>
Just to clarify.
PostgresSQL uses the postgresql.conf setting "dynamic_library_path" to
find add-on modules. libpljava.so is such a module. PostgreSQL will load
such modules by assembling absolute paths that it sends that to the
dynamic loader (dlopen on Linux). So far, the LD_LIBRARY_PATH has not
been used at all.
When libjava.so has been successfully loaded, it will try to initialize
the Java VM. That, in turn, will invoke the loader again. This time
however, the loader is not explicitly invoked from code and the loader
will utilize the LD_LIBRARY_PATH that is in effect for the backend
process in order to find the libjvm.so and other shared objects that the
libjvm.so might need in turn.
> Where can I configure that???
>
You define the relevant LD_LIBRARY_PATH by exporting it just before you
start the postmaster deamon. That deamon will then propagate the setting
to all backend processes that it spawns, thus making the LD_LIBRARY_PATH
visible to libpljava.so.
- thomas
^ permalink raw reply [nested|flat] 31+ messages in thread
* [Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local
@ 2005-04-03 18:18
parent:
0 siblings, 0 replies; 31+ messages in thread
From: @ 2005-04-03 18:18 UTC (permalink / raw)
Yep, good tip!!!
Yep, with that tip I've finally overcame the problem!!!
I've changed the script "/etc/init.d/postgres", now I export the
LD_LIBRAY_PATH just before starting the postmaster:
#------ /etc/init.d/postgres --------------------------
echo -n "$PSQL_START"
$SU -l postgres -c "export
LD_LIBRARY_PATH=/usr/java/j2sdk1.4.2_08/jre/lib:/usr/java/j2sdk1.4.2_08/jre/
lib/i386/client:/usr/java/j2sdk1.4.2_08/jre/lib/i386/native_threads
;$PGENGINE/postmaster -p '$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG"
2>&1 < /dev/null
#------------------------------------------------------
There must be other solutions, but for now this one solves my problem :)
Thanks to all, without you I wouldn't be able to overcome that problem.
M.P.Garcia
> Where can I configure that???
>
You define the relevant LD_LIBRARY_PATH by exporting it just before you
start the postmaster deamon. That deamon will then propagate the setting
to all backend processes that it spawns, thus making the LD_LIBRARY_PATH
visible to libpljava.so.
- thomas
^ permalink raw reply [nested|flat] 31+ messages in thread
end of thread, other threads:[~2005-04-03 18:18 UTC | newest]
Thread overview: 31+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-12 01:15 [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
2005-02-12 08:48 `
2005-02-12 22:08 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
2005-02-14 16:05 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
2005-02-14 16:44 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library undefined symbol: JNI_CreateJavaVM
2005-02-14 17:00 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
2005-02-14 18:20 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
2005-02-14 19:11 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
2005-04-01 00:46 [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
2005-04-01 06:11 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so
2005-04-01 12:08 [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
2005-04-01 12:43 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
2005-04-01 13:24 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
2005-04-01 13:47 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
2005-04-01 14:01 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
2005-04-01 13:06 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 13:27 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 13:47 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 14:06 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 14:12 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 14:20 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 15:33 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 14:14 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 18:20 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 18:53 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 19:14 ` [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local
2005-04-01 19:07 ` [Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local
2005-04-01 21:49 ` [Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local
2005-04-03 18:18 ` [Pljava-dev] java.sql.SQLException: ERROR:could not loadlibrary"/usr/local
2005-04-01 13:07 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
2005-04-01 13:16 ` [Pljava-dev] java.sql.SQLException: ERROR: could not load library"/usr/local
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox