Does EJBQLToSQL92Compiler in 3.2.5 fully support EJB-QL 2.1?

[cracru]

If so, it seems to barf on string comparisons other than the equality tests available in EJB-QL 2.0.

That is, <|>|<=|>= don't seem to be supported. Is that true, or have I screwed something up?

Thanks, Cc.

[timshaw]

Watch out for > and < ... make sure they're in CDATA sections (or use < and >)

I couldn't get the CDATA to work in ejb-jar.xml, but it works fine in jboss-ql sections in jbosscmp-jdbc.xml.

I also get compilation errors for the 'BETWEEN' keyword, but haven't followed that up.

G'luck

[cracru]

Thanks Tim, good point.

But I don't think that is the problem. I am using the xdoclet ejb.finder tag, and it appropriately wraps the query entry (ejb-ql element) as a CDATA section.

I am getting a parser error much like the one I would see from the EJB-QL 2.0 compiler used in 3.2.3. The parser sees a '>' but expects either:
'=' or '<>' or '('

I have verified that I am using the EJBQLToSQL92 compiler. Just not having any luck. I presumed from the wiki notes that EJBQLToSQL92 is fully EJB-QL 2.1 compliant.