Multiple resultsets SpringStoredProc and Ibatis
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