ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Yee <r...@cruzio.com>
Subject Re: Returning Multiple Resultsets from a Stored Procedure
Date Fri, 11 Feb 2005 03:14:09 GMT
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
><Richard.Yee.ctr@osd.pentagon.mil> 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
> > <Richard.Yee.ctr@osd.pentagon.mil> 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 <danatten@gmx.net>
> > > 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.
> > > >
> > >
> >



Mime
View raw message