This could be a big factor for those with existing schemas and particularly with existing applications. When creating a JBoss application they are all the sudden faced with a schema change that could have major ripple effects. Not so bad for us although still something we would rather avoid. I think a switch should be added to move the commit after ejbPostCreate.
Thanks, Rod -----Original Message----- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 11:51 AM To: Rod Macpherson Subject: Re: [JBoss-user] The JBoss Deferred Constraint Requirement Issue The only way is to introduce non null CMP fields and initialize them in ejbCreate. alex Tuesday, August 05, 2003, 9:17:46 PM, Rod Macpherson wrote: > Background > JBoss executes a commit between ejbCreate and ejbPostCreate but we do > not add CMP relationships until ejbPostCreate. This can cause create > to fail when there are foreign key constraints. One solution is to > defer constraint checking until after the transaction completes. > WebLogic has a different approach in that they do not commit until > after ejbPostCreate and this simplifies things in my opinion. Having > started out in WebLogic we had to change our database configuration to > use JBoss and we were able to do that without incident. > Problem > The problem has resurfaced now that we have a customer whose schema > is hosted by SQL Server. Apparently there is no way to defer > constraints on that system. Any ideas on a workaround short of > eliminating constraints altogether? > TIA, > Rod ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01 /01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
