3 Replies Latest reply on Aug 6, 2002 2:41 PM by Dain Sundstrom

    Date in EJB-QL problem ?

    Eric Chow Apprentice


      I am using MySQL as the CMP default datasource.

      I defined a EJB-QL as following:


      SELECT OBJECT(a) FROM DailyCounterEJB a
      WHERE a.date BETWEEN ?1 and ?2

      But it raised exception when deployment.

      Would you please to teach me how can define EJB-QL with DATE as the parameters for confitions.

      Best regards,