我试图用冬眠标准给加入条款增加附加条件。 事实上,有些方法允许这样做:
createCriteria(String associationPath, String alias, int joinType, Criterion withClause)
和
createAlias(String associationPath, String alias, int joinType, Criterion withClause)
They work properly with one-to-one 和one-to-many relations. But when I m trying to use them with entities having many-to-many relations, I m getting following error:
Caused by: org.postgresql.util.PSQLException: No value specified for parameter 1.
Can anybody help me? The rude example is below:
@Entity
public class Person {
@Id
@GeneratedValue
private Long id;
@ManyToMany
private Set<PersonName> names;
}
public class PersonName {
@Id
@GeneratedValue
private Long id;
@Column
private String name;
}
public class PersonDao extends HibernateDaoSupport {
public List<Person> findByName() {
Criteria criteria = getSession().createCriteria(Person.class, "p");
criteria.createCriteria("p.names", "names", JoinType.INNER_JOIN, Restrictions.eq("name", "John"));
return criteria.list();
}
}
正在生成查询
select this_.id as y0_ from person this_
inner join debtor_info this_1_ on this_.id=this_1_.id
left outer join person_person_name personname3_ on this_.id=personname3_.person_id 和( name1_.name=? )
left outer join person_name name1_ on personname3_.person_name_id=name1_.id 和( name1_.name=? )
如你所见,加入条件增加两次,明显不正确
提前感谢。
BTW Im 使用后gresql 9, Hhibernate 3.6.3