steinrr wrote:
I have a primary key of a table "tabA" that consists of two columns "colA" and "colB". My questions are:
1. How can I specify a mapping so that each of these columns have a separate sequence associated. As far I can see, the generator-element does not apply to a column, but the primary key as a whole?
2. How can I specify a mapping so that when I assign the value of one of these id-fields, the other get populated by a sequence specified by a generator-element?
I suspect I have to do all this manually by querying the sequence first and then assign the values to the Ids, but I was hoping to avoid this.
Regards,
Stein
Just curious, how would a table be designed like this ?
Normally, a composite key should happen what the key columns itself is a foriegn key.
If the columns are not referenced to any tables, why you want a multiple key columns ?