1 Reply Latest reply on Jul 21, 2010 10:13 AM by Herberson Silva

    Keyword 'from' in a column name

    Timothy Whitehead Newbie

      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