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 <[EMAIL PROTECTED]> 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 < [EMAIL PROTECTED]> 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 ideaEverything 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 < [EMAIL PROTECTED]> 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 < [EMAIL PROTECTED]> wrote:Hi,Does iBatis support multiple ResultSet returned by a StoredProcedure?Thank you,Cornel
