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 00:27:40 -0300
Message-ID: <d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com> (raw)

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://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060329/84db2dc9/attachment.html;

view thread (4+ messages)  latest in thread

Message-ID: <d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com>
Permalink:  ../d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com/
Also on:    postgresql.org/message-id/d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com

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: <d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com>

* 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