From: | thomas at tada(dot)se (Thomas Hallgren) |
---|---|
To: | |
Subject: | [Pljava-dev] ERROR: Unable to find static method Active.executeService with signature (Ljava/lang/Integer; Ljava/lang/String; Ljava/lang/Integer; )I |
Date: | 2006-03-29 05:33:42 |
Message-ID: | 442A1C36.3040305@tada.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi Claudio,
You must put your class in a package.
Kind Regards,
Thomas Hallgren
claudio ferraz wrote:
>
> I am having problem defining functions. Im a new user of Pljava and my
> code is the following one:
>
> Function Definition:
>
> CREATE OR REPLACE FUNCTION execute_service(int4, text, int4)
> RETURNS int4 AS
> 'Active.executeService(java.lang.Integer,java.lang.String,java.lang.Integer)'
> LANGUAGE 'java' VOLATILE;
> ALTER FUNCTION execute_service(int4, text, int4) OWNER TO postgres;
>
> My Java Class:
> public class Active {
> public static int executeService(int serviceId, String dewey,int
> docId ) {
> try{
> GerenteServicos gs = new GerenteServicos();
> gs.prepairService (serviceId,dewey,docId);
> return 1;
> }catch(Exception e){
> return 0;
> }
>
> }
> }
>
> My function call :
>
> select execute_service(1,'1',1);
>
> My error:
> ERROR: Unable to find static method Active.executeService with
> signature (Ljava/lang/Integer;Ljava/lang/String;Ljava/lang/Integer;)I
>
> Sorry my poor english e I hope that somebody help me!!!
> Thanks a lot!!!
> --
> Cl?udio A. Ferraz - Analista de Sistemas
> "Se n?o puder fazer tudo, fa?a tudo o que puder."
> "Nigu?m ? rico o suficiente para n?o poder ser ajudado, ningu?m ?
> pobre o suficiente para n?o poder ajudar."
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-03-30 18:29:04 | [Pljava-dev] ERROR: Unable to find static method Active.executeService with signature (Ljava/lang/Integer; Ljava/lang/String; Ljava/lang/Integer; )I |
Previous Message | claudio ferraz | 2006-03-29 03:27:40 | [Pljava-dev] ERROR: Unable to find static method Active.executeService with signature (Ljava/lang/Integer; Ljava/lang/String; Ljava/lang/Integer; )I |