1 Reply Latest reply on Apr 3, 2003 4:42 AM by Ken Helmes

    simple query error (bug?)

    Ken Helmes Newbie

      Hello,

      jboss-3.0.6_tomcat-4.1.18 on Windows

      Entity beans deploy without query but when adding a very simple "findByUserId" query following error occurs:

      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "IdentityMeta" at line 2, column 21.
      Was expecting one of:
      "IN" ...
      <ABSTRACT_SCHEMA> ...
      )

      the ejb-jar.xml:

      <query-method>
      <method-name>findByUserId</method-name>
      <method-params><method-param>java.lang.String</method-param></method-params>
      </query-method>
      <ejb-ql><![CDATA[ SELECT OBJECT(o) FROM IdentityMeta o
      WHERE o.userId = ?1
      ]]>
      </ejb-ql>


      the table is defined as IdentityMeta in jbosscmp-jdbc.xml

      Any ideas regarding where to search for this?

      Ken