1 Reply Latest reply on Jan 8, 2006 1:21 PM by lafr

    Jboss dynamic sql ParseException

    sunonepp

      Hi,
      Whatever I try, I always get ParseException error.
      The sql after compilation is:

      SELECT OBJECT(s) FROM EJBBean AS s WHERE s.branch_id IN (?1, ?2, ?3, ?4) AND s.sDate >= ?5 AND s.sDate <= ?6

      The details is :
      Encountered "1" at line 1, column 74.
      Was expecting one of:
      "ABS" ...
      "COUNT" ...

      column 74 is just at ?1 position.

      But the sql is correct and I checked the object[] args which is also correct.
      Any one can help?
      Thanks