From: thomas at tada.se (Thomas Hallgren)
Date: Thu, 30 Mar 2006 20:29:04 +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: <d522589d0603301015s3c89e88fnf1e4dbe241014a92@mail.gmail.com>
References: <d522589d0603281927v44f02062xd8ed7b0f014e713@mail.gmail.com>	
	<442A1C36.3040305@tada.se>
	<d522589d0603301015s3c89e88fnf1e4dbe241014a92@mail.gmail.com>
Message-ID: <442C2370.3050000@tada.se>

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."