[jboss-user] [EJB 3.0] - Composite primary key from foreign keys

I'm unable to figure out how to implement this. I have 3 tables in my DB: Team (surrogate pk), Period (surrogate pk) and TeamPeriods (pk composed of both foreign keys). I need to create an entity from the third table so I can then query the Team objects and receive a collection of TeamPeriods (and then Periods if needed). I don't want to create a surrogate key and an index for this table. I've seen the @Embeddable annotation but I'm still unsure on how to apply it in this case. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3989780#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...