[ http://issues.apache.org/jira/browse/IBATIS-28?page=comments#action_66492 ] Brandon Goodin commented on IBATIS-28: --------------------------------------
If you have multiple results coming back then i think the select or procedure should have multiple resultMaps that it can be assigned to (resultMap="resultMapOne,resultMap2"). Then i'd think you could pass this back as an Object[] and/or List[]. It might require a couple different methods added to the SqlExecutor to return a multiple result object[] (public Object[] queryForMultipleObject(...), public List[] queryForMultipleList(...)). Thoughts? > Support multiple results from Stored Procedures > ----------------------------------------------- > > Key: IBATIS-28 > URL: http://issues.apache.org/jira/browse/IBATIS-28 > Project: iBatis for Java > Type: Improvement > Components: SQL Maps > Versions: 2.0.8 > Environment: All > Reporter: Christopher John Gores > > It seems there is no support for multiple results being returned by a stored > procedure (i.e. statement.getMoreResults()). Unfortunately, that's a > showstopper for my new project that needs to call legacy procedures. > Suggested solution: Allow a statement to use an ordered collection of > resultMaps, either by creating a new <resultMapSet> tag, allowing <resultMap> > to nest, or by allowing the statement's resultMap attribute to hold a > comma-separated list of resultMaps. The resulting object would have to be a > List of mapped result objects. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
