Multiple ResultSet

[Cornel Antohi <ca...@kepler-rominfo.com>]

Hi,

Does iBatis support multiple ResultSet returned by a StoredProcedure?

Thank you,
Cornel

Re: Multiple ResultSet

[Clinton Begin <cl...@gmail.com>]

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 <je...@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 <cl...@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
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Re: Multiple ResultSet

[Jeff Butler <je...@gmail.com>]

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 <cl...@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 <je...@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
> > > >
> > >
> > >
> >
>

Re: Multiple ResultSet

[Clinton Begin <cl...@gmail.com>]

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 <je...@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 <cl...@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
> > >
> >
> >
>

Re: Multiple ResultSet

[Jeff Butler <je...@gmail.com>]

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 <cl...@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 <ca...@kepler-rominfo.com> wrote:
> >
> >  Hi,
> >
> > Does iBatis support multiple ResultSet returned by a StoredProcedure?
> >
> > Thank you,
> > Cornel
> >
>
>

Re: Multiple ResultSet

[Clinton Begin <cl...@gmail.com>]

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 <ca...@kepler-rominfo.com> wrote:
>
>  Hi,
>
> Does iBatis support multiple ResultSet returned by a StoredProcedure?
>
> Thank you,
> Cornel
>