db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: function in derby[beginner]
Date Tue, 03 Apr 2007 15:51:05 GMT
Tony Winslow wrote:
> I have this class:
> public class Say {
>   public static int say(int i) {
>     System.out.println("* Say: " + i);
>     return i;
>   }
> 
>  public static int say2(String msg) {
>        System.out.println("** " + msg);
>        return 1;
>  }
> 
> }
>  
> and I created a function in Derby:
> create function say2(msg varchar(50)) returns integer
> parameter style java no sql language java
> external name 'Say.say2';
> 
> but when I want to use it, error occurs:
> ERROR 42X50: No method was found that matched the method call
> Say.say2(java.lang
> .String), tried all combinations of object and primitive types and any
> possible
> type conversion for any  parameters the method call may have. The
> method might e
> xist but it is not public and/or static, or the parameter types are
> not method i
> nvocation convertible.

Can you show the exact SQL statements that you tried to execute and that
got error 42X50?

Also, what version of Derby are you using? This command will output
version info for all releases of derby:

   java org.apache.derby.tools.sysinfo

regards,

 -jean

> And I created another function:
> create function say(i integer) returns integer
> parameter style java no sql language java
> external name 'Say.say';
> 
> It works fine.
> 
> I've tried hard to figure it out but failed. Can anybody help me?
> 
> Thank you in advance!!!
> 


Mime
View raw message