selecting certain fields of a table into an object

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

I want to select only some fields of a table into an object setting other fields of the table to nulls.i want to get it done by the hibernate itself.
e.g.
select fullName,designation,termAcceptance from UserProfileVO where userId=15

i want to get only fullName,designation & termAcceptance of UserProfileVO and all other fields should be null.

how can i do that???

bkmr_77 · **Joined:** Tue Apr 25, 2006 12:04 pm **Posts:** 260

Create a constructor taking required fields.

Code:

public UserProfileVO( String fullName, String designation, boolean termAcceptance ){
   this.fullName = fullName;
   this.designation = designation;
   this.termAcceptance = termAcceptance;
}

then execute following query

Code:

select new UserProfileVO( fullName, designation, termAcceptance ) from UserProfileVO where userId='15' 

it should give you object with only the required fields populated. If i am correct, thi should be available from hibernate version 3.1

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

Hi

Thanx a lot. This is working fine...