It only defers updates. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gavin > Matthews > Sent: Tuesday, August 05, 2003 3:19 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Re[2]: [JBoss-user] The JBoss Deferred Constraint > Requirement Issue > > > Alex, > I only meant to imply that if making the column non-nullable was not an > option then they could consider changing sync-on-commit-only. > This as I understand it (and I may be wrong) will defer the entire insert > until the end of the trasaction (which would avoid the nullable issue). > > I was considering this approach to solve the nullable CMR field > limit myself > but I haven't spent time investigating - is this how sync-on-commit-only > works or is the only alternative making the column nullable? > > gavin > > > -----Original Message----- > > From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, August 05, 2003 12:00 PM > > To: Gavin Matthews > > Subject: Re[2]: [JBoss-user] The JBoss Deferred Constraint Requirement > > Issue > > > > > > No, sync-on-commit-only does not affect INSERT after ejbCreate. > > > > alex > > > > Tuesday, August 05, 2003, 9:35:51 PM, Gavin Matthews wrote: > > > > > Rod, > > > I believe what you want is to make the CMR column nullable > > (in ejbCreate > > > JBoss inserts the row with the CMR field set to null). This > > is then updated > > > after ejbPostCreate(). > > > Another option would be to set sync-on-commit-only to true > > but this breaks > > > some of the spec compliance (finders cause sync) and also > > unless you're > > > careful may cause logical problems. > > > > > hope this helps, > > > gavin > > > > > -----Original Message----- > > > From: Rod Macpherson [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, August 05, 2003 11:18 AM > > > To: [EMAIL PROTECTED] > > > Subject: [JBoss-user] The JBoss Deferred Constraint > > Requirement Issue > > > > > > > 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 > > > > > > ------------------------------------------------------- > 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_072 303_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
