Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D has one to many relationship with E. Beam class of A contains array of Class B,C, and D Bean class of D contains array of Class E
Suppose my query is Select * from A a, B b , C c , D d, E e where a.id = b.id, a.id = c.id, a.id = d.id, a.id = e.id.
Suppose result contains One record for A, Two records for B , three records for C , Four records for D and two records for E.
Then how should I populate my bean classes from resultset without using hibernate, so that there will be no duplicate data present? Since There is a repetition of data hence I am not able to populate bean classes properly.Please suggest easy and convinient solution to this problem.