hql - Java-Tapestry, join between two entities -


i have 3 tables in database: room, roomtype , booking.

room entity:

@id @generatedvalue(strategy = generationtype.identity) private long roomid;  private long doorcode;  @manytoone(optional = false, fetch = fetchtype.lazy) @joincolumn(name = "roomtypeid") private roomtype roomtype; 

roomtype entity:

@id @generatedvalue(strategy = generationtype.identity) private long roomtypeid;  private string name;  private string photo; 

booking entity:

@id @generatedvalue(strategy = generationtype.identity) private long bookingid;  @manytoone(optional = false, fetch = fetchtype.lazy) @joincolumn(name = "roomid") private room room;  private date fechar; 

i want make join between room , booking see rooms between dates when try make join, can between room , roomtype entities.

"select u room h left join h.roomtype" 

how join room booking?


Comments