EJB-QL ParseException

[daryoush]

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 :

<ejb-ql>
<![CDATA[Select Object(p) from PublishedContent p where p.publishedChannelOID = ?1 and 'visibleFrom' <=?2 and 'visibleUpTo' >=?2]]>
</ejb-ql>


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

[aloubyansky]

By the spec, you are not allowed to compare literals to input parameters.