Auditlog
long auditlog_id PK
string businessname
long businessid
...

Cancellation
long cancellation_id PK
...

I have above two Tables
Auditlog and Cancellation

When Auditlog's businessname is "Cancellation", then Auditlog的 businessid is Cancellation's cancellation_id

If I could use HQL to describe the relation between Cancellation and Auditlog , it looks like below

select cancel from Cancellation cancel, Auditlog audit where audit.businessname="CANCELLATION" and
audit.businessid=cancel.cancellation_id ;

Then my question is how do I write many-to-one relation in Auditlog.hbm.xml ?

Thanks and Rgds

Check the <any> example here: http://docs.jboss.org/hibernate/stable/ ... anymapping

Thanks, it works for one side (Many-to-One) side (in Auditlog.hbm.xml)


but how to do it in another side(One-to-Many) side(in Cancellation.hbm.xml)?

Do you have any hints?

What about using a 'where' condition in the mapping? Something like this: