From: thomas at tada.se (Thomas Hallgren)
Date: Wed, 29 Mar 2006 07:33:42 +0200
Subject: [Pljava-dev] ERROR: Unable to find static
 method	Active.executeService with signature (Ljava/lang/Integer;
 Ljava/lang/String; Ljava/lang/Integer; )I
In-Reply-To: <d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com>
References: <d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com>
Message-ID: <442A1C36.3040305@tada.se>

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
>