I am in the process of re-designing a current system. The database on the current system has many tables that would be viable as entity beans. I am running into problems where many of these tables are joined through a helper table that does nothing but manage data that combines 2 like entities. The helper table doesnt always contain primary keys from both tables as references. As I see it, this poses a big challenge for container managed entity beans, which I was hoping to implement. Has anyone dealt with this problem successfully using container managed persistence and the EJB 2.0 spec? Would I be better off writing BMP beans or just good ol flexible DAO's?

Thanks

Nic