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

Reply via email to