ejbCreate fails because of not-null foreign key

[dab]

I have a CMP bean which contains a CMR field that is
mapped to a foreign key column with a not-null
constraint (Oracle8).

My ejbCreate() sets all the fields except the aforementioned CMR field.

My ejbPostCreate() has code to set the CMR field.

All compiles OK, but at runtime, the ejbCreate method
attempts to write the record to the database and Oracle
complains that the foreign key field is null and therefore
there is a constraint violation.

Is there a way to get jboss (3.2.0) to delay writing
to the database until after ejbPostCreate()?

I know that BEA's weblogic execution environment has
the "delay-updates-until-end-of-tx" facility (talking
xdoclet tags here). Does jboss have a similar feature?

There are other solutions involving dropping the
not-null constraint but then I lose data integrity.

[jobor]

Hello,

Look in the Oracle constraint documentation :

DEFERRABLE | NOT DEFERRABLE

Specify DEFERRABLE to indicate that constraint checking can be deferred until the end of the transaction by using the SET CONSTRAINT(S) statement.

It worked for me.

Johan

[divine_comedy]

I know that this was a problem in Jboss 3.0.4 and that's because CMP field cannot be CMR field. Wasn't this supposed be fixed in Jboss 3.2.x ?

[juha]

In 3.2.2 specify <insert-after-ejb-post-create>true</insert-after-ejb-post-create> to workaround violating the not null CMR field constraint.

-- Juha

[shivank]

Hi,
Is a CMP field cannot be a CMR field in Jboss 3.2.x ?
If some can answer this it will be of great help.
There is one thread related to this http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=