db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From IkeAbalogu <ikeabal...@hotmail.com>
Subject Re: stored procedure tutorial help
Date Sat, 02 Jul 2011 12:13:11 GMT

CALL sqlj.install_jar('c:\previousbalance.jar', 'APP.UPDATEDIPRECORD', 0);

CALL
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath','APP.UPDATEDIPRECORD');

VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.classpath');
confirms the property has been set

CREATE PROCEDURE UPDATEDIPRECORD()
  PARAMETER STYLE JAVA
  LANGUAGE JAVA
  DYNAMIC RESULT SETS 4
  EXTERNAL NAME
'storedprocedures.UpdatePreBalanceSP.UpdatePreviousBalanceSP';

Call UPDATEDIPRECORD();

A call to the stored procedure returns this exception: 
ERROR 42X50. No method was found that matched the method call
storedprocedures.UpdatePreBalanceSP.UpdatePreviousBalanceSP(java.sql.ResultSet[]),
tried all combinations of object and primitive types and any possible type
conversion for any  parameters the method call may have. The method might
exist but it is not public and/or static, or the parameter types are not
method invocation convertible.
Please help.

BTW:Thanks for all your help.I really really appreciate all of them.


Rick Hillegas-3 wrote:
> 
> On 6/28/11 4:45 AM, IkeAbalogu wrote:
>> I am trying to find websites with tutorial on derby stored procedures.i
>> find
>> the reference manual article confusing.
>> Thanks
> There is also some material in the Developer's Guide: 
> http://db.apache.org/derby/docs/10.8/devguide/devguide-single.html#cdevspecial
> 
> ...and some material on the Derby wiki: 
> http://wiki.apache.org/db-derby/DerbySQLroutines
> 
> In addition, the Derby scores demo shows how to write functions and 
> procedures. In your Derby release, look at demo/programs/scores/README
> 
> Hope this helps,
> -Rick
> 
> 

-- 
View this message in context: http://old.nabble.com/stored-procedure-tutorial-help-tp31945511p31979194.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message