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

Hi Cladio,
Since you catch the exception and discard all information in it, I'm not
too surprised if you can't see an error :-)

Try using:

Logger.getAnonymousLogger().log(Level.SEVERE, e.toString(), e);

in your catch clause. Another way is to not catch the exception at all.
If you define the config parameter 'log_min_messages = DEBUG1' all
stacktraces will be printed for uncaught exceptions.

Regards,
Thomas Hallgren

PS.
Please CC the pljava-dev mailing list when you ask questions. The
community is there for our mutual benefit.

claudio ferraz wrote:
> Hi Tomas,
> I placed my project in a package, and partially it functioned. But I
> am having problems in the function call. I do not obtain to see where
> it is the error.
>
> My function definition :
> CREATE OR REPLACE FUNCTION execute_service(int4, text, int4)
> RETURNS int4 AS
> 'axml.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 Class:
>
> package axml;
> 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(16,'1.2',79);
>
> Thanks so much!!!
>
>
>
>
> On 3/29/06, *Thomas Hallgren* <thomas at tada.se <mailto:thomas at tada.se>>
> wrote:
>
> 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
> <mailto:Pljava-dev at gborg.postgresql.org>
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >
>
>
>
>
> --
> 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."