ejb-ql and >, < and like operators

[lukjel]

I have some entity bean with custom finder (findByNumber) which should give me a collection of entities which have number 'like' parameter. So I create finder and query is:
select distinct object(o) from testejb o where o.number like ?1
I created a JAR and deployment failed... ?1 is not proper...
Does it mean - I can't use parameters with like?
But I tried then (just for test):
select distinct object(o) from testejb o where o.number &gt; ?1
This also doesn't work.
What's going on? When I change to string literal ('blahblahblah') or I replace condition to '=' then it works but I need 'like'...
Have you some ideas?

TIA
Lukjel

[dsilcox69]

I posted a similar ? once before. My answer was the available boolean comparisons are based on the type of the variables being compared. The disallow greater than or less than operations on String types. I have not tried the like operator

[juhalindfors]

EJBQL does not allow arguments for LIKE queries, you will have to use JBossQL to achieve this.