[
https://jira.jboss.org/jira/browse/JBSEAM-3032?page=com.atlassian.jira.pl...
]
Dan Allen commented on JBSEAM-3032:
-----------------------------------
This issue depends on a Hibernate issue.
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2266
Hibernate can support either of the following:
select count(u) from User u
select count(*) from User u
as long as the primary key is a single field. However, when the primary key is a composite
key, then Hibernate generates invalid SQL for the following:
select count(v) from Vehicle v
select count((vehicle0_.registration, vehicle0_.state)) as col_0_0_ from Vehicle
vehicle0_
So we can't move forward until Hibernate is fixed and upgrade in JBoss AS 5. We will
have to detect the Hibernate version too because we don't want to break things.
count query used by Query is not compliant JPQL
-----------------------------------------------
Key: JBSEAM-3032
URL:
https://jira.jboss.org/jira/browse/JBSEAM-3032
Project: Seam
Issue Type: Bug
Components: Framework
Affects Versions: 2.0.2.GA, 2.1.0.A1
Reporter: Dan Allen
Assignee: Dan Allen
Fix For: The future
Attachments: JBSEAM-3032-branch20-v1.txt, JBSEAM-3032-trunk-v1.txt
Original Estimate: 1 hour
Remaining Estimate: 1 hour
The count query used by getCountEjbQl() in Query 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:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira