From: "Yuri Kouzmov" <[EMAIL PROTECTED]>Are you sure?
3. You need to allow your foreign key columns to be NULL-able. It looks like they are inserted as NULL and then later updated with appropriate values.I don't know if MySQL supports this, but some databases support deferring constraint checking until the transaction is committed. This allaws you to keep the NOT NULL constraints and still have it work on JBoss, since JBoss commits the tranaction only after ejbPostCreate is called.
I ran Oracle (9i) with deferrable constraints enabled but JBoss (3.2RC2) chokes the same way as when they were not deferrable.
The easiest way is to allow the constraints to be nullable, as Yuri said.
AFAIK JBoss 4.0 will fix this issue with Oracle. IIRC MySQL and HypersonicSQL don't choke on this.
regards, Matthias -- Matthias Flor <[EMAIL PROTECTED]>
-------------------------------------------------------
This SF.net email is sponsored by:Crypto Challenge is now open! Get cracking and register here for some mind boggling fun and the chance of winning an Apple iPod:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user
