Hi .
can somebody to give me some idea?
a collection of folders belonging to a owner is many to one relationship so a collection of folders with one owner is ok but if a owner has two different collections; it should be ok, right? the annotation as folows:


I use the annotation in bean:
@ManyToOne ( targetEntity = research.utils.Member.class, optional=false )
@JoinColumn(name="owner", insertable=false, updatable=false, nullable=false)


for another collection in the same bean :

@ManyToOne ( targetEntity = research.utils.AdminMember.class, optional=false )
@JoinColumn(name="adminOwner", insertable=false, updatable=false, nullable=false)


however, when hibernate join table even it is " member" object , it still want to join " adminmember"


I use Sping as entitymanager to manage transaction ...

who can comment on this?

Thank you in advance

The example you provided is not very clear. To answer your main question, yes we can have multiple many-to-one relationships between two tables. But, you need to have two different varaibles in "Many" table to map to the same "one" table.

Thank you very much for your reply !
Yes , in " many" table(folder bean) , I have two collection of fields in this "Folder" bean and have two different owners: owner, type is "Member" and adminOwner, type is "AdminMember" the annotation is showing this ...

But after I login , when I want add a folder to the logined member's folders, no matter I logined as "Memebr" or " AdminMember" (THEY BELONG TO TWO TABLES RESPECTIVELY), hibernate always to join " adminMember " table ...

the annotation mapped to owner for the "Member" , why hibernate join " Adminmember owner? this the problem I want to solve..

if the annotation attributes I used is not proper?


Thanks!

Official Documentation
-------------------------
optional: If enabled (the default), Hibernate will insert a row only if the properties defined by this join are non-null and will always use an outer join to retrieve the properties.

Now, set optional=true in your annotations and you should see the join is not created in the SQL when the correcponding property is null.

Let me know if this works.

Hi,
Thank you so much for your reply.
Right now, I have merged Adminmember and member as Member by add more column in one table. but still, when I start implemet Document part member will have more one collections corresponding several table at that time I will try ... I expect more help by then and I twill let you know the resul definitly...