Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 61128 invoked by uid 99); 11 Feb 2005 03:14:12 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.cruzio.com (HELO mail.cruzio.com) (63.249.95.37) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 10 Feb 2005 19:14:11 -0800 Received: from waddell.cruzio.com (dsl3-63-249-87-8.cruzio.com [63.249.87.8]) by mail.cruzio.com with ESMTP id j1B3E6YN015979 for ; Thu, 10 Feb 2005 19:14:10 -0800 (PST) Message-Id: <6.2.0.14.2.20050210191146.01e16330@mail.cruzio.com> X-Mailer: QUALCOMM Windows Eudora Version 6.2.0.14 Date: Thu, 10 Feb 2005 19:14:09 -0800 To: ibatis-user-java@incubator.apache.org From: Richard Yee Subject: Re: Returning Multiple Resultsets from a Stored Procedure In-Reply-To: <16178eb1050210190152092bae@mail.gmail.com> References: <16178eb1050210190152092bae@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Checked: Checked Clinton, When you replied then that iBATIS can handle a resultset returned by a stored procedure, the stored procedure was being invoked using the executeQuery() method? Thanks, Richard At 07:01 PM 2/10/2005, you wrote: >Nobody mentioned REF_CURSORS. I was strictly talking about a standard >resultset being returned from executeQuery(). > >The last email about using a Custom Type handler is correct. Ref >cursors can be supported that way. > >Cheers, > >Clinton > >On Fri, 11 Feb 2005 01:20:00 -0000, Yee, Richard K, CTR,, DMDCWEST > wrote: > > Clinton, > > I guess I'm a little confused then about the current limitations of iBATIS > > and stored procedures. I thought I read in the archives that iBATIS didn't > > handle REF_CURSORS as an OUT parameter from a stored procedure. > > > > Please excuse me if my questions are a little ignorant because I haven't > > done much work with stored procedures. > > > > What I need iBATIS to do is be able to get the result set returned by a > > stored procedure. > > > > Thanks, > > > > Richard > > > > -----Original Message----- > > From: Clinton Begin [mailto:clinton.begin@gmail.com] > > Sent: Thursday, February 10, 2005 5:06 PM > > To: ibatis-user-java@incubator.apache.org > > Subject: Re: Returning Multiple Resultsets from a Stored Procedure > > > > Absolutely. > > > > Cheers, > > Clinton > > > > On Fri, 11 Feb 2005 00:49:41 -0000, Yee, Richard K, CTR,, DMDCWEST > > wrote: > > > Clinton, > > > Does iBATIS support even one resultSet (multiple rows) from a Stored > > > Procedure? > > > > > > Thanks, > > > > > > Richard > > > > > > > > > -----Original Message----- > > > From: Clinton Begin [mailto:clinton.begin@gmail.com] > > > Sent: Thursday, February 10, 2005 4:39 PM > > > To: ibatis-user-java@incubator.apache.org > > > Subject: Re: Returning Multiple Resultsets from a Stored Procedure > > > > > > Nope. Not at this time. > > > > > > It doesn't fit our single input/single output semantic. > > > > > > Cheers, > > > Clinton > > > > > > On Mon, 07 Feb 2005 14:02:15 +1100, Dan Batten > > > wrote: > > > > Gidday, > > > > > > > > I'm very interested in using iBatis for my next project but have > > > > been unable to find any answer to the question: > > > > > > > > Does iBatis support returning multiple resultsets from one stored > > > > procedure? > > > > > > > > If it does could you please post a simple example. > > > > > > > > Cheers, > > > > Dan. > > > > > > > > >