[Pljava-dev] ERROR: Unable to find static method Active.executeService with signature (Ljava/lang/Integer; Ljava/lang/String; Ljava/lang/Integer; )I

[claudio ferraz]

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."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20060329/84db2dc9/attachment.html