0 Replies Latest reply on Feb 19, 2003 8:48 AM by Michael

    Error compiling ejbql

    Michael Newbie

      Hello, I've seen this question once before but I can't
      resolve the issue based on the user's own answer. Can
      someone help?

      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "ACCOUNT_OBJVW" at line
      2, column 21.
      Was expecting one of:
      "IN" ...
      <ABSTRACT_SCHEMA> ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.(JDBCJBossQLQuery.java:46)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:63)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:203)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:511)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:416)

      I was under the impression that to use jboss-ql all you had to do in the ejb-jar.xml was an entry similar to the following, by just defining the query method and an empty
      <ejb-ql></ejb-ql>

      <query-method>
      <method-name>findByAccountCode</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>
      </ejb-ql>


      then in your jbosscmp-jdbc.xml you need to add just the following to use jboss-ql.

      <query-method>
      <method-name>findByAccountCode</method-name>
      <method-params>
      <method-param>java.lang.String
      </method-param>
      </method-params>
      </query-method>
      <jboss-ql><![CDATA[
      SELECT OBJECT(g)
      FROM ACCOUNT_OBJVW g
      WHERE g.account_code = ?1
      ]]></jboss-ql>


      Now, if I have the following under my entity description
      in my jbosscmp-jdbc.xml, why am I getting this error. Am I missing something?

      <ejb-name>cm_entity_acct_Acct</ejb-name>
      <table-name>ACCOUNT_OBJVW</table-name>

      -- Thanks