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: Multiple ResultSet
Date Thu, 13 Jul 2006 21:15:09 GMT
I'd love for you to give it a shot.  I think that's the biggest
feature delaying 2.2.0 (by choice I suppose).  So as soon as it's
done, the other things are minor and we can ship it!

Let me know if you run into a snag.

Thanks Jeff,

Clinton


On 7/13/06, Jeff Butler <jeffgbutler@gmail.com> wrote:
>
> 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