0 Replies Latest reply on Jan 22, 2003 9:53 AM by Joerg-A. Stoehr

    EJB-QL-Problem when having java.sql.Date in the WHERE-clause

    Joerg-A. Stoehr Newbie

      I've the following finder method:


      <query-method>
      <method-name>findByUserId</method-name>
      <method-params>
      <method-param>java.sql.Date</method-param>
      </method-params>
      </query-method>
      <ejb-ql><![CDATA[SELECT OBJECT(ueb) FROM EventEBean AS ueb WHERE ueb.dateFrom > ?1]]></ejb-ql>


      When using the finder method it returns also those records which have a date before the dateFrom. The date giving to the query is ok (valid sql date)

      Any ideas?

      Joerg