[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-3032) count query used by EntityHome is not compliant JPQL

[Dan Allen (JIRA)]

count query used by EntityHome is not compliant JPQL
----------------------------------------------------

                 Key: JBSEAM-3032
                 URL: http://jira.jboss.com/jira/browse/JBSEAM-3032
             Project: Seam
          Issue Type: Bug
          Components: Core
    Affects Versions: 2.1.0.A1, 2.0.2.GA
            Reporter: Dan Allen
         Assigned To: Dan Allen
             Fix For: 2.0.2.SP1, 2.1.0.BETA1


The count query used by getCountEjbQl() in EntityHome is not compliant JPQL. It should be:

select count(Entity) from Entity entity

instead of

select count(*) from Entity entity

Where "entity" is the class name of the entity (for instance, Person). You can test this by using TopLink or OpenJPA.

All we need to do is replace the * with the name of the Entity. (We don't even need to fish for the alias used in the query).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira