2 Replies Latest reply on Apr 29, 2003 1:11 AM by Adrian Richter

    Problems w/ EJB QL and java.sql.Timestamp

    David Durst Newbie

      I am currently experiencing a issue where I am receiving nothing back from a ejb-ql query. Logically I believe it should accomplish the following:

      Return to me all Journal Lines attached to a specific account between
      a start and end time.

      Here is the query itself:

      <query>
      <description></description>
      <query-method>
      <method-name>findAccountHistory</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.sql.Timestamp</method-param>
      <method-param>java.sql.Timestamp</method-param>
      </method-params>
      </query-method>
      <result-type-mapping>Local</result-type-mapping>
      <ejb-ql>
      <![CDATA[SELECT OBJECT(line) From JournalLineEJB AS line WHERE line.account.accountID = ?1 AND
      line.journalEntry.journalEntryTimeStamp > ?2 AND
      line.journalEntry.journalEntryTimeStamp < ?3]]>
      </ejb-ql>
      </query>


      Can anyone see why this query might be giving me an issue?