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
