2 Replies Latest reply on Mar 22, 2004 11:23 AM by Leandro Terra Melo

    Problems deploy EJB QL

    Leandro Terra Melo Newbie

      sorry, i'm a little mad at the moment, you know....
      I simply don't understand what is wrong with the following syntax.

      SELECT OBJECT(c) FROM MyStoreItem AS c WHERE c.price = 0

      I keep getting a error when trying to deploy the bean!
      Can anyone help me? The log follows at the botton
      Thanks a lot,

      2004-03-19 19:40:53,390 ERROR [org.jboss.ejb.EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(c) FROM MyStoreItem AS c WHERE c.price = 0'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "MyStoreItem" at line 1, column 23.
      Was expecting one of:
      "IN" ...
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:50)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:59)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:212)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
      at sun.re