Hibernate criteria for OneToMany/ManyToOne relationship

Question

I have a OneToMany/ManyToOne relationship between two objects like:

public class Company {
    private Long compid;
    private String companyName;

    @OneToMany(mappedBy = "company", cascade = CascadeType.ALL)
    @LazyCollection(LazyCollectionOption.FALSE)
    private List<Employee> employees;
}

public class Employee {
    private Long empid;
    private String fstName;
    private String lstName;
    private String sal;

    @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
    @NotFound(action = NotFoundAction.IGNORE)
    @JoinColumn(name = "compid", nullable = true)
    private Company company;
}

I want to get the employees who have company.companyName like xxxx%. I tried something like:

Criteria criteria = session.createCriteria(Employee.class);
criteria.createAlias("company", "company");
criteria.add(Restrictions.like("company.companyName ", "xxxx%"));
return criteria.list();

But i get the error:

could not resolve property: company.companyName of: Employee

Where is the problem in this code?

score 1 · Answer 1 · answered Oct 15 '12 at 15:09

1

You should use criteria.createCriteria instead of criteria.createAlias

answered Oct 15 '12 at 15:09

Jeroen

979
1
7
16

score 1 · Answer 2 · answered Oct 15 '12 at 16:20

1

You have added a space like "company.companyName " in 3rd line of criteria. Is it typo? If not then it is the cause of the problem.

answered Oct 15 '12 at 16:20

RAS

8,100
16
64
86

score 1 · Accepted Answer · answered Oct 16 '12 at 06:17

1

I found the source of problem, it is a stupid error on my part, in my original code I put compny.companyName, I forgot an "a" in company, it works very well.

answered Oct 16 '12 at 06:17

user820688

719
2
13
27

Hibernate criteria for OneToMany/ManyToOne relationship

3 Answers3