[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5056?page=c... ] Gail Badner resolved HHH-5056. ------------------------------ Assignee: Gail Badner Resolution: Rejected No response, no test case... -- 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-5056?page=c... ] Ahmed Ali Elsayed Ali Soliman edited comment on HHH-5056 at 2/21/11 1:52 AM: ----------------------------------------------------------------------------- this error still exists in hibernate 3.6.1 was (Author: ahmed1001): this error still exist in hibernate 3.6.1 -- 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-5056?page=c... ] Gail Badner commented on HHH-5056: ---------------------------------- Projections.property(...) is intended to work with a Java property, not a DB table column. If you are seeing this issue using a Java property, then please update a test in org.hibernate.test.criteria.CriteriaQueryTest to reproduce your issue. If you do this, then I will re-open this issue. Thanks, Gail -- 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-5056?page=c... ] Ahmed Ali Elsayed Ali Soliman commented on HHH-5056: ---------------------------------------------------- i made a debug in hibernate3.6.1 source code and i found the problem in class org.hibernate.loader.hql.QueryLoader in function getResultList protected List getResultList(List results, ResultTransformer resultTransformer) throws QueryException { // meant to handle dynamic instantiation queries... HolderInstantiator holderInstantiator = buildHolderInstantiator( resultTransformer ); if ( holderInstantiator.isRequired() ) { for ( int i = 0; i < results.size(); i++ ) { Object[] row = ( Object[] ) results.get( i ); Object result = holderInstantiator.instantiate(row); results.set( i, result ); } if ( !hasSelectNew() && resultTransformer != null ) { return resultTransformer.transformList(results); } else { return results; } } else { return results; } } in the for loop there is a function Object result = holderInstantiator.instantiate(row); this function return tha latest selected column then after finishing the for statement it go to resultTransformer.transformList(results); which check the uniqueness between the last columns that i add to result my opinion: you can solve it with one of the two ways 1- add a select distinct when you make the SQL statement from the first 2- remove the for loop then make resultTransformer.transformList(results); do the checks of distinct by public List transformList(List list) { List result = new ArrayList( list.size() ); Set distinct = new HashSet(); for ( int i = 0; i < list.size(); i++ ) { Object entity = list.get( i ); if ( distinct.add( new Identity( entity ) ) ) { result.add( entity ); } } if ( log.isDebugEnabled() ) { log.debug( "transformed: " + list.size() + " rows to: " + result.size() + " distinct results" ); } return result; } which you will change it to check the identity of the row array (Object[]) please this is an important bug (my project is a very large scale that working for 3 Ports in my country) i can't migrate from hibernate 3.3.2 to hibernate 3.6.1 because of this problem thanks. -- 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-5056?page=c... ] Ahmed Ali Elsayed Ali Soliman updated HHH-5056: ----------------------------------------------- Attachment: HibernateTest.rar Beans & Mappings.rar -- 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-5056?page=c... ] Gail Badner commented on HHH-5056: ---------------------------------- CriteriaSpecification.DISTINCT_ROOT_ENTITY is not intended to be used this way. Using a ResultTransformer is an inefficient way to get distinct results. You should should be grouping by your projected properties. You can see an example in org.hibernate.test.criteria.CriteriaQueryTest. -- 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