Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 25858 invoked from network); 25 Jan 2008 11:19:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Jan 2008 11:19:34 -0000 Received: (qmail 54846 invoked by uid 500); 25 Jan 2008 11:19:24 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 54811 invoked by uid 500); 25 Jan 2008 11:19:24 -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 54799 invoked by uid 99); 25 Jan 2008 11:19:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jan 2008 03:19:23 -0800 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-mail-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jan 2008 11:18:56 +0000 Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe3.eu.sun.com [192.18.6.12]) by gmp-eb-mail-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m0PBJ19O008501 for ; Fri, 25 Jan 2008 11:19:01 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JV700C015ZTBR00@fe-emea-09.sun.com> (original mail from Dyre.Tjeldvoll@Sun.COM) for derby-user@db.apache.org; Fri, 25 Jan 2008 11:19:01 +0000 (GMT) Received: from khepri32.sun.com ([129.159.112.244]) by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JV700KCP63M9Y10@fe-emea-09.sun.com> for derby-user@db.apache.org; Fri, 25 Jan 2008 11:18:59 +0000 (GMT) Date: Fri, 25 Jan 2008 12:18:58 +0100 From: Dyre.Tjeldvoll@Sun.COM Subject: Re: Installing and Using Java Procedures. In-reply-to: <1c0e93080801241347u1e311015u3c981dca307b791a@mail.gmail.com> Sender: Dyre.Tjeldvoll@Sun.COM To: Derby Discussion Message-id: MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT References: <1c0e93080801241257w3a294d84m7643f2e67689deca@mail.gmail.com> <479901DD.8030800@apache.org> <1c0e93080801241347u1e311015u3c981dca307b791a@mail.gmail.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/22.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org Briggs writes: > Hey, thanks for your reply. I am still way confused on this. And > trying to find examples of the SQL/JRT spec is almost impossible. I > am trying to make some sense of the examples of creating store > procedures off the http://wiki.apache.org/db-derby/DerbySQLroutines > wiki page with no avail. I am just trying to find the actual > rules/spec/documentation on doing this. Don't know if it helps, but you could take a look at one of Derby's unit tests for procedures. For example https://svn.apache.org/repos/asf/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ProcedureTest.java -- dt