I am new to hibernate and just recently i started looking in to the tutorial on it at http://docs.jboss.org/hibernate. So please bear with me.

I have a database tables Patient, Hospital and PatientHospital. My classes look somthing like this.

Patient { id (PK), firstname, lastname}
Hospital {id(PK), name, address}
PatientHospital{hospitalId (PK), patientId, recordNumber}

This is a many-to-many mapping. I am trying to map this on hibernate but have not been successful.

Do we need to create a hibernate mapping xml for PatientHospital as well?

Can anyone please help me out with the hibernate mapping? Thanks in advance.

Simplify and forget pointing to ids of other tables, point to references of other entities.
So turn:

into

Thanks SG but I dont understand what you are trying to say. My hospital and patient classes has a many to many relation and I needed to create that mapping table PatientHospital table. Can you explain it with a sample code.

My point is when I query for Patient it should bring me Patient and the hospital information and recordNumber. How can I create hibernate mapping for this?

As I said before I am very new to Hibernate. Just 2 days old.

Thanks.

SP