RE: [JBoss-user] The JBoss Deferred Constraint Requirement Issue

[Bill Burke]

Title: Message

You mean, Weblogic doesn't INSERT until after ejbPostCreate, corect?

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Rod Macpherson
Sent: Tuesday, August 05, 2003 2:18 PM
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