POJO class and maaping document for the select query on multiple tables.

[Amit K Jain]

Hi,

I have to write a POJO class and the mapping document to retrieve the data from the select query. The select query has the constraints on multiple tables (around 6-7 tables).

I tried with putting the properties for all the fields used in the query and the corresponding properties in the POJO class.
However, I see the performance issue and it ends with Timeout.

Can someone please advise how to do it?