Hello

I have a two objects Doctor and Contact to doctor.
Doctor can have more than one Contact.


i have select like this

select doctor,contactdoctor from Doctor doctor join doctor.contactdoctorSet contactdoctor where doctor.specialization in (:specialization)

if doctor have two contacts it returns two rows like this :
[doctor],[contact1]
[doctor],[contact2]

is any way how it can return collection of contacts as one record
[doctor],[contactSet]

The problem is also with doctor without contact. There r not in final list.

I need it because it is much more faster that get all doctor objects and than ask for collection Hibernate.initialize(doctor.contactdoctorSet )

Can any1 help me ? plz

You cannot get a collection back in that way. If doctor.getContactSet isn't good enough for you, the best you can do is Object[] { doctor, contact }.

Your observation that getting the doctor/contact pair is faster than getting the doctor then getting the set of contacts is not correct. When you get the doctor/contact pair, you are also getting the set of contacts in the doctor entity (or at least, you're getting the proxied reference to the set). If your issue is the n+1 selects that would result from the simple "from Doctor" case, use "join fetch":This will eagerly fetch all the contacts.