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 <[EMAIL PROTECTED]> 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 <[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 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 < [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 > > > > > > > > > > > >
