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.
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 ?
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.
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=