Hi,

In a dating application I have a class: Subscriber and I need to reference favourite (other) Subscribers in the system for a particular Subscriber. It seems most logical to self reference the class object in a many to many way.

I use the following xdoclet code in my Subscriber class:



I'm getting a

, when I try to generate the database from the ant task. Presumably it doesn't work using regular Hibernate either. You would want to specify some alias name.

If somebody can offer advice, thanks!

Marc

Buehler, Buehler?

Kind regards,

Marc

I haven't tired to create self-referencing many-2-many - maybe someone did?

But you may decompose many-2-many into many-2-one + one-2-many.
Sth. like: http://adigio.com/blogs/christian/archi ... manyt.html

Lukasz

That would work. In your example "Meeting" is a logical object that seems to have a place in the domain. In my case, when you creating intermediary objects for self referencing you would get objects like "BlockedUser" and "FavouriteUsers". Actually, I would be creating objects based on relational table structure in stead object orientation. I suppose I could just create the tables and reference them in my hibernate.xml. I believe that still leaves me with the fact that with self referencing I have two identical unique keys. And I just love that automatic generation of the database based on hibernate xml.

Although I see a lot of stuff written about how many-to-many should be avoided. I don't see why. There are many cases when this is just the most logical assocation.

Kind regards.

Marc