Query Doesnt get executed

newbie181 · **Joined:** Thu Jun 05, 2008 12:53 pm **Posts:** 5

Hi,

I am trying to execute a simple query

select a from order_item a where a.status=2

I get the following exception:
net.sf.hibernate.QueryException: in expected: a [select a from order_item a where a.status=2 ]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:102)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:142)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1572)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at

How can I resolve the same
Thanks.

sjhyam · **Joined:** Fri Jun 01, 2007 12:41 pm **Posts:** 121

http://www.laliluna.de/222.html

newbie181 · **Joined:** Thu Jun 05, 2008 12:53 pm **Posts:** 5

I checked that earlier, but in my case there was no spelling mistake. I checked the table name and there is no difference in the spelling.

Cameron McKenzie · **Posted:** Sat Jun 07, 2008 7:32 am

What is the data type of status?

newbie181 · **Joined:** Thu Jun 05, 2008 12:53 pm **Posts:** 5

The data type is Integer.

zephyr · **Joined:** Tue Apr 29, 2008 1:42 pm **Posts:** 12

Did it work when directly querying the database?

-Sweta

newbie181 · **Joined:** Thu Jun 05, 2008 12:53 pm **Posts:** 5

Yes it works when I query the database directly.

--Joe