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 <[EMAIL PROTECTED]> 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 > ><[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > > Sent: Thursday, February 10, 2005 5:06 PM > > > To: [email protected] > > > 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 > > > <[EMAIL PROTECTED]> wrote: > > > > Clinton, > > > > Does iBATIS support even one resultSet (multiple rows) from a Stored > > > > Procedure? > > > > > > > > Thanks, > > > > > > > > Richard > > > > > > > > > > > > -----Original Message----- > > > > From: Clinton Begin [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, February 10, 2005 4:39 PM > > > > To: [email protected] > > > > 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 <[EMAIL PROTECTED]> > > > > 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. > > > > > > > > > > > > > >
