在Hibernate 4 中获取错误意外令牌

Question

嗨，我使用Spring mvc 3 和Hibernate 4 开发一个 Web 应用程序。我正在为所有配置使用注释。

当我尝试选择一个实体时，出现错误：

DaoException: unexpected token: MEMBER near line 1, column 37 [from clanwar.model.ClanMember where MEMBER = :member]
at clanwar.dao.impl.ClanMemberDao.findByPlayerId(ClanMemberDao.java:71)

如果我用< code >进行查询。create SQL query() hibernate返回一个< code>ClanMember实体的< code>Object[]实例。

道中的方法:

    @Repository
    @Transactional

    ...

    @Override
    public ClanMember findByPlayerId(int id) throws DaoException {

        ClanMember foundMember;

        try {
            foundMember = (ClanMember) getSession()
                .createQuery("from ClanMember where MEMBER = :member")
                .setParameter("member", id)
                .uniqueResult();
        } catch (Exception e) {
            throw new DaoException(e.getMessage());
        }

        return foundMember;
    }

    ...

实体：

@Entity
@Table(name = "CLAN_MEMBERS")
public class ClanMember implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @ManyToOne
    @JoinColumn(name = "CLAN")
    private Clan clan;

    @Id
    @ManyToOne
    @JoinColumn(name = "MEMBER")
    private Player member;

    @ManyToOne
    @JoinColumn(name = "ROLE")
    private ClanRole role;

    public ClanMember() {}

    // Setters and getters

}

表 CLAN_MEMBERS：

+--------+---------+------+-----+---------+-------+
| Field  | Type    | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| CLAN   | int(11) | NO   | PRI | NULL    |       |
| MEMBER | int(11) | NO   | PRI | NULL    |       |
| ROLE   | int(11) | NO   |     | 1       |       |
+--------+---------+------+-----+---------+-------+

我做错了什么？先谢谢你。

Answer 1

您的查询应如下所示：

from ClanMember where member = :member

因此，获取成员的代码应如下所示：

foundMember = (ClanMember) getSession()
                .createQuery("from ClanMember where member = :member")
                .setParameter("member", id)
                .uniqueResult();

还要注意，您传递的< code>id应该是< code>Player类的一个实例。

Answer 2

成员是 HQL 中的保留字。通过添加表别名来转义它。

此外，由于< code>member属于< code>Player类型，因此当< code>where子句包含< code>member时，您需要提供一个< code>Player类型的参数。或者，如果您想提供ID，您需要显式搜索< code>id:

所以要么：

 foundMember = (ClanMember) getSession()
            .createQuery("from ClanMember c where c.member = :member")
            .setParameter("member", someInstanceOfPlayer);
            .uniqueResult();

或

 foundMember = (ClanMember) getSession()
            .createQuery("from ClanMember c where c.member = :member")
            .setParameter("member", idOfAPlayer);
            .uniqueResult();