We have a requirement where in we need to use cfg xml instead of annotations for ORM.

We are using hibernate 3 and are stuck on one of the annotations

in TableA:



in TableB:



I have tried doing below in mappings

for TableA




for TableB




But it's not working. Column1b is not the primary key for TableB, It has a composite primary key. So we want to have a many to one relation on a non-primary column, but its always trying to join to primary key and gives error that not enough attributes passed as primary key.

Could any one suggest correct mapping in XML for such annotations?

The many-to-one property-ref must reference a property, not a column.
As suggested in this SO answer, you should add a column1b property in the many-to-one class and a mapping like this:

Hi

I get an error as
Caused by: org.hibernate.PropertyNotFoundException: field [column1b] not found on TableA
at org.hibernate.property.DirectPropertyAccessor.getField(DirectPropertyAccessor.java:182) ~[hibernate3.jar:3.6.10.Final]
at org.hibernate.property.DirectPropertyAccessor.getField(DirectPropertyAccessor.java:174) ~[hibernate3.jar:3.6.10.Final]

I have tried something as
<many-to-one name="attributeb"
property-ref="column1b"
fetch="select"
class="TableB"
lazy="true">
<column name="column1" />
</many-to-one>

This works as far as lazy load. But once i move to eager and load TableB, i get error .

For one to many the mapping i am using is
<set name="attributeA" cascade="all" inverse="true" >
<key column="column1" property-ref="column1b" />
<one-to-many class="TableA" />
</set>

I am thinking may be the one-to-many mapping is wrong.