Duplicate alias issue returned in 3.0.5, 3.0.4 and possibly others ------------------------------------------------------------------ Key: HHH-872 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-872 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.0.4, 3.0.5 Environment: Hibernate 3.0.5, Oracle 9.x Reporter: Eugene Shagenov This problem has been fixed in 3.0Beta4. However, it has returned in lated release versions - at least in 3.0.5 and 3.0.4. The reason I believe this is a bug and it has returned is that when I make no changes to any of my code (Java or XML), but simply change jars from 3.0.5 to 3.0-beta4 jars, the problem is resolved. To reiterate from the previous issue the problem is as follows: When performing more than one join in a query using Criteria class, the aliases generated for the columns may turn out to be identical. Here is a sample generated query and error following - select this_.ART_ID as ART1_2_, this_.CREATE_SITE_ID as CREATE2_1_2_, this_.SITE_ID as SITE3_1_2_, this_.LANGUAGE_ID as LANGUAGE4_1_2_, this_.DESCRIPTION as DESCRIPT5_1_2_, this_.PUBLISH_DATE as PUBLISH6_1_2_, this_.HEADLINE as HEADLINE1_2_, this_.EYEBROW as EYEBROW1_2_, this_.TEAMSITE_OBJECT_ID as TEAMSITE9_1_2_, this_.SUB_HEAD as SUB10_1_2_, this_.TEASER as TEASER1_2_, this_.CREATE_DATE as CREATE12_1_2_, this_.BYLINE as BYLINE1_2_, this_.EMBARGO_DATE as EMBARGO14_1_2_, this_.LAST_MODIFIED as LAST15_1_2_, this_.BROWSER_TITLE as BROWSER16_1_2_, this_.FIRSTPAGE as FIRSTPAGE1_2_, this_.CD_ARTID as CD18_1_2_, this_.CD_DOCID as CD19_1_2_, this_.TOPIC as TOPIC1_2_, this_.KEYWORDS as KEYWORDS1_2_, this_.EXTERNAL_REF as EXTERNAL22_1_2_, this_.CREATORBIO as CREATORBIO1_2_, this_.COPYRIGHTHOLDER as COPYRIG24_1_2_, this_.COPYRIGHTYEAR as COPYRIG25_1_2_, this_.ISSUE_NUMBER as ISSUE26_1_2_, this_.DATELINE_LOCATION as DATELINE27_1_2_, this_.ONLINE_RELEASE_DATE as ONLINE28_1_2_, this_.ENDNOTES as ENDNOTES1_2_, taxonomies4_.ART_ID as ART1_, taxonomy1_.TAXONOMY_ELEMENT_ID as TAXONOMY2_, taxonomy1_.TAXONOMY_ELEMENT_ID as TAXONOMY1_0_, taxonomy1_.ELEMENT_NAME as ELEMENT2_8_0_, taxonomy1_.ELEMENT_DESCRIPTION as ELEMENT3_8_0_, sitesectio6_.ART_ID as ART1_, sitesectio2_.SITE_SECTION_ID as SITE2_, sitesectio2_.SITE_SECTION_ID as SITE1_1_, sitesectio2_.SECTION_NAME as SECTION2_10_1_ from ARTICLE this_ inner join ARTICLE_TAXONOMY taxonomies4_ on this_.ART_ID=taxonomies4_.ART_ID inner join TAXONOMY_ELEMENT taxonomy1_ on taxonomies4_.TAXONOMY_ELEMENT_ID=taxonomy1_.TAXONOMY_ELEMENT_ID inner join ARTICLE_SITE_SECTION sitesectio6_ on this_.ART_ID=sitesectio6_.ART_ID inner join SITE_SECTION sitesectio2_ on sitesectio6_.SITE_SECTION_ID=sitesectio2_.SITE_SECTION_ID where taxonomy1_.TAXONOMY_ELEMENT_ID in (12966) and sitesectio2_.SITE_SECTION_ID in (19,20,21,22); error: ORA-00918: column ambiguously defined ******** I place extra line breaks around the two aliases generated with identical/duplicate names. Please let me know of any questions or if more information is needed.