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.
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.