Specify the column on one-to-many

If we want the relatioship is TestParent.testNo = TestChild.testNo, do not use the identity column "id".

We should specify the columns in mapping file, such as:

<class name="com.stefli.model.TestParent" table="TestParent" schema="dbo" catalog="test"> <set name="testChilds" inverse="true"> <key property-ref="testNo"> <column name="TestNo" not-null="true" /> </key> <one-to-many class="com.stefli.model.TestChild" /> </set> </class> 

 

<key property-ref="columnName"> is for Parent object

<column name="columnName"> is for Child object

 

If do not specify the property-ref, the sql would be:

this.ID = this.child.columnName.

 

If specify the property-ref, the sql would be:

this.columnName = this.child.columnName