How best to model Entity Bean associations with EJBs of the

[jgc195]

Hi all,

To illustrate the question, lets work with a 'News' Entity bean which contains info related to a single News Article (ie. Headline, Author, etc). This can be modelled very simply with CMP as the data is all in one table.

However, if each News Article can have a number of related News Articles, I'm not sure how best to implement it. Obviously, we'll need another table to store the relationships. Options I can think of are:

1) Create a new Entity called 'News_Relationship' which stores data on a single mapping. Then use CMR to model the one-to-many relationship - but there could be thousands of these tiny beans (maybe this is a good thing!)

2) Use BMP - simply have a second 'select' statement in my ejbLoad method that popluates an array containing the relationships. But you'd loose all the benefits of CMP which seems wrong to me.

Any body have any comments or other options?

Thanks,

Jason

[jgc195]

Doh - If you are reading this and have a similar question, all I can say is...

C M R

:O)

[tjclifford]

When you say the article can have a number of related
articles, how are you relating them ?
By subject, title, etc ?
Related articles with the same topic would have to
be manually related - you could do it with one other table,
having the main article number in one field, the related
articles in the second field, and just add more records for
a one-to-many relationship.

One bean could be used to read these records, given a main
article number, and present them as a DS. ?