How to create query with jpa, getting exception

[Pramod Kumar]

Hi,

I am using the following query to access the db values in to the list

Query qury = em.createQuery("SELECT usr FROM User");
List<User> results = (List <User> qury.getResultList();

User is a bean mapped to user table.

I am getting the follwing exception

java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.IdentNode
\-[IDENT] IdentNode: 'usr ' {originalText=usr}

Thanks,

[Jaikiran Pai]

Query qury = em.createQuery("SELECT usr FROM User");

Change it to

Query qury = em.createQuery("SELECT usr FROM User [B]usr[/B]");

The alias usr wasn't defined

[Jaikiran Pai]

"ngpramod ngpramod"

Please check your private message, for a message from JavaRanch.