2 Replies Latest reply on Feb 3, 2006 7:16 AM by fmagrini72

    EJB-QL with date comparison

    fmagrini72 Newbie

      Hi friends,
      In my app I have a CMP Entity Bean representing an exchange rate at a specific date.
      I created a select methos with following query:

      SELECT MAX(o.date) FROM ExchangeRate o WHERE o.listino.id=?2 AND o.currency.id=?2 AND o.date<=?3

      Third parameter is a java.util.Date type

      This method always returns a null value.
      I'm using mySQL as DBMS.
      Where am I wrong?
      Thanks a lot.
      Filippo