Q:

Convert SQL into HQL where clause

this should be easy, but my app throws constant error, and I'm new to Hibernate. 
I am trying to have simple HQL query in my web app using Hibernate. 
I want to execute the following SQL query:  
SELECT * FROM deal WHERE deal_status='A' OR WHERE deal_status='O';

HQL does not seem to work with or clause, here my current HQL statements in my web app:
FROM deal d where d.deal_status='O' or d.deal_status='A' order by d.id

Thanks for any Hibernate query help
Regards
Alex

A:

The HQL is based on the name of fields of your entity not of your class, and the Class Names
c.id - c is not defined

I strongly assume that the fields in Deal (Classname first letter upper case) are not deal_status but status, then the query must be like this. ( I skipped the c.id stuff, because I have no idea what you mean by this.) 
 SELECT d FROM Deal d WHERE d.status='O' or d.status=`A`

Notice the upper D from Deal
And this will only work if Deal.status is a String or something like that, but not if it is a Enum.  One way to handle an Enum is this:
Query query = session.createQuery(
    "SELECT d FROM Deal d WHERE d.status=:o or d.status=:a");
query.setParameter("a", MyEnum. A);
query.setParameter("o", MyEnum. O);

