Hi,

I need some help on managing relationships on Entity Beans CMP 2.0.

I have two Entity Beans: Person and Gender. "Person" is stored on a
table that has a foreign key for the "Gender" table. "Person" has an
one-to-one relationship (CMR field) to "Gender". The foreign key
column for "Gender" in the "Person" table is NOT NULL.

The problem occurs when I try to create a new "Person" on the
database. The container tries to insert a NULL value on the foreign
key column and this causes a contraint exception. If I change the
foreign key column to allows NULL, everything works: the container
inserts a NULL value in the foreign key column but then updates the
column with the correct value.

Is this the only way to solve the problem? Can't I have NOT NULL
foreign key columns for CMR fields?

Thanks in advance,

Joan