Hi ppl,

I have a strange doubt. I need to insert in two tables. One of them has a sequencial primary key. Ok till them, but i need to insert in other table with a composite key. One of the composed fields must have the same value of the primary key given to the first table.
So... i have two possibilities.
I need to know what will be the number that the record will get according to the sequence and use it to build my composite key... or...
I could use a foreign generator in just one field of a composite key.

i don´t know how to do any of these possibilities.

Have anyone solved any problem like this.

This is the mapping of my key:

<composite-id>
<key-property name="card_id" type="integer" />
<key-property name="card_property_id" type="integer" />
</composite-id>

Thanks in advance for any ideas

T.H.

You could use a <key-many-to-one ...> if there is a logical relation between the key and the entity.



Farzad-

Hi,

It´s not exactly my case. I tried to use a foreign generator in composite key, but it didn´t work.
Probably, te better way is find out how to get the sequence number the record will receive.

Have any idea ?

Thanks

Thiago