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 implemented a search functionality that searches 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

There are multiple solution for this problem -

Either use customised query like



Another way is lazy loading of properties - which can lead you to n+1 problem if you don't use that properly.

http://www.hibernate.org/hib_docs/v3/re ... properties