Problems w/ EJB QL and java.sql.Timestamp

[ddurst1]

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?

[ddurst1]

I don't know if this is what is causing my issue or not,
but I have recently found a post on Java Developer Connection
that claims that CMP 2.0 doesnt support '>','<','=>','<=' on java.sql.Timestamp?

Can anyone verify this???

[arichter]

I can confirm there is no support for java.util.Date and therefore I would assume that java.util.Time would also not be supported. This is a severe oversite by the standards community and I hope they rectify this in future releases.

Adrian Richter