Hibernate如何使用hql创建内连接

Question

我有两个由onetomany映射的实体类：

@Entity
public class FilesInfo {
    @Id
    @GeneratedValue
    private Integer id;
    private String name;
    private String url;

    @OneToMany(cascade= CascadeType.ALL)
    @JoinColumn(name="fileId")
    private Collection<FilesShare> filesShared = new ArrayList<FilesShare>();

    public Collection<FilesShare> getFilesShared() {
        return filesShared;
    }

    public void setFilesShared(Collection<FilesShare> filesShared) {
        this.filesShared = filesShared;
    }
 //getters & setters   
}

另一个

@Entity
public class FilesShare {
    private Integer id;
    private int userId;
    private int owner;
}

结果和表格如下：

mysql> desc filesshare;
+--------+---------+------+-----+---------+----------------+
| Field  | Type    | Null | Key | Default | Extra          |
+--------+---------+------+-----+---------+----------------+
| id     | int(11) | NO   | PRI | NULL    | auto_increment |
| userId | int(11) | NO   |     | NULL    |                |
| owner  | int(11) | NO   |     | NULL    |                |
| fileId | int(11) | YES  | MUL | NULL    |                |
+--------+---------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> desc filesinfo;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| id    | int(11)      | NO   | PRI | NULL    | auto_increment |
| name  | varchar(255) | YES  |     | NULL    |                |
| url   | varchar(255) | YES  |     | NULL    |                |
+-------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

现在，我正在尝试执行内部联接并获取fileinfo类型的列表：

    @Override
        public List<FilesInfo> reqSharedFiles(FilesShare fs) {
            session=HibernateUtil.getSessionFactory().getCurrentSession();
            session.beginTransaction();
            List<FilesInfo> filesInfo = null;
            filesInfo=session.createQuery("select a.id, a.name, a.url from FilesInfo as a 
            inner join FilesShare as b on "+
            " a.id=b.fileId where b.userId= :userId and b.owner= :owner")
           .setInteger("userId",fs.getUserId()).setInteger("owner",fs.getOwner()).list();
            session.getTransaction().commit();
            return filesInfo;
        }

我得到了这个错误

Struts检测到一个未处理的异常：Messages:
org。冬眠hql。antlr。HqlBaseParser。恢复（Lantlr/RecognitionException；Lantlr/collections/impl/BitSet；）V文件：org/hibernate/hql/antlr/HqlBaseParser。java行号：1802应用程序。刀。上传daoimpl。ReqSharedFile（uploadaoimpl.java:79）

请告诉我哪里错了？

谢谢

Answer 1

这是您正在使用的hibernate和ANTLR JAR版本的问题。直到版本2.7.6，恢复方法才出现在ANTLR解析器类中？如果您使用的是ANTLR的早期版本，如2.7.2，那么您将遇到问题。

看这里