1 Reply Latest reply on Jul 3, 2004 3:39 AM by Alexey Loubyansky

    ejb-ql with date problem

    satish kumar Newbie

      <method-param>java.lang.String</method-param>
      <method-param>java.util.Date</method-param>
      <method-param>java.util.Date</method-param>
      <method-param>java.lang.String</method-param>

      <![CDATA[SELECT OBJECT(a) FROM SAccountTranxBean AS a WHERE a.acctusername = ?1 AND a.time > ?2 AND a.time < ?3 AND a.type = ?4]]>

      is giving this error:

      Was expecting one of:
      "CONCAT" ...
      "SUBSTRING" ...
      "(" ...
      <STRING_LITERAL> ...
      <STRING_VALUED_PARAMETER> ...
      <STRING_VALUED_PATH> ...

      please anybody give me the solution for this "date" problem