">=" and "<=" not supported in jboss/EJB-QL?

[zorzella]

If I try to use "<=" at an EJB-QL query, I get an error message (below). AFAIK, this is supposed to work. Doesn't jboss support it? jboss 3.2.1

*********** ERROR ************
[...] Encountered "<=" at line 1, column 79.
Was expecting one of:
">" ...
"<" ...
"=" ...
"<>" ...
*********** ERROR ************

Zorzella

[juha]

IIRC, they're only supported by a limited set of datatypes in EJBQL. What types are you trying to compare, and have you tried using JBossQL instead? What does your query look like?

[zorzella]

I'm trying to compare "java.util.Date".

The query is:

SELECT Object(Ob) FROM Obs as Ob WHERE Ob.establishedAt < ?1

The getter is:

public abstract Date getEstablishedAt ();

Zorzella

[zorzella]

Note: the query, as posted, works. It's when I change <= for < that problems arise.

[juha]

Yes, you have to use JBossQL if you want to use the <= or >= operators with dates.