Hi,

I have a situation where I have a ManyToMany relationship, so to get rid of this I have created a table between these two (as I do not like seeing many-to-many's), but now I have the situation where from both sides of this relationship, I need to get the list of the destination relationship, i.e.

A - B - C

Where B is the table inbetween the many to many. So from A I want to get a collection of C and from C I want to get a collection of A, but in my application I'm not really interested in B. In the old days when I used to use EOModeler, they had a concept of flattening a relationship to get over this, do we have the same concept in Hibernate? If yes, then how is this done easily with annotations?

Thanks,
Osian

Why do you want get rid of the ManyToMany relationship ?

If you use class B as 'intermediate' entity (see book java persistence with hibernate, 7,2,3 Adding columns to join tables) it is not possible to navigate directly between A and C without passing through B.
(But it should be possible in some way to write an apposite user-join-query which returns you the wanted results)

After some more research, I have found an easy way to do it, using the @JoinTable annotation.

I can't believe that I didn't see this before, doh!!!

Thanks for your reply though :-)