agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] RE: Loading of native libraries in PLJAVA
2+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] RE: Loading of native libraries in PLJAVA
@ 2005-03-11 07:37
0 siblings, 1 reply; 2+ messages in thread
From: @ 2005-03-11 07:37 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* [Pljava-dev] RE: Loading of native libraries in PLJAVA
@ 2005-03-11 10:14
parent:
0 siblings, 0 replies; 2+ messages in thread
From: @ 2005-03-11 10:14 UTC (permalink / raw)
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.
>
>
Your code looks correct aside from some missing parenthesis :-).
Just to rule out a couple of possibilities, can you load the
"examples.jar" that is bundled with the PL/Java using sqlj.install_jar
and set the classpath for schema 'javatest' to 'samples' and then run:
SELECT * FROM javatest.propertyExample();
You should get 3 rows. If that works then properties and resources work
OK (it does on my installations). If it doesn't, then something is
majorly wrong.
Is it possible that you have an external CLASSPATH setting that in fact
results in another jar then the one being loaded is used? The external
classpath should _only_ appoint pljava.jar.
What versions of PostgreSQL, PL/Java, and JRE are you using?
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-11 10:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-11 07:37 [Pljava-dev] RE: Loading of native libraries in PLJAVA
2005-03-11 10:14 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox