data in table-mapping?

[dward2]

I'm using jboss3.0.0beta, and have a question about many-2-many relationships...

What if the cross reference itself needs to have data?

For example,

Table: IMAGES
Table: RESOLUTIONS
XRef Table: IMAGE_RESOLUTIONS

I'd like IMAGE_RESOLUTIONS to have columns IMG_KEY, RES_KEY and PATH. PATH is a specified file path to a certain resolution of an image.

I don't see any way to access that data via CMP unless the IMAGE_RESOLUTIONS table turned into an Entity itself, but then yuck...

Any ideas? Thanks,
David

[dsundstrom]

> I don't see any way to access that data via CMP
> unless the IMAGE_RESOLUTIONS table turned into an
> Entity itself, but then yuck...

That is the way to do it. I am guessing that you say yuck because of granularity issues, but this is not really an issue in EJB 2.0. You only need to worry about granularity on remote interfaces and in terms of transaction size; you really don't want to move alot of small stuff to a remote system and you don't want lots of small transactions.