[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2872) MappingException thrown for @ManyToOne join if table on the left of the association is alphabetically lower than table on the right

[Mukesh (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28280 ] 

Mukesh commented on HHH-2872:
-----------------------------

Please read the exception as below:
org.hibernate.MappingException: Unable to find column with logical name: BUSINESS_AREA_CODE in org.hibernate.mapping.Table(V_ORGANIZATIONAL) and its related supertables and secondary tables" 

> MappingException thrown for @ManyToOne  join if table on the left of the association is alphabetically lower than table on the right 
> -------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-2872
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2872
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: core, query-hql
>    Affects Versions: 3.2.5
>            Reporter: Mukesh
>
> I get a MappingException for @ManyToOne join if table on the left of the association is alphabetically lower than table on the right 
> I have tables VO_USER, V_ORGANIZATIONAL and VO_AREA
> VO_USER has USR_IDR as primary key.
> V_ORGANIZATIONAL has a composite primary key of BUSINESS_AREA_CODE and CODE
> VO_AREA has BUS_ARA_IDR as the primary key
> I get the following exception when I join the VO_USER table with the V_ORGANIZATIONAL table
>  "org.hibernate.MappingException: Unable to find column with logical name: BUSINESS_AREA_CODE in org.hibernate.mapping.Table(V_ORGANIZATIONAL_GRADE) and its related supertables and secondary tables"
> Howerver, if I rename the table V_ORGANIZATIONAL to VO_ORGANIZATIONAL, it works fine - which makes me conclude that it is an issue with the alphabetical ordering of the tables in the association.   The table name on the left side of the @ManyToOne join must be alphabetically greater than the table on the right side - perhaps of the way hibernate loads the classes ?? 
> Can someone confirm that is the issue, and what is the workaround/solution as I dont want to change the name of the table
> The simplified Code :
> @Entity
> @org.hibernate.annotations.Entity(mutable = true)
> @Table(name = "VO_USER")
> @Cache(usage = CacheConcurrencyStrategy.READ_WRITE, region = "user")
> public class User implements Serializable
> {
> 	private static final long serialVersionUID = -1894472442328538017L;
> 	@Id
> 	@Column(name = "USR_IDR")
> 	private String userId;
> 	@ManyToOne
> 	@JoinColumn(name = "BUS_ARA_IDR", insertable = false, updatable = false, unique = false, nullable = false)
> 	private BusinessArea businessArea;
> 	@ManyToOne(targetEntity = Organizational.class)
> 	@JoinColumns( {
> 		@JoinColumn(name = "BUS_ARA_IDR", referencedColumnName = "BUSINESS_AREA_CODE", unique = false, insertable = false, updatable = false, nullable=true),
> 		@JoinColumn(name = "USR_GRD", referencedColumnName = "CODE", unique = false, insertable = false, updatable = false, nullable=true)
> 			})
> 	private Organizational organizational;
> 	
> 	....
> }	
> @Entity
> @Table(name = "V_ORGANIZATIONAL")
> @IdClass(OrganizationalKey.class)
> @Cache(usage = CacheConcurrencyStrategy.READ_ONLY, region = "organization")
> public class Organizational implements CodedValue,
> 		Comparable<Organizational>, Serializable
> {
> 	private static final long serialVersionUID = 7414956278287853961L;
> 	@Id
> 	private String code;
> 	@Id
> 	private BusinessArea businessArea;
> 	private Organizational()
> 	{
> 	}
> 	
> 	....
> }
> public class OrganizationalKey implements Serializable
> {
> 	private static final long serialVersionUID = -8022957102173252455L;
> 	
> 	@ManyToOne(targetEntity = BusinessArea.class)
> 	@JoinColumn(name = "BUSINESS_AREA_CODE", insertable = false, updatable = false)
> 	private BusinessArea businessArea;
> 	
> 	@Column(name = "CODE", length = 5, insertable = false, updatable = false)
> 	private String code;
> 	
> 		
> 	OrganizationalKey()
> 	{
> 	}
> 	
> 	....
> }
> @Entity
> @Table(name = "VO_AREA")
> @Cache(usage = CacheConcurrencyStrategy.READ_ONLY, region = "organization")
> public class BusinessArea implements CodedValue, Serializable
> {
> 	private static final long serialVersionUID = 6911068689852530787L;
> 	
> 	@Id
> 	@Column(name = "BUS_ARA_IDR", length = 3, updatable = false)
> 	private String code;
> 	private BusinessArea()
> 	{
> 	};
> }

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