Using JBoss 4.0.0 I'm trying to implement a finder method on an entity using a wildcard and ?>=? construct.
My EJB-QL is :
<![CDATA[Select Object(p) from PublishedContent p where p.publishedChannelOID = ?1 and 'visibleFrom' <=?2 and 'visibleUpTo' >=?2]]>
This fails with the following error during the deployment:
[STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">=" at
line 1, column 84. Was expecting one of:
Thanks in advance
By the spec, you are not allowed to compare literals to input parameters.