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

    Date in EJB-QL problem ?

    Eric Chow Apprentice

      Hello,

      I am using MySQL as the CMP default datasource.

      I defined a EJB-QL as following:

      <query-method>
      <method-name>findByPeriod</method-name>
      <method-params>
      <method-param>java.util.Date</method-param>
      <method-param>java.util.Date</method-param>
      </method-params>
      </query-method>

      <ejb-ql>
      <![CDATA[
      SELECT OBJECT(a) FROM DailyCounterEJB a
      WHERE a.date BETWEEN ?1 and ?2
      ]]>
      </ejb-ql>



      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,
      Eric