One of my beans finder methods is defined as follows:
/**
* @ejb.finder
* signature="java.util.Collection findByAccountId( java.util.Date startDate, java.util.Date endDate, java.lang.String accountId)"
* query="SELECT OBJECT(T) FROM Tx AS T WHERE T.accountId = ?3 AND T.timeStamp > ?1 AND T.timeStamp < ?2"
*/
This is working OK.
But when I rewrite the query above using BETWEEN jboss complains.
SELECT OBJECT(T) FROM Tx AS T WHERE T.accountId = ?3 AND T.timeStamp BETWEEN ?1 AND ?2
Isn't this query syntactically korrect?
Thanks
Andreas