Hi Gurus,

I have two tables namely Usr and Newbie, I'd like to return a list of usr from newbie, this works:

select usr from Newbie order by rand()

this works, now I'd like to return only those Usrs that has a valid avatar, here is the query:

select usr from Newbie where usr.avatar is not null order by rand()

this does not work it always has this exception, any idea? thanks


Caused by: org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'usr.avatar' [select usr from org.ust.entities.Newbie where usr.avatar is not null order by rand()]


public class Usr {

private Long id;
private Photo avatar;

@Id @GeneratedValue
public Long getId() {
return id;
}

@OneToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name="photo_fk")

public Photo getAvatar() {
return avatar;
}

public void setAvatar(Photo avatar) {
this.avatar = avatar;
}
}

public class Newbie {

Long id;
private Usr usr;

@Id
@GeneratedValue
public Long getId() {
return id;
}

private void setId(Long id) {
this.id = id;
}

@OneToOne(fetch = FetchType.LAZY)
@JoinColumn(name="usr_id")
public Usr getUsr() {
return usr;
}

public void setUsr(Usr usr) {
this.usr = usr;
}

}

Try this query:

select n.usr from Newbie n where n.usr.avatar is not null order by rand()

this works, thanks. but what's so difference between the two:

select n.usr from Newbie n where n.usr.avatar is not null order by rand()
select usr from Newbie where usr.avatar is not null order by rand()

Difference is "usr.avatar". Hibernate does not recognize avatar in condition because that is a property of usr which you did not mention in from clause. Keep one thing in mind: condition clause only recognizes explicit declaration.