From derby-user-return-13743-apmail-db-derby-user-archive=db.apache.org@db.apache.org Sat Jul 2 12:13:41 2011 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 409F161B2 for ; Sat, 2 Jul 2011 12:13:41 +0000 (UTC) Received: (qmail 5312 invoked by uid 500); 2 Jul 2011 12:13:40 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 5264 invoked by uid 500); 2 Jul 2011 12:13:39 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 5257 invoked by uid 99); 2 Jul 2011 12:13:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jul 2011 12:13:39 +0000 X-ASF-Spam-Status: No, hits=1.2 required=5.0 tests=FORGED_HOTMAIL_RCVD2,FREEMAIL_FROM,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jul 2011 12:13:33 +0000 Received: from isper.nabble.com ([192.168.236.156]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Qcz4R-0006Pu-9x for derby-user@db.apache.org; Sat, 02 Jul 2011 05:13:11 -0700 Message-ID: <31979194.post@talk.nabble.com> Date: Sat, 2 Jul 2011 05:13:11 -0700 (PDT) From: IkeAbalogu To: derby-user@db.apache.org Subject: Re: stored procedure tutorial help In-Reply-To: <4E09D7C7.1080607@oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ikeabalogu@hotmail.com References: <31945511.post@talk.nabble.com> <4E09D7C7.1080607@oracle.com> X-Virus-Checked: Checked by ClamAV on apache.org 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.