Let's say I'm making an accounting system. I have Invoices, and on Invoices I have Products. Every invoice can have a set of one or more products, and there could be duplicates. Every product could show up on any number of invoices. The relationship is uni-directional. The Product doesn't need to have a collection of Invoices that contain it.
How do I map this? It seems like what I need is a JoinTable specification, but when I create it, I get a table with a unique constraint on invoice_id. That should not be the case; I should be able to use that invoice_id multiple times to be able to specify a set of products. What I need is a join table that would look like this: | invoice_id product_id | 33 58 | 33 37 | 33 962 | but it's failing on the uniqueness constraint of invoice_id. Any ideas on how to specify this? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4016620#4016620 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4016620 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user