namedQuery error : node to traverse cannot be null!

[Celinio Fernandes]

hi,
I am trying to execute a namedQuery from a JUnit test class :

public class PeopleTest extends TestCase {
 
  private EntityManagerFactory emFactory;
  private EntityManager em;   
    
  public void testAge() {
   Query q = em.createQuery("findByCountry");    
   q.setParameter("theCountry", "Japan");
   List<People> resultatsNamedQuery  = q.getResultList();
      
   for (People p : resultatsNamedQuery) {
         System.out.println(p.getAge());
    }    
    ...
  }
}

Here is the entity bean code :

@Entity
@NamedQuery(name="findByCountry", 
query="select p from People p where p.country = :theCountry")
public class People implements Serializable {
  ...
}

I have this error :

java.lang.IllegalArgumentException: node to traverse cannot be null!
at org.hibernate.hql.ast.util.NodeTraverser.traverseDepthFirst(NodeTraverser.java:31)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:254)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)

It works well if i call this named query from a session bean.
Is this a problem of persistence context ?
Please enlighten me. Thanks.
[ September 02, 2008: Message edited by: Celinio Fernandes ]

[Sergio Tridente]

@NamedQuery(name="findByCountry", 
query="select c from People p where p.country = :theCountry")

Shouldn't it be "select p from People p where p.country = :theCountry"? Or "select c from Client c where c.country = :theCountry"?

Could you post both entities' (Person and Client) complete definition?
[ September 02, 2008: Message edited by: Sergio Tridente ]

[Celinio Fernandes]

hey Sergio, good point, I made a wrong copy-paste.
I changed it in the initial post. There is only one entity : People.
Do you know where the problem is ?

[krishna bulusu]

Hey,

You should following method in EntityManager for named queries:

public Query createNamedQuery(String
name);

Hope this helps!!

[Celinio Fernandes]

thanks, that was it :
createNamedQuery(...)
A simple mistake, thanks a lot again !

[Hooman Peiro Sajjad]

Celinio Fernandes wrote:thanks, that was it :
createNamedQuery(...)
A simple mistake, thanks a lot again !

Hey guys, it's em.getNamedQuery(aString), isn't it?