2 Replies Latest reply: Oct 3, 2009 11:43 AM by billson chew RSS

Path expected for join!

Scale It Newbie

Why am i getting this exception:

javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [select p from dk.simpletime.model.entity.Project as p join Task as t where p.id = :projectid]

..when performing the query:
String queryStr = "select p from Project as p join Task as t where p.id = :projectid";
Query query = manager.createQuery(queryStr);
query.setParameter("projectid", projectId);
query.setMaxResults(max);
query.setFirstResult(index);
List tasks = query.getResultList();

Theres a @OneToMany relation from Project to Task.

Can any1 help?

Also what would be the query to select all Tasks given a Project?