cascade delete fail for EJB2 CMP Entities after migration to EAP6

Solution Verified - Updated -

Issue

  • After migrate an EJB2 application from EAP4 or EAP5 to EAP6 we see issues during deletion of entities.
    If a relation is marked with cascade-delete it look like that the order of DELETE statements is not respected and therefore a database constraint is violated.
    Depend on the used database an Exception was shown, i.e.
Caused by: javax.ejb.RemoveException: JBAS010757: Could not remove 28dfa49b1835aae56b875a7680d56f43
Caused by: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-532, SQLSTATE=23504, 
  • Batch Cascade Delete is not working in JBoss EAP 6 as in Jboss AS 5.1
  • The jbosscmp-jdbc_4_1.dtd does not allow value true/false inside <batch-cascade-delete>, as it says it should be EMPTY.
<!ELEMENT batch-cascade-delete EMPTY>

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In