4 Replies Latest reply on Aug 15, 2002 3:15 PM by L.G.

    Problem with EJB-QL "LIKE" expression

    Pete Luellen Newbie

      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.