2

Given two tables:

Table A with Columns Id (PK) and Name

Table B with Columns Id (PK) and Name (of A)

I would like to have B as a property of A, associated by Name which is no primary key.

How would I map (many-to-one) that in A.hbm.xml if its possible?

Thank you.

Powerslave
  • 531
  • 2
  • 7
  • 24

1 Answers1

2

we can use magical property-ref setting:

on parent side (class A), collection mapping:

<bag name="Children" lazy="true" inverse="true" 
     batch-size="25" cascade="all-delete-orphan" >
  <key column="Name" property-ref="Name" />
  <one-to-many class="B"/>
</bag>

and child (class B) can reference parent similar way:

<many-to-one not-null="true" name="Parent" class="A"
   property-ref="Name" column="Name"  />

check also: https://stackoverflow.com/a/31300425

A link to doc: 5.1.11. many-to-one

... property-ref: (optional) The name of a property of the associated class that is joined to this foreign key. If not specified, the primary key of the associated class is used.

Radim Köhler
  • 122,561
  • 47
  • 239
  • 335