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 CFDCF96D4 for ; Sun, 4 Mar 2012 23:04:24 +0000 (UTC) Received: (qmail 15727 invoked by uid 500); 4 Mar 2012 23:04:24 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 15655 invoked by uid 500); 4 Mar 2012 23:04:23 -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 15648 invoked by uid 99); 4 Mar 2012 23:04:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Mar 2012 23:04:23 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_HELO_PASS,SPF_PASS,SUBJ_OBFU_PUNCT_FEW X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gcaddu-derby-user@m.gmane.org designates 80.91.229.3 as permitted sender) Received: from [80.91.229.3] (HELO plane.gmane.org) (80.91.229.3) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Mar 2012 23:04:15 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1S4KT2-00040p-0v for derby-user@db.apache.org; Mon, 05 Mar 2012 00:03:52 +0100 Received: from p5481FECA.dip.t-dialin.net ([84.129.254.202]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 05 Mar 2012 00:03:51 +0100 Received: from Thomas.K.Hill by p5481FECA.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 05 Mar 2012 00:03:51 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: Thomas Hill Subject: Returning java.sql.ResultSets from Java procedures Date: Sun, 4 Mar 2012 23:03:43 +0000 (UTC) Lines: 11 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: sea.gmane.org User-Agent: Loom/3.14 (http://gmane.org/) X-Loom-IP: 84.129.254.202 (Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3) X-Virus-Checked: Checked by ClamAV on apache.org Hi, can someone please share an example how the Client side application code to call procedure looks like when I want my stored procedure to return TWO resultsets? The derby Wiki (extract see below) says 'WORK IN PROGRESS' in the section where documentation on this had been started. CallableStatement cs = conn.prepareCall("{ call DRS2(?, ?)}"); cs.setInt(1, p1); cs.setInt(2, p2); cs.execute(); WORK IN PROGESS