ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Returning Multiple Resultsets from a Stored Procedure
Date Fri, 11 Feb 2005 07:25:50 GMT
It depends how you call it.  If you use queryForXxxx() iBATIS will use
executeQuery(), if you use insert/update/delete, it will use
executeUpdate().

Cheers,
Clinton

On Thu, 10 Feb 2005 19:14:09 -0800, Richard Yee <ryee@cruzio.com> wrote:
> 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