agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

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
>   

view thread (4+ messages)  latest in thread

Message-ID: <442A1C36.3040305@tada.se>
Permalink:  ../442A1C36.3040305@tada.se/
Also on:    postgresql.org/message-id/442A1C36.3040305@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [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: <442A1C36.3040305@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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