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> ...
)
