Announcement Announcement Module
Collapse
No announcement yet.
storedprocedure class+multiple resultsets+mapper class Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • storedprocedure class+multiple resultsets+mapper class

    hi,
    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

    thanks
    narayan
Working...
X