[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-872) Duplicate alias issue returned in 3.0.5, 3.0.4 and possibly others

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-872.
------------------------------


Closing stale resolved issues

> 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.

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira