HQL Error

[Jacky Luk]

 from bokss.util.Patient as p inner join bokss.util.Hospital as h where p.Hosptial_ID = h.Hospital_ID

org.hibernate.QueryException: outer or full join must be followed by path expression [ from bokss.util.Patient as p inner join bokss.util.Hospital as h where p.Hosptial_ID = h.Hospital_ID
 
   

]
	at org.hibernate.hql.classic.FromParser.token(FromParser.java:170)
	at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86)
	at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
	at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:28)
	at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:216)
	at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:185)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)

Could anyone please point out the bug of the HQL string?
Thanks
Jack

[Jacky Luk]

package bokss.util;
 


import java.util.HashSet;
import java.util.Set;

/**
 * Hospital generated by hbm2java
 */
public class Hospital  implements java.io.Serializable {


     private int hospitalId;
     private String hospitalName;
     private Set patients = new HashSet(0);

    public Hospital() {
    }

	
    public Hospital(int hospitalId) {
        this.hospitalId = hospitalId;
    }
    public Hospital(int hospitalId, String hospitalName, Set patients) {
       this.hospitalId = hospitalId;
       this.hospitalName = hospitalName;
       this.patients = patients;
    }
   
    public int getHospitalId() {
        return this.hospitalId;
    }
    
    public void setHospitalId(int hospitalId) {
        this.hospitalId = hospitalId;
    }
    public String getHospitalName() {
        return this.hospitalName;
    }
    
    public void setHospitalName(String hospitalName) {
        this.hospitalName = hospitalName;
    }
    public Set getPatients() {
        return this.patients;
    }
    
    public void setPatients(Set patients) {
        this.patients = patients;
    }
}

package bokss.util;
 



/**
 * Patient generated by hbm2java
 */
public class Patient  implements java.io.Serializable {


     private PatientId id;
     private Hospital hospital;
     private String patientFirstName;
     private String patientLastName;

    public Patient() {
    }

	
    public Patient(PatientId id, Hospital hospital) {
        this.id = id;
        this.hospital = hospital;
    }
    public Patient(PatientId id, Hospital hospital, String patientFirstName, String patientLastName) {
       this.id = id;
       this.hospital = hospital;
       this.patientFirstName = patientFirstName;
       this.patientLastName = patientLastName;
    }
   
    public PatientId getId() {
        return this.id;
    }
    
    public void setId(PatientId id) {
        this.id = id;
    }
    public Hospital getHospital() {
        return this.hospital;
    }
    
    public void setHospital(Hospital hospital) {
        this.hospital = hospital;
    }
    public String getPatientFirstName() {
        return this.patientFirstName;
    }
    
    public void setPatientFirstName(String patientFirstName) {
        this.patientFirstName = patientFirstName;
    }
    public String getPatientLastName() {
        return this.patientLastName;
    }
    
    public void setPatientLastName(String patientLastName) {
        this.patientLastName = patientLastName;
    }
}

package bokss.util;

/**
 * PatientId generated by hbm2java
 */
public class PatientId  implements java.io.Serializable {


     private int patientId;
     private int hospitalId;

    public PatientId() {
    }

    public PatientId(int patientId, int hospitalId) {
       this.patientId = patientId;
       this.hospitalId = hospitalId;
    }
   
    public int getPatientId() {
        return this.patientId;
    }
    
    public void setPatientId(int patientId) {
        this.patientId = patientId;
    }
    public int getHospitalId() {
        return this.hospitalId;
    }
    
    public void setHospitalId(int hospitalId) {
        this.hospitalId = hospitalId;
    }


   public boolean equals(Object other) {
         if ( (this == other ) ) return true;
		 if ( (other == null ) ) return false;
		 if ( !(other instanceof PatientId) ) return false;
		 PatientId castOther = ( PatientId ) other; 
         
		 return (this.getPatientId()==castOther.getPatientId())
 && (this.getHospitalId()==castOther.getHospitalId());
   }
   
   public int hashCode() {
         int result = 17;
         
         result = 37 * result + this.getPatientId();
         result = 37 * result + this.getHospitalId();
         return result;
   }   


}

HQL - want to get Patient_ID, Patient_Name, Hospital_ID and Hospital_Name
Could anyone give me a sample query? I need a left inner join
Thanks
Jack

[Bill Gorder]

From Patient

You will get a List<Patient> back just get your values off the object.

for (Patient patient : patients){
   patient.getId();
   patient.getPatientFirstName();
   patient.getPatientLastName();
   patient.getHospital().getId();
}

I don't understand the need for the composite key. PatientID should be enough. The hospitalid should be a foreign key defined on your Hospital field.