EJB-QL - Problem with LIKE Statement

Hi,

i use Jboss 3.2.1 and eclipse with lomboz. i tried to add the following quer
y to my bean:

* @ejb.finder
*    query="SELECT OBJECT(a) FROM minfo a where a.filename LIKE ?1"
*    signature="java.util.Collection findByFilename(java.lang.String filenam
e)"


and get this error:

Depends On Me: org.jboss.deployment.DeploymentException: Error compiling EJB
-QL statement 'SELECT OBJECT(a) FROM minfo a where a.filename LIKE ?1'; - ne
sted th
rowable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at
 lin
e 1, column 53.
Was expecting:
<STRING_LITERAL> ...
)]

I dont understand that, because i have a type string for this.

thanks a lot!

Bonkers wrote:
> * @ejb.finder
>  *    query="SELECT OBJECT(a) FROM minfo a where a.filename LIKE ?1"
>  *    signature="java.util.Collection findByFilename(java.lang.String file
name)"
> and get this error:
>  Depends On Me: org.jboss.deployment.DeploymentException: Error compiling 
EJB-QL statement 'SELECT OBJECT(a) FROM minfo a where a.filename LIKE ?1'; -
 nested th
> rowable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" 
at lin
> e 1, column 53.
> Was expecting:
>     <STRING_LITERAL> ...
>     )]

You need to use JBossQL for like.

-marek

thank U
is there no way to use ejb-ql with the same result?

Bonkers wrote:

> thank U
> is there no way to use ejb-ql with the same result?

No.

-marek