HQL query with OneToMany

[Kamil Kuchta]

I have problem to create some HQL query.
This is my object model. Hotel has list of Image.

@Entity
public class Hotel {
	private Long id;
	private List<Image> images;

    @OneToMany(cascade=CascadeType.ALL)
    @JoinColumn(name="hotel_id")
	public List<Image> getImages() {
		return images;
	}
	public void setImages(List<Image> images) {
		this.images = images;
	}
	// id settet getter
}

@Entity
public class Image {
	private Long id;
	private String name;
	
	@Column
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	// id settet getter
}

Standard SQL in this case is easy:
SELECT name FROM image WHERE image.hotel_id = 10;
But how to create HQL?
SELECT name FROM Image i WHERE i.hotel.id = 10; --failed, I know... no reference to hotel form image SELECT name FROM Image i, Hotel h WHERE h.images.id = i.id AND h.id = 10; --failed, illegal attempt to dereference collection SELECT name FROM Image i, Hotel h WHERE h.id = 10; --failed, No data type for node: org.hibernate.hql.ast.tree.IdentNode

[Vijitha Kumara]

Isn't the relationship bi-directional? You have to reference Hotel from the Image as Many side of One-To-Many will be the owner of the relationship. HQL is bit different form SQL. Are you trying to execute a native SQL or HQL?