我实际上已经解决了,但感谢您的帮助。解决方案(下面详细介绍)是将多个@FilterDef批注包装在@FilterDef 的批注中。奇怪的是,我没有在任何地方或Hibernate文档中找到它,我看到了这篇文章在一个元素上具有相同类型的多个注释?并认为可能@FilterDefs存在并且确实存在。
@Entity@Table(name = "TESTCASE_NEW")@FilterDefs({ @FilterDef(name = "TESTCASE_NAME_FILTER", defaultCondition = "TESTCASENAME like :TESTCASENAME", parameters = { @ParamDef(name = "TESTCASENAME", type = "string") }), @FilterDef(name = "TEST_RUN_ID_FILTER", defaultCondition = "TESTRUNID in (:IDS)", parameters = { @ParamDef(name = "IDS", type = "int") })})public class TestCase implements Serializable{ private static final long serialVersionUID = 1L; @Id @Column(name = "TESTCASEID") private int ID; @Column(name = "TESTCASENAME") private String name;...}@Entitypublic class Category implements Serializable{ private static final long serialVersionUID = 1L; @Id @Column(name = "CATEGORYID") private int ID; @Column(name = "CATEGORYNAME") private String name; @oneToMany(fetch = FetchType.EAGER) @JoinColumn(name = "CATEGORYID") @OrderBy("TESTCASEID desc") @Filters({ @Filter(name = "TEST_RUN_ID_FILTER"), @Filter(name = "TESTCASE_NAME_FILTER") }) private Collection<TestCase> testCases;...}在DAO中,我只打开需要的
public List<Category> getCategories(List<Integer> testRunIDs, String category, String testCaseName) { Session session = getSession(); if (testRunIDs != null && testRunIDs.size() != 0) { session.enableFilter("TEST_RUN_ID_FILTER").setParameterList("IDS", testRunIDs); } if (testCaseName != null) { session.enableFilter("TESTCASE_NAME_FILTER").setParameter("TESTCASENAME", testCaseName); } Query query = session.createQuery("select distinct c from Category c inner join c.testCases tc"); List<Category> result = query.list(); return result; }


