I know Seam 2 is probably on its way out with seam 3 around the corner, but I thought I should still mention this.
I used the word 'from' as a column name and it immediately caused errors - not surprising really, though MySql didn't reject it.
So I changed it to fromDate, and everything was fine until I had enough records for paging to kick in and I got errors again:
Caused by: org.hibernate.hql.ast.QuerySyntaxException: expecting CLOSE, found 'from' near line 1, column 19 [select count(duty from aero.stratus.qgt.entity.Duty duty order by) from aero.stratus.qgt.entity.Duty duty]
I was also sorting by the same column and the error only occurred if the table was sorted by that column.
I am guessing this is a bug in EntityQuery.
Changing the column name to dateFrom has stopped the errors.
I am using Seam 2.2.0.GA
All EJBQL is converted to SQL statements and in SQL as in EJBQL (or HQL) from
is a keyword and you should avoid use keywords as column name.