Simple finder SQL Error
I'm trying to add a custom finder to one of my Roo app controler and I get an error from the Hibernate parser when applying the following sql order:
SELECT * FROM Cdr o where o.creation_date > DATE_SUB ( now(), INTERVAL 2 MONTH )
the error is:
ERROR org.hibernate.hql.PARSER - line 1:72: unexpected token: 2
Is that only due to Hibernate or is it related to the way it is configured by Roo?
This appears a Hibernate issue. Roo just passes the SQL to Hibernate for execution. Have you tried EclipseLink? It is the reference implementation of JPA.