Announcement Announcement Module
Collapse
No announcement yet.
Simple finder SQL Error Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Simple finder SQL Error

    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

  • #2
    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

    Comment

    Working...
    X