Multiple resultsets SpringStoredProc and Ibatis

[yo...@tcs.com]

Hi ,

This mail is w.r.t multiple result sets returned from stored proc.

I am using ibatis in my persistence layer extensively, because of ibatis
doesn’t support multiple resultsets   wherever my procedure returns one
resultsets I am  using Ibatis but if my procedure returns multiple then I
am using Spring stored procedure where I written RowMappers class to map
result sets information to Javabean object.

My question is

1. Is this design decision right..?

2. Is there any way to implement this in best way. like..

 A. Can we make use of iBatis sqlMaps definitions or any other way to map
resultsets (which are returned from spring stored proc) to Java Bean object
?

Right now I am using spring RowMappers

B. Is anybody having an idea of solving this in more abstract way. (using
ibatis+spring stored proc)


Thanks in advance
Yogish
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you