0 Replies Latest reply on Jul 4, 2003 3:13 PM by aamstutz

    EJB-QL, BETWEEN not working with jboss 3.2.1

    aamstutz Newbie

      One of my beans finder methods is defined as follows:

      /**
      * @ejb.finder
      * signature="java.util.Collection findByAccountId( java.util.Date startDate, java.util.Date endDate, java.lang.String accountId)"
      * query="SELECT OBJECT(T) FROM Tx AS T WHERE T.accountId = ?3 AND T.timeStamp > ?1 AND T.timeStamp < ?2"
      */

      This is working OK.
      But when I rewrite the query above using BETWEEN jboss complains.

      SELECT OBJECT(T) FROM Tx AS T WHERE T.accountId = ?3 AND T.timeStamp BETWEEN ?1 AND ?2

      Isn't this query syntactically korrect?

      Thanks

      Andreas