From: | bhaskar_nalamothu at pro-hemns(dot)com (Nalamothu, Bhaskar) |
---|---|
To: | |
Subject: | [Pljava-dev] unable to invoke sample pljava program. |
Date: | 2012-11-01 04:56:41 |
Message-ID: | CAOxerh6nrRM7UQFFRSGb5LLqap8=uBTcWXcsG1mBiQdkxoR7CA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Dear Dev Team,
i am beginner for pljava. i am struggling a lot to invoke a simple pljava
program.
i have done the following things successfully.
*1.Sample java class which is having a static method as follows*
*
*
public static String hello(String hello){
return hello;
}
*2.Installed the jar *
SELECT sqlj.install_jar('file:///D:/Program
Files/PostgreSQL/9.1/lib/PLJAVA_Custom.jar', 'PLJAVA_Custom', true);
jar is loaded into jar_repository table of sqlj schema and also classes are
identified and loaded into jar_entry table of sqlj Schema,
*
*
*3. Set the Classpath successfully*
*
*
*SELECT sqlj.set_classpath('public', 'PLJAVA_Custom');*
*
*
*4. I have created a sample function as follows*
*
*
CREATE OR REPLACE FUNCTION handle_data2(character varying)
RETURNS character varying AS
'pljavaone.DataHandler.hello'
LANGUAGE java VOLATILE
*when i am executing its returning me the following error ERROR:
java.lang.ClassNotFoundException: pljavaone.DataHandler. *
Thanks in advance.
--
Sudha Bhaskar N
Procreate Techno Systems pvt ltd
+91-9948-678-222
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20121101/b7870ba1/attachment.html>
From | Date | Subject | |
---|---|---|---|
Next Message | Nalamothu, Bhaskar | 2012-11-01 11:13:51 | [Pljava-dev] Deployment Descriptor |
Previous Message | Sérgio Saquetim | 2012-10-29 12:04:23 | [Pljava-dev] Postgres 9.2 Version |