agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
@ 2004-08-10 20:05
0 siblings, 1 reply; 4+ messages in thread
From: @ 2004-08-10 20:05 UTC (permalink / raw)
Hi,
I am getting the following error message when i am trying to deploy pl/java
java.sql.SQLException: ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so: cannot open shared object file: Arquivo ou diret?o n?encontrado
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:227)
at org.postgresql.pljava.deploy.Deployer.initJavaHandler(Unknown Source)
at org.postgresql.pljava.deploy.Deployer.main(Unknown Source)
I read http://gborg.postgresql.org/project/pljava/genpage.php?readme and my environment variables are :
CLASSPATH=:/postgresql-7.4.2/pljava.jar:/jakarta-tomcat-4.1.18/common/lib/postgresql.jar:/postgresql-7.4.2/deploy.jar
LD_LIBRARY_PATH=:/download/j2sdk1.4.2_05/jre/lib/i386/server:/download/j2sdk1.4.2_05/jre/lib/i386/client
JAVA_HOME=/download/j2sdk1.4.2_05
ls -l /download/j2sdk1.4.2_05/jre/lib/i386/server
-rwxrwxr-x 1 root root 7682176 Jun 4 01:29 libjvm.so
ls -l /postgresql-7.4.2/libpljava.so
-rw-r--r-- 1 postgres adm 125179 Mai 7 18:40 /postgresql-7.4.2/libpljava.so
Regards,
[]'s
Rodrigo - Syspoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20040810/b58c3baf/attachment.html;
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
@ 2004-08-10 21:04
parent:
0 siblings, 0 replies; 4+ messages in thread
From: @ 2004-08-10 21:04 UTC (permalink / raw)
Gilberto,
> I am getting the following error message when i am trying to deploy
> pl/java
>
> java.sql.SQLException: ERROR: could not load library
> "/postgresql-7.4.2/libpljava.so": libjvm.so: cannot open shared object
> file: Arquivo ou diret?o n?encontrado
>
Your LD_LIBRARY_PATH points to the $JAVA_HOME/jre/lib/i386/server but
not to the directory above it where a lot of neede shared object files
reside. The error reported from the shared object loader is probably
somewhat misleading. It does indeed find the libjvm.so but it fails on
one of its dependencies. Try this setting instead:
$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client
You should never use both the client VM and server VM in your
LD_LIBRARY_PATH. The client VM is faster on start-up and consumes less
memory while the server vm is more aggressive with optimizations and
will run faster in the long run (and consume some more memory).
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Re: ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
@ 2004-08-11 16:28
0 siblings, 1 reply; 4+ messages in thread
From: @ 2004-08-11 16:28 UTC (permalink / raw)
Hi Thomas,
> I am getting the following error message when i am trying to deploy
> pl/java
>
> java.sql.SQLException: ERROR: could not load library
> "/postgresql-7.4.2/libpljava.so": libjvm.so: cannot open shared object
> file: Arquivo ou diret?o n?encontrado
>
>Your LD_LIBRARY_PATH points to the $JAVA_HOME/jre/lib/i386/server but
>not to the directory above it where a lot of neede shared object files
>reside. The error reported from the shared object loader is probably
>somewhat misleading. It does indeed find the libjvm.so but it fails on
>one of its dependencies. Try this setting instead:
>$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client
>Regards,
>
>Thomas Hallgren
First, thank you for your response. I'm very interested in your project.
I will go write my Oracle Stored Procedures (PL/SQL) and PL/PGSQL Stored Procedures in JAVA.
I was tested three days ago LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client and how not run I put "/server" because I found libjvm.so in this directory. It was a tentative. Not Run, then
i try now $JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client but the error continue.
I'm executing "java org.postgresql.pljava.deploy.Deployer -install -user postgres -database teste" as user postgres. Correct ? Are permissions maybe ?
Regards,
Rodrigo - Syspoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20040811/416df146/attachment.html;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PCarta SYSPOINT 2.jpg
Type: image/jpeg
Size: 24188 bytes
Desc: not available
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20040811/416df146/attachment.jpg;
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Re: ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
@ 2004-08-11 17:22
parent:
0 siblings, 0 replies; 4+ messages in thread
From: @ 2004-08-11 17:22 UTC (permalink / raw)
Rodrigo,
> First, thank you for your response. I'm very interested in your
> project.
> I will go write my Oracle Stored Procedures (PL/SQL) and PL/PGSQL
> Stored Procedures in JAVA.
> I was tested three days ago
> LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client
> and how not run I put "/server" because I found libjvm.so in this
> directory. It was a tentative. Not Run, then
> i try now $JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client
> but the error continue.
> I'm executing "java org.postgresql.pljava.deploy.Deployer -install
> -user postgres -database teste" as user postgres. Correct ? Are
> permissions maybe ?
I doubt it's a permission problem. I'm not fluent in Spanish but I guess
that "Arquivo ou diret?o n?encontrado" is "No such file or directory"?
If that is the case, it means the it does find libjava.so and then
either does not find the libjvm.so or one of it's dependents.
For what process is the LD_LIBRARY_PATH in effect? Perhaps you set it
for the client process (i.e. the java command)? If so, that's the
problem. The LD_LIBRARY_PART must be exported so that it is available to
the postmaster server process. The client java process doesn't need it
at all.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-08-11 17:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-10 20:05 [Pljava-dev] ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
2004-08-10 21:04 ` [Pljava-dev] ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
2004-08-11 16:28 [Pljava-dev] Re: ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
2004-08-11 17:22 ` [Pljava-dev] Re: ERROR: could not load library "/postgresql-7.4.2/libpljava.so": libjvm.so
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox