pg.ddx.io  pljava-dev@postgresql.org mailing list archive  

help / color / mirror / Atom feed

[Pljava-dev] unable to invoke sample pljava program.
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] unable to invoke sample pljava program.
@ 2012-11-01 04:56  
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2012-11-01 04:56 UTC (permalink / raw)

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;



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] unable to invoke sample pljava program.
@ 2012-11-01 12:03  
  parent: 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2012-11-01 12:03 UTC (permalink / raw)

You need to add the parameter type to the java signature in the definition. 

Sent from my Tricorder

On Oct 31, 2012, at 9:56 PM, "Nalamothu, Bhaskar" <bhaskar_nalamothu at pro-hemns.com> wrote:

> 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
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20121101/d68ee234/attachment.html;



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2012-11-01 12:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-01 04:56 [Pljava-dev] unable to invoke sample pljava program. 
2012-11-01 12:03 ` 

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox