Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HQL Error

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator




Could anyone please point out the bug of the HQL string?
Thanks
Jack
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator






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
Bartender
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From Patient

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



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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic