Question on generating many-to-many relationship generation via DBRE

[cjansen]

Hi all:

In reading the Roo documentation, I observed this:

Many-to-many associations are created if a join table is detected by DBRE. To be identified as a many-to-many join table, the table must have exactly two primary keys and have exactly two foreign-keys pointing to other entity tables and have no other columns.

I am wondering if their is some reason why the join table cannot have any other columns aside from the foreign key columns?!

Chris

[Alan Stewart]

It's the only way I can avoid a new entity class from being created to represent the table. Modelling a join table with an extra column is out of scope for DBRE. You can always create the class yourself - see http://en.wikibooks.org/wiki/Java_Pe...onal_Co lumns for more information.