Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 43923 invoked from network); 31 May 2008 12:01:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 May 2008 12:01:45 -0000 Received: (qmail 54843 invoked by uid 500); 31 May 2008 12:01:47 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 54817 invoked by uid 500); 31 May 2008 12:01:46 -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 54806 invoked by uid 99); 31 May 2008 12:01:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 31 May 2008 05:01:46 -0700 X-ASF-Spam-Status: No, hits=3.2 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [196.25.240.79] (HELO ctb-mesg-1-1.saix.net) (196.25.240.79) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 31 May 2008 12:00:55 +0000 Received: from animal (dsl-243-86-157.telkomadsl.co.za [41.243.86.157]) by ctb-mesg-1-1.saix.net (Postfix) with SMTP id E2BB853AA for ; Sat, 31 May 2008 14:00:56 +0200 (SAST) Message-ID: <003a01c8c316$0cffb2c0$0300000a@animal> From: "Johnny Kewl" To: "Derby Discussion" References: <18db29d30805302026h4e828e6dud5f9435915164041@mail.gmail.com> Subject: Re: How to return an array of String in a Java routine? Date: Sat, 31 May 2008 14:01:14 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0037_01C8C326.C9F79A40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Antivirus: avast! (VPS 080413-0, 2008/04/13), Outbound message X-Antivirus-Status: Clean X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_0037_01C8C326.C9F79A40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ----- Original Message -----=20 From: sin(EaTing),=20 To: Derby Discussion=20 Sent: Saturday, May 31, 2008 5:26 AM Subject: How to return an array of String in a Java routine? Hi, I want to return an array of Strings from a Java routine. How could I = create the procedure declaration and definition. This is a little vague String[] maybe? Or mabe you asking how to make a record holder? not sure Or if possible could I create my own ResultSet in my Java routine, and = manually insert rows into that ResultSet? Try a disconnected recordset Google for CachedRowSetImpl You can create a cached recordset, add remove records without the = dB and later resync with the dB if you want to. Good Luck On this site you may find some code to steal = -------------------------------------------------------------------------= -- HARBOR : http://www.kewlstuff.co.za/index.htm The most powerful application server on earth. The only real POJO Application Server. See it in Action : = http://www.kewlstuff.co.za/cd_tut_swf/whatisejb1.htm = -------------------------------------------------------------------------= -- ------=_NextPart_000_0037_01C8C326.C9F79A40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
----- Original Message -----
From:=20 sin(EaTing),=20
Sent: Saturday, May 31, 2008 = 5:26=20 AM
Subject: How to return an array = of String=20 in a Java routine?

Hi,

I want to return an array of Strings from a Java = routine. How=20 could I create the procedure declaration and definition.
    This is a little=20 vague
    String[] = maybe?
    Or mabe = you asking=20 how to make a record holder? not sure
Or if possible could I create my own ResultSet in my Java = routine, and=20 manually insert rows into that ResultSet?
 
    Try a = disconnected=20 recordset
    Google for=20 CachedRowSetImpl
    You can create a = cached=20 recordset, add remove records without the dB and later resync with the = dB if=20 you want to.

Good Luck
 
On this site you may find some code = to=20 steal
----------------------------------------------------------------= -----------
HARBOR=20 : http://www.kewlstuff.co.za/= index.htm
The=20 most powerful application server on earth.
The only real POJO = Application=20 Server.
See it in Action : http://www.= kewlstuff.co.za/cd_tut_swf/whatisejb1.htm
------------------------= ---------------------------------------------------
------=_NextPart_000_0037_01C8C326.C9F79A40--