Simple finder SQL Error

[fraveau]

Hi,

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?

Thanks

[Alan Stewart]

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.
Alan