[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4688?page=c... ] Scott Marlow commented on HHH-4688: ----------------------------------- Looks like this is already tested by org.hibernate.test.annotations.manytomany.Group.permissions and unit tests: org.hibernate.test.annotations.manytomany.ManyToManyTest.testAssociationTableAndOrderByWithSet() + testAssociationTableAndOrderBy() -- 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-4688?page=c... ] Scott Marlow commented on HHH-4688: ----------------------------------- Adding @OrderBy to org.hibernate.test.annotations.collectionelement.Boy didn't seem to work in my testing. Should the following changes have worked? @ElementCollection @OrderBy /* THIS IS THE ONLY CHANGE */ @CollectionTable( name = "BoyFavoriteNumbers", joinColumns = @JoinColumn(name = "BoyId") ) @Column(name = "favoriteNumber", nullable = false) @OrderColumn(name = "nbr_index") public int[] getFavoriteNumbers() { return favoriteNumbers; } I didn't actually test for the result being ordered, I just visually verified that the sql is wrong and the returned values (after entity load) are wrong: select favoritenu0_.BoyId as BoyId0_, favoritenu0_.favoriteNumber as favorite2_0_, favoritenu0_.nbr_index as nbr3_0_ from BoyFavoriteNumbers favoritenu0_ where favoritenu0_.BoyId=? Hibernate: select favoritenu0_.BoyId as BoyId0_, favoritenu0_.favoriteNumber as favorite2_0_, favoritenu0_.nbr_index as nbr3_0_ from BoyFavoriteNumbers favoritenu0_ where favoritenu0_.BoyId=? -- 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-4688?page=c... ] Scott Marlow commented on HHH-4688: ----------------------------------- Ignore the previous two comments -- 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-4688?page=c... ] Scott Marlow commented on HHH-4688: ----------------------------------- As of yet, I haven't gotten @OrderBy to work with @ElementCollection. Perhaps its a user error but not sure yet. :) Once we have proven that @OrderBy works with @ElementCollection, maybe then we can raise an exception for mixing @OrderBy + @OrderColumn. -- 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-4688?page=c... ] Scott Marlow commented on HHH-4688: ----------------------------------- funny that you say that, just as I see the typo in my 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-4688?page=c... ] Scott Marlow updated HHH-4688: ------------------------------ Fix Version/s: 3.5 -- 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