Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-1024

Allow database to throw Referential Integrity violation.

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Obsolete
    • Major
    • None
    • JBossAS-4.0.0 Final
    • CMP service
    • None

    Description

      SourceForge Submitter: vbnaik .
      Currently Jboss nullifies the foreign key constraints
      before deleting a referenced entity, and Referential
      integrity violation is not thrown by database, when fk
      constraints are defined at database level.

      Say for example:

      An EJB A is being referenced by EJB B (M:1 CMR). So on
      deletion of EJB A we should get referential intergrity
      violation from database as B is referencing A.

      When we try to delete A invoking the remove() method,
      JBOSS AS first nulls out the reference of A in ejb B and
      then deletes it and as a result no referential integrity
      error from database is thrown.

      It is big pain to code in business logic for referential
      integrity, we would highly appreciate, if an option is
      provided in JBoss to turn off the this logic, if at all a
      developer wants database to handle the referntial
      integrity for the application.

      Thanks,
      Vikram Naik

      Attachments

        Activity

          People

            olubyans@redhat.com Alexey Loubyansky
            sourceforge-user SourceForge legacy user (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: