0 Replies Latest reply on Dec 17, 2002 4:11 PM by Kausik Dey

    ejbsql Error

    Kausik Dey Newbie

      Hi,
      While deploying entity bean I am getting the following error.

      Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "cgs_tecsys_userlink" at line 4, column 30.
      Was expecting one of:
      "IN" ...
      <ABSTRACT_SCHEMA> ...

      at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJ

      Below is the code in ejb-jar.xml


      <query-method>
      <method-name>finduserLink</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>
      <![CDATA[
      SELECT OBJECT(g)
      FROM cgs_tecsys_userlink AS g, IN (g.cgs_tecsys_user), IN (g.cgs_tecsys_link)
      WHERE g.user_id = ?1
      ]]>
      </ejb-ql>


      Any help or Comments highly appreciated...
      KD