I want to create EB's for existing tables representing a SalesOrder. The head-table is called so_head, the positions are in so_pos and additional data for the positions is in so_posp. so_head has field order_id as PK, so_pos has pos_id as PK and order_id as FK. so_posp does not have pos_id but order_id+pos_id+counter as PK.
First I created two CMP beans with a CMR for so_head and so_pos via field order_id -> OK, no problem ! Then another CMP bean for table so_posp with a CMR to so_pos via fields order_id+pos_id. JBoss complains, that the bean for so_pos has no CMP-field named order_id. This is somehow correct, but it's added as a result of the relation between so_head and so_pos.
Is there a solution for this database schema ?
If not, is it possible to use a view as database object for an entity bean ?