org.hibernate.hql.ast.查询语法异常：在第1行第102列[来自com.strutsProject.dto.EventClub bTb

Question

org.hibernate.hql.ast.查询语法异常：意外令牌：在第1行附近，第102列[从com.strutsProject.dto.EventClub bTb作为C内连接com.strutsProject.dto.成就Tb作为A. EVENTNAME=C. EVENTNAME]

String hql=“FROM com.strutsProject.dto.EventClubTb as C internal join com.strutsProject.dto.Achievementstsb as A on A.EVENTNAME=C.EVENTNAME”；Query=session.createQuery（hql）；

@实体@Table（name=“clubevent”）

private static final long serialVersionUID=-8767337896773261247L; 
private Long id;
private String eventname;
private AchievementsTb actb;
@OneToOne
@JoinColumn(name = "actbeventname")`enter code here
public AchievementsTb getActb() {`enter code here`
    return actb;
}
public void setActb(AchievementsTb actb) {
    this.actb = actb;
}

public String getEventname() {
    return eventname;
}
public void setEventname(String eventname) {
    this.eventname = eventname;
}

@Entity@Table（name=“Achievents”）公共类AchievementsTb扩展了ViewAllGridList{

private static final long serialVersionUID=-8767337896773261247L; 
private Long id;
private String eventname; 
public String getEventname() {
    return eventname;
}
public void setEventname(String eventname) {
    this.eventname = eventname;
}
public String getDescription() {
    return description;
}
public void setDescription(String description) {
    this.description = description;
}

块引用

Answer 1

如果EventClubTb与AchievementsTb关联：

FROM com.strutsProject.dto.EventClubTb as C join C.achievementsTb as A

否则，可以使用经典的θ样式联接：

FROM com.strutsProject.dto.EventClubTb as C, com.strutsProject.dto.AchievementsTb as A
where A.EVENTNAME=C.EVENTNAME