Setting ResultSet to a single Object

sahu_manas · **Joined:** Tue Jul 25, 2006 8:50 am **Posts:** 8

I am trying to retrieve some fields from multiple tables(i.e. multiple objects) and want to set that ResultSet into a single object by using hibernate.
e.g.
(select a.x,b.y from AVO a,BVO b where a.z = b.z and a.m = 12;)

i want to get a.x,b.y in form of an object.

How can i do it?????

scarface · **Joined:** Sun Jun 04, 2006 1:58 am **Posts:** 136

create a new DTO class and do

select new MyDto( a.x,b.y) from AVO a,BVO b where a.z = b.z and a.m = 12;

obiviously MyDto should have that constructor

sahu_manas · **Joined:** Tue Jul 25, 2006 8:50 am **Posts:** 8

Hi scarface,

Thanx a lot.This is working fine.....