You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Frederick A. Daria (JIRA)" <ib...@incubator.apache.org> on 2005/02/21 09:33:49 UTC
[jira] Commented: (IBATIS-28) Support multiple results from Stored Procedures
[ http://issues.apache.org/jira/browse/IBATIS-28?page=comments#action_59490 ]
Frederick A. Daria commented on IBATIS-28:
------------------------------------------
Hi,
I also believe that this feature is very useful, I'm currently working on a financial application calling a Cobol based stored procedure that returns 2 Cursors as result set and we're using iBATIS all throughout the project, but in this case, I had to code it in JDBC to be able to retrieve all the results.
I'm not sure as to how we could interface with it in code, but I guess sql map client could either return a map of objects or a collection of collections or something related to that.
Cheers,
Darrix
> 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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira