2 Replies Latest reply on Feb 17, 2003 5:31 PM by Guy Daniel

    Is ejb-ql broken for jboss 3.0.6?

    Guy Daniel Newbie

      Please excuse any ignorance - I've only been seriously on the J2EE and JBoss learning curve for the last 5 or so days, but

      I found that if I do this with a query :
      <ejb-ql><![CDATA[
      SELECT OBJECT(d)
      FROM database d
      WHERE d.name = ?1
      ]]></ejb-ql>

      it works!

      But if I do this:
      <ejb-ql><![CDATA[SELECT OBJECT(d) FROM database d WHERE d.name = ?1]]></ejb-ql>


      (all on one line)
      JBoss gives me errors on deployment:

      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException
      : Encountered "SELECT" at line 2, column 13.
      Was expecting one of:

      "AND" ...
      "OR" ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:46)