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

FK Violation deleting 1-1 relationship

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • No Release
    • JBossAS-3.2.6 Final
    • CMP service
    • None

    Description

      SourceForge Submitter: suzyrizzo .
      I have attached a set of CMPs that cause a foreign key
      violation when deleted.

      Entities:
      Group
      Address
      GroupId

      Group has a uni-directional 1-1 relationship with
      Address. A foreign key is set up on the
      Group.physicalAddressKey field.

      Group has a bi-directional 1-many relationship with
      GroupId.

      I have batch-cascade-delete turned on for the group-
      has-groupids relationship because the GroupId.groupKey
      cannot be null.

      I do not have batch-cascade-delete turned on for the
      group-has-address relationship because
      physicalAddressKey is an FK into Address, so Address
      cannot be deleted before Group.

      The relationships work separately, but when I have them
      defined at the same time, I get a Foreign Key violation.
      I've included the server.log file with the full error
      message in my attachment.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: