tracker issue : CF-3122013

Problem Description: When creating a many-to-one relationship between objects, the column attribute is not passed from ColdFusion to Hibernate, so it is not possible to map anything on the many side other than the foreign key.

Steps to Reproduce: 
Create Product.cfc with productID (from column product_ID) as primary key. Create RecommendedProduct.cfc with an auto-generated ID and two properties, parentID (from column product_ID) and recommendedProductID (from column recommendedProduct_ID). 

Create two relationships in Product:
	property name="recommendedProducts"    
		 fieldtype="one-to-many" 
		 cfc="RecommendedProduct"
		 lazy="true"
		 orderby="ranking";
		 
	property name="recommendedBy"    
		 fieldtype="one-to-many" 
		 cfc="RecommendedProduct"
		 lazy="true"
		 fkcolumn="RecommendedProduct_ID";

Create two relationships in RecommendedProduct: 
	property name="parentProduct"    
		 fieldtype="many-to-one" 
		 cfc="Product"
		 lazy="true"
		 inverse="true" insert="false" update="false";

	property name="relatedProduct"    
		 fieldtype="many-to-one" 
		 cfc="Product"
		 lazy="true"
		 inverse="true" insert="false" update="false"
		 column="recommendedProductID";

Add records to the Product table with IDs 1, 2, 3, and 4. Add records to the RecommendedProduct table with product_ID/recommendedproduct_ID pairs of (1,2), (1,3) and (1,4).

Load a Product object from ID 1. Dump the value of getRecommendedProducts().

Actual Result:
parentProduct and relatedProduct return the same object for each element returned by getRecommendedProducts().

Expected Result:
relatedProduct should return the object with the ID from recommendedProduct_ID, not product_ID.

Any Workarounds:
Set saveMapping to true and manually edit the hbmxml file for RecommendedProduct, changing the column attribute in the relatedProduct relationship to RecommendedProduct_ID.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3122013

External Customer Info:
External Company:  
External Customer Name: Dave DuPlantis
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments: