Mar 8th, 2010, 09:36 AM
storedprocedure class+multiple resultsets+mapper class
i am implementing call to stored procedure through a class and using row mapper to process returned resultsets.
i have following scenario in db2 stored proc
it returns results by querying 2 tables,which are related as one-to-many relationship
for every selected row of resultset "a" from table "a",from second table, proc returns a set of rows in a resultset.
for this situation can you please suggest how and what out paramaters shuold be registered.how should i write mapper classes for both the resultsets.
point to note:second result set is variable in term of no. of instances returned by proc.
please do share you experience about implementing such case.if there is other approach please do share
Tags for this Thread