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> ... )
qué versión de JBoss estás utilizando???