1 Reply Latest reply on Oct 19, 2004 6:02 PM by Walter

    Can I use COUNT()???

    Daniel Ferreira Newbie

      Hi all,

      I'm tring to use count and get the total number of row in my table but I'm getting this error? Please, somebody help me.

      thanks in advance

      Daniel.


      18:19:30,081 ERROR [EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT COUNT(a) FROM ProsahPaciente as a'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "COUNT" at line 1, column 8.
      Was expecting one of:
       "DISTINCT" ...
       "OBJECT" ...
       <NUMERIC_VALUED_PATH> ...
       <STRING_VALUED_PATH> ...
       <DATETIME_VALUED_PATH> ...
       <BOOLEAN_VALUED_PATH> ...
       <ENTITY_VALUED_PATH> ...
       <VALUE_CLASS_VALUED_PATH> ...
       )