ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Multiple ResultSet
Date Thu, 13 Jul 2006 21:12:19 GMT
Makes sense - I hadn't thought about the multiple selects thing.  Makes it
easier too.

I can redo the comma delimited list thing - pretty easy I think.

Jeff


On 7/13/06, Clinton Begin <clinton.begin@gmail.com> wrote:
>
> Brandon and I were looking at this, and we figure that it should be
> possible to implement it for both procedures and regular statements (some
> DBs support multiple selects in a single statement).
>
> We shouldn't need a new method on the pulbic interface, as queryForList()
> should cover it (a list of "whatevers" -- lists and objects).  But
> otherwise, sounds good.
>
> We'd need a comma delimited list of result maps in the configuration
> (Brandon's patch for that is sitting on my hard drive, but not checked in).
>
> Brandon also put Derby into our build so that we can test procs now,
> including things like this (although two selects in a single statement might
> be a good enough test).
>
> Cheers,
>
> Clinton
>
>
> On 7/13/06, Jeff Butler <jeffgbutler@gmail.com> wrote:
> >
> >  I'll take a look at this if you still want help.
> >
> > Here's what I would do:
> >
> > - Change it so the you could specify a comma delimited list in the
> > resultClass or resultMap on the <procedure> declaration
> > - Add a new method to SqlMapExecuter called executeProcedure that
> > returns a list (takes id and optionally a parameter object)
> > - The list would contain all result sets from the procedure, and would
> > also return any other non-resultSet results (as Objects) from the
> > procedure.  It would be up to the user to deal with the order - we would
> > return in whatever order the procedure returned them.
> > - If there are more resultSets than resultMaps, then throw an exception
> > - I guess we could add another method that would accept an array of
> > RowHandlers too if you think that would be a good idea
> >
> > Everything else would remain as is - these would be new methods only.
> >
> > Should be pretty easy to do.
> >
> > Thoughts??
> >  Jeff Butler
> >
> >
> > On 7/12/06, Clinton Begin < clinton.begin@gmail.com> wrote:
> > >
> > > Not yet, but I'm supposed to be working on that right now.
> > > Unfortunately I've been swamped.
> > >
> > > It should be going out with the next release (2.2.0) -- is anyone
> > > interested in taking this over?  The earliest I think I'll get to it is next
> > > week.
> > >
> > > Cheers,
> > >
> > > Clinton
> > >
> > >
> > >
> > > On 7/12/06, Cornel Antohi < cantohi@kepler-rominfo.com> wrote:
> > > >
> > > >  Hi,
> > > >
> > > > Does iBatis support multiple ResultSet returned by a
> > > > StoredProcedure?
> > > >
> > > > Thank you,
> > > > Cornel
> > > >
> > >
> > >
> >
>

Mime
View raw message