ParseException : expecting one of <DATETIME_VALUED_PARAMETER

[catherinelo]

I am using JBoss 4.0.1sp1 with xDoclet.
I defined the following finder statement in UsageSession Entity Bean where timeStarted is DATETIME in mySQL, and I need to get the latest timeStarted from database (mySQL):

* @ejb.finder view-type="local" description="findSessionByStationAndCard"
* signature="com.abc.interfaces.UsageSessionLocal findSessionByStationAndCard(com.abc.interfaces.StationLocal station, com.abc.interfaces.CardLocal card)"
* query="SELECT distinct object(u) FROM UsageSession u WHERE u.station = ?1 AND u.card = ?2 AND u.timeStarted=(SELECT MAX(u2.timeStarted) FROM UsageSession u2 WHERE u2.station=?1 AND u2.card=?2)"

But when I deploy it, I got such exception :
INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "(
" at line 1, column 102.
Was expecting one of:
<DATETIME_VALUED_PARAMETER> ...
<DATETIME_VALUED_PATH> ...

How can I resolve this problem?

Thanks in advance.

[ohadraz]

Did you find the solution yet?

[lippke]

Did you find a solution?
I have a similar problem. It seams to occur only with dates?!

[ohadraz]

This has workied for me. I had to separate java.sql.Date and java.sql.Time, and the following works for mr.

<query>
 <query-method>
 <method-name>findByTimeInterval</method-name>
 <method-params>
 <method-param>java.sql.Time</method-param>
 <method-param>java.sql.Time</method-param>
 </method-params>
 </query-method>
 <ejb-ql>
 <![CDATA[
 SELECT OBJECT(time)
 FROM TimeEJB AS time
 WHERE time.time1 > ?1
 AND nonWorkingDay.endTime < ?2
 ]]>
 </ejb-ql>
</query>