[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

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

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

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

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

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'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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