Hi mates, I've been searching throughout the forum and I couldn't solve I problem I have. So, I decided to post it and wait for someone to help me.

Well, I have three tables: users, subscriptions and thirdparties. The first one has a UserID primary key. The second one has UserID and ThirdPartyID composite primary keys wich are foreign keys if seen individually. Finally, the third table has a ThirdPartyID primary key

As you can see, the relationship is so that given a user I have many subscriptions. Similarly, given a third party I have many subscriptions. Then, I would like to map for an user a set with all subscriptions he/she is registered in. Can I do that by using xdoclet? If not, can I do it with any other tool? If still not, how can I do it manually?

Thans to all for your huge help... ;)

Yes - this is a simple many-to-many mapping and is handled by x-doclet.

e.g.

You will have a similar mapping on the other side. Only one of the sides should be marked as inverse.

Thanks drj for your quick reply. However, I'm not sure this is a many-to-many relationship as you suggested, but a one-to-many relationship. I think Users is at the one side and Subscription is at the many side.

Additionally, I couldn't map this (one-to-many) relationship as a normal one, because I have a SubscriptionId class which encapsulates the both IDs of Subscription. Hence, the complexity I don't know how to face with.

So to sum up, I have Users class which needs a java.util.Set with subscriptions. Subscription class has an SubscriptionID type id field which represents the ID of every subscription (UserID + ThirdPartyID). Finally, I have ThirdParty class which should (not compulsory) have another set of subsriptions.

Now, that maybe I have exposed my case in further detail, you might help me better. If you need more details, please don't hesitate to letting me know.

Thank you very much! ;)