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

Please see the comments below .

Waiting for ur reply.

Thanx in advance
Mohammed

-----Original Message-----
From: Thomas Hallgren [mailto:thhal at mailblocks.com]
Sent: Thursday, March 10, 2005 10:00 PM
To: Nageshwar Rao
Cc: Mohammed Mudassir; pgsql-general at postgresql.org
Subject: Re: Loading of native libraries in PLJAVA

Nageshwar,
This is not the right forum for PL/Java issues. You should use mailing
list at pljava-dev at gborg.postgresql.org.
> 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).

>
> 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.
(Mohammed) 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).
(Mohammed) 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.

Regards,
Thomas Hallgren