> Russell Black wrote: > > From: "Yuri Kouzmov" <[EMAIL PROTECTED]> > > > >>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. > Are you sure?
No. I have not tried this, since I'm not using a database with this capability. I'm just regurgitating something I read somewhere. But it does surprise me that it doesn't work with deferrable constraints, because that means ejbCreate and ejbPostCreate are called on two separate transactions, which seems wrong to me. > 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 ------------------------------------------------------- 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
