Hi Hbm Users,

I need urgent help. I'm trying to do mapping "many-to-one" with a single column to different object.
Please tell me its doable or not
Help me

Thanks in advance

-Viks

Hi,
Yes. Here is an example.
<many-to-one name="objectOne" column="ref_id" />
<many-to-one name="objectTwo" column="ref_id" insert="false" update="false"/>

Here, we are forced to make atleast one association 'read-only'.
-----------------------------------------
Rate the reply if you find it helpful

--->

Hi Hbm Users,

Thanks for your reply Pramod. But still i'm in problem. I've even tested yr way.

<class name="UserRoles">
.
.
.

<many-to-one name="roleOfTypeSubscriberSponsor" column="entity_id" cascade="all" class="net.subscriber.SubscriberSponsor" not-found="ignore"/>
<many-to-one name="roleOfTypeMentor" column="entity_id" cascade="all" class="net.mentor.Mentor" not-found="ignore" insert="false" update="false"/>
<many-to-one name="roleOfTypeMonitor" column="entity_id" cascade="all" class="net.monitor.Monitor" not-found="ignore" insert="false" update="false"/>
<many-to-one name="roleOfTypeCorporateSponsor" column="entity_id" cascade="all" class="net.corporatesponsor.CorporateSponsor" not-found="ignore" insert="false" update="false"/>
</class>


My relationship is like the above - so a single column entity_id will map to different objects.
Its like a user can me of any kind. So entity_id will be a foreign key for different table.

Please help me out

-Vikash

Thanks for your reply Pramod. But still i'm in problem. I've even tested yr way.

<class name="UserRoles">
.
.
.

<many-to-one name="roleOfTypeSubscriberSponsor" column="entity_id" cascade="all" class="net.subscriber.SubscriberSponsor" not-found="ignore"/>
<many-to-one name="roleOfTypeMentor" column="entity_id" cascade="all" class="net.mentor.Mentor" not-found="ignore" insert="false" update="false"/>
<many-to-one name="roleOfTypeMonitor" column="entity_id" cascade="all" class="net.monitor.Monitor" not-found="ignore" insert="false" update="false"/>
<many-to-one name="roleOfTypeCorporateSponsor" column="entity_id" cascade="all" class="net.corporatesponsor.CorporateSponsor" not-found="ignore" insert="false" update="false"/>
</class>


My relationship is like the above - so a single column entity_id will map to different objects.
Its like a user can me of any kind. So entity_id will be a foreign key for different table.

Please help me out

-Vikash

Hi Vikas Kaushik,
I am unable to get your problem.
Are you getting exceptions ?
What do you need from the mappings ?
What is it that you wanted to achieve, but could not, from the above mappings ?

Hi Pramod,

I'm having a UserRole object which is associated with User 1-1.
And the UserRole is associated with different type of Objects with 0-1 from same column entityId( which is connecting to different Entities like Programmer/QA/Analyser).

Hi Vikas Kaushik,
I understand the scenario as follows. ( tables )
USER:
id:
name:.....
USER_ROLE:
id:
entity_id: ( column central to all mapping )
otherAttributes....
MENTOR:
id:
attributes....
SPONSOR:
id:
attributes.....

Relationships:
USER.id :: USER_ROLE.entity_id :: MENTOR.id :: SPONSOR.id relate each other. ( equality )

Requirement:
i) UserRole contains Mentor, Sponsor ... objects.
ii) We need to navigate from role to related objects.

If I get them right ( you can correct me If I have missed anything ), I am not sure why the previous mapping did not solve the problem.
Here is another alternative with no restrictions like (insert="false", update="false")

<class name="UserRole">
<id name="id">......</id>
<many-to-one name="mentor" >
<formula>entity_id </formula>
</many-to-one>
<many-to-one name="sponsor" >
<formula>entity_id </formula>
</many-to-one>
<one-to-one name="user">
<formula>entity_id </formula>
</one-to-one>
</class>

and have id as the key in all other mapping files.

---------------------------------------------------------------------
Rate the reply if you find it helpful

hurrrryyyy.....you are awesome.
It solves my problem. Thanks a lot Pramod

-Vikash