2 Replies Latest reply on Jan 5, 2004 2:26 AM by Juha Lindfors

    DeploymentException for JBossQL

    xunzhang Newbie

      I defined a very simple jbossql as:
      <jboss-ql><![CDATA[
      SELECT OBJECT(a)
      FROM account a
      WHERE a.accountProfileId = ?1
      ]]></jboss-ql>


      but got DeploymentException as:
      org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT OBJECT(a)
      FROM account a
      WHERE a.accountProfileId = ?1'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "account" at line 2, column 21.
      Was expecting one of:
      "IN" ...
      <ABSTRACT_SCHEMA> ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.(JDBCJBossQLQue
      ry.java:46)


      Any idea what is wrong with the JBossQL statement? Thanks in advance.