Hi newbie to hibernate and just wanted to get your thoughts on the following:

I have a POJO called Client that contains all information about a client ie.: firstname, surname, dob... etc.

I implement a search functionality that search for clients by Surname but when I view the sql generated by hibernate i noticed that hibernate fetches all fields defined in the Client POJO. ie.: SELECT FirstName, Surname, DOB, Occupation, Income FROM Client

However for performance i would prefer to restrict the output to SELECT FirstName, Surname FROM Client.

What would be the best way to achieve this in hibernate, i mean theres no point returning/fetching all attributes from the Client table when im only using the firstname and surname to display the found clients.

Thanks

Just guessing here, but doesn't:



do the right thing?

Another way could be to use lazy property fetching.

But I don't think it's necessary to exclude some columns for performance reasons.