Hi all
I'm faceing a problem and i seek for your help

I have 3 tables :
tblEvent - PK pk_iEventNumber
tblEventDescription - PK pkfk_iEventNumber
tblEventFields - composed PK (pkfk_iEventNumber, pk_iFieldIndex)

between tblEvent and tblEventDescription there is a relation one-to-one ( one way- event has a description(always), no need other direction)
between tblEventDescription and tblEventFields there is a one-to-many relation ( one event description has none or multiple fields)

Event mapping



Event description mapping


Event fields mapping



This is my current configuration.
As it can be see i want that eventNo to be generated sequencial by hibernate.
If i insert in db a event with description but no event fields attached operations goes fine; but if i want to add some fields then i receive error column 'pkfk_iEventNo' in table 'tblEbentFields' cannot be NULL which is very normal, since indeed eventNo is null, and i don't indicate hibernate that it should be generated as "foreign" from paretnEventNo.

So my first question is how to solve that, to be able to insert in db a full event( with description, and fields)
My second question is that is realy necesary to use other-way 1to1 reference eventDescription2EventRef (from eventDescription to event). i added just to be able to declare eventNo from EventDescription as a foreign generator

<column name="pkfk_iEventNo" sql-type="integer"/>
<generator class="foreign">
<param name="property">eventDescription2EventRef</param>
</generator>

There is another way to do that ?

Thank you very much for your time and sorry if i didn'd know how to describe this issue better.
Best regards
grandanat

Above i described my specific problem, which can be generalized. So the main idea is that i have 2 tables:

tableParent with primary key simple parentID
tableChild with primary key composed (parentID, childID)

and between them there is a one-to-many relation, from parent to child, then:

if i want that parentID to be generated automatically by hibernate, i declare a generator (native, increment, sequence, etc);
but how to announce hibernate that parentID from tableChild should (pre)get the generated value for parent table, thereby error null field to not be thrown anymore.

Did nobody faced this problem before ? or similar one ?

I have the exact same problem...