Hi,
I am executing a Stored procedure that returns the following resultset.
1, Firstname1, lastname1, homeaddress
1, Firstname1, lastname1, webaddress
1, Firstname1, lastname1, businessaddress
2, Firstname2, lastname2, webaddress
2, Firstname2, lastname2, businessaddress
I am using Spring StoredProcedure and maprow. My Domain object is as below
Class Person {
String firstname;
String lastname;
List address;
}
So one person can have a list of address. But when i use maprow, its returning Object for each record in the resultset where as i need to iterate the resultset conditionally and return it appropriatly. That is i need the maprow to return only after iterating the first three resultset then iterating the next two result set.
is there any way to do this in Spring StoredProcedure? I shouldnt use jdbcTemplate.
Any suggestions?