Correction: Bill Burke points out that I mean defer the insert not the
commit. The constraint is normally enforced during the insert/update which is
why the "defer constraints until commit" works on Oracle. SQL Server stipulates
that constraints are imposed on insert. Same problem exists
nevertheless.
-----Original Message-----
From: Rod Macpherson
Sent: Tuesday, August 05, 2003 11:18 AM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] The JBoss Deferred Constraint Requirement IssueBackgroundJBoss 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.ProblemThe 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
