1 Reply Latest reply on May 19, 2003 5:20 PM by Adrian Brock

    jboss-ql woes

    jdijkmeijer Newbie


      I'm trying to get this to work for a few days now without success. I've got an entitybean Users, which defines a finder method: findbypassword.
      I first tried to place the query in the ejb-jar.xml and later in the standardjbosscmp-jdbc.xm file both unsuccesfull.
      The entry for standardjbosscmp-jdbc is:


      FROM users o
      WHERE o.name= ?1 AND o.password= ?2

      and the error I keep on getting is:

      Depends On Me: org.jboss.deployment.DeploymentException: Error compiling JBossQ
      L statement 'SELECT OBJECT(O)
      FROM users o
      WHERE o.name= ?1 AND o.password= ?2'; - nested throwable: (org.jb
      oss.ejb.plugins.cmp.ejbql.ParseException: Encountered "users" at line 2, column
      Was expecting one of:
      "IN" ...
      I tried many things, and as last this resource. Hopefully somebody can point me in the right direction..
      tia & regards,