[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2480?page=c... ] Steve Ebersole updated HHH-2480: -------------------------------- Affects Version/s: antlr-rework -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2480?page=c... ] wesley wu commented on HHH-2480: -------------------------------- I need this improvement especially when I use EntityManager to do query rather than Criteria or HQL. In fact, the HibernateEntityManager provides no way to force returning distinct top level pojo objects when there is an One-to-Many left outer join clause. One of the workaround I learned from http://www.hibernate.org/117.html#A12 is to add a DISTINCT keyword after SELECT. "Yes, in other cases an HQL distinct will translate straight into a SQL DISTINCT. Not in this case: you can not filter out duplicates at the SQL level, the very nature of a product/join forbids this - you want the duplicates or you don't get all the data you need." But in two cases, this workaround failed to work: 1. When the resultset should be paginated, I.E., setFirstResult() and setMaxResults() were used. 2. When the resultset has LONGVAR field, like ntext, image in SQLServer. Database will generate a error like : ntext datatype could not be distinct compared." And these two case should happen pretty frequently. The conclusion : despite of using "setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)" in Hibernate HQL queries and criteried queries, HibernateEntityManager has no way to eliminate the duplication of top level pojo objects when there is an One-to-Many left outer join clause. We need this improvments indeed. Thanks in advance. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira