[Pljava-dev] Subject: Re: Loading of native libraries in PLJAVA

Hi,
Once again posting in developer forum.Help appreciated.Below running mail
posted in other forum.

thx
Rao

We are facing 2 problems in loading files from Pljava.

1. Loading Native C library from Pljava trigger.

From Pljava trigger, we were trying to load native
library, Using System.loadLibrary("<library_name>"), which is specified in
the LD_LIBRARY_PATH.

The likely cause of this is that this library in turn have dependencies
to something not specified in the LD_LIBRARY_PATH or that you have some
mismatch in function naming. That in turn should be apparent from the
exception message (can't tell since you didn't convey it here)( one of
members reply)

Also specified the library file under /var/lib/pljava
where all the pljava specifc "*.so" files are located, which has an
entry in the postgresql.conf -
dynamic_library_path for "/var/lib/pljava",


Both theses cases failed to load native library.

we are getting this error in both cases-
UnSatisfiedLinkedError

The dynamic_library_path is only used by the PostgreSQL backend when it
loads a module. It has no effect whatsoever on the System.loadLibrary
method.(one of members reply)

(Nageshwar) We are using a ping utility (libping.so - freeware) to ping
network devices.
We have written a insert trigger on network table, when there is any
insertion in the table , ipaddress will be
fetched from the triggereddata and we call a C library via JNI to ping the
device. The error still remains the same.
can you replicate the same error at your end and help us in fixing the
error.
>
> 2. Loading Properties file from trigger. (using
> Properties.load(<properties_name.properties>))
> We are unable to load properties file from
> Properties.load("<properties_name.properties>").
> we have included properties file in jar file and
> installed the jar and set the jar file in the classpath using
> "sqlj.set_classpath".
>
To my knowledge there's Properties.load method that takes a String argument.
You have to use the Class.getResourceAsString() in order to obtain an
InputStream for a resource stored in a jar file. The class in question
should be in the same package as the resource (i.e. your properties
file).(one of members reply)

(Nageshwar) We have written a insert trigger on network table, when ever
there is insertion in the table, we are reading a property file and modify
the values with the inserted data and insert the modified values in another
table.
We are unable to read the properties file (which is present in the installed
jar file at the root as well as at the class file level)

Here is the hierarchy structure, where i have placed properties files
gis.jar
gis.properties
com
me
mis
pgtrigger

PropertiesTrigger

gis.properties

.

Here is the code to access gis.properties file

PropertiesTrigger.java

Properties properties = new Properties
InputStream is =
this.getClass().getResourceAsStream("gis.properties");
SOP ("INPUTSTREAM "+is);
properties.load(is);
is.close();

null at SOP for the inputstream.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050311/efa14a8b/attachment.html>