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

[Thomas Hallgren]

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