Problem with EJB-QL "LIKE" expression

[pluellen]

Does JBoss support EJB-QL "LIKE" expressions?

I have a simple query:

SELECT DISTINCT OBJECT(user) FROM User user WHERE user.userInfo.lastName LIKE ?1

When I try to deploy, I get this error:

2002-08-15 02:46:53,706 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.User.findLastNameLike] EJB-QL: SELECT DISTINCT OBJECT(user) FROM User user WHERE user.userInfo.lastName LIKE ?1
2002-08-15 02:46:53,716 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=User
org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at line 1, column 79.
Was expecting:
<STRING_LITERAL> ...

Any suggestions?

Thanks for the help.

[jmauri]

You are not able to pass input parameters to the LIKE. I tried to do the same but I read in the book "Enterpise Javabeans- O'reilly" that it's not possible, so you just can use the LIKE wiht a predefined String,

ex: SELECT .. FROM ... WHERE ... c.name LIKE '%_%'

% stands for any sequence of characters
_ stands for any single character

Hope it helps !

[pluellen]

It sure doesn't make sense to me that the EJB 2.0 specification doesn't include support for "LIKE" expressions with parameters.

Thanks for the quick, helpful response.

[bleupen]

i've encountered the same problem. it's not jboss - it's a shortcoming in standard ejb-ql (doesn't work in the R.I. either). isn't that the worst? sometimes i wonder if EJB-QL was put through any stringent use cases. the language is strong but has several shortcomings that render it almost useless.

you may want to look into using jboss-ql to get around these problems. it supports "like" with run-time arguments as well as dynamic ejb-ql.

b

[l.g.]

Hmm... I have a problem with dynamic-ql and "LIKE". See
http://jboss.org/forums/thread.jsp?forum=46&thread=19488