Hibernate Community • View topic - why this query doesn't work ?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

why this query doesn't work ?

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

czy11421

Post subject: why this query doesn't work ?

Posted: Fri Oct 30, 2009 11:51 am

Newbie

Joined: Mon Jul 09, 2007 9:32 am
Posts: 17

Say I have a code below, I want to search project based on employee hired date

Code:

select p.id from Project p where p.empList.hireDate > '01/01/1970' and p.empList.hireDate < '01/01/1990'

Why this query doesn't work ? how to fix it ?

Thanks.

Code:

 class Project {
    Long id;
     List<Employee> empList;
}
class Employee{
    String name;
    Date hireDate;
}

Top

j040p3d20

Post subject: Re: why this query doesn't work ?

Posted: Fri Oct 30, 2009 11:53 am

Newbie

Joined: Fri Oct 30, 2009 11:41 am
Posts: 6

p.empList seems to be a list of employees, not a employee

Top

j040p3d20

Post subject: Re: why this query doesn't work ?

Posted: Fri Oct 30, 2009 12:08 pm

Newbie

Joined: Fri Oct 30, 2009 11:41 am
Posts: 6

maybe something like

Code:

select p.id from Project p inner join fetch p.empList as emp where emp.hireDate > '01/01/1970' and p.empList.hireDate < '01/01/1990'

Top

dubwai

Post subject: Re: why this query doesn't work ?

Posted: Fri Oct 30, 2009 1:04 pm

Newbie

Joined: Wed Mar 08, 2006 5:48 pm
Posts: 4

In what way doesn't it work?

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum