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_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to