[SYNCOPE-1131] Cannot delete resources owned by realms

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.3
• Fix Version/s: 2.0.4, 2.1.0
• Component/s: core
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 27/Jun/17 15:08
• Updated: 03/Jul/17 07:49
• Resolved: 27/Jun/17 15:16

Description

When attempting to delete a resource assigned to one or more realms, an error is reported:

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: update or delete on table "externalresource" violates foreign key constraint "realm_externalresource_resource_id_fkey" on table "realm_externalresource" 
  Detail: Key (id)=(XXXX) is still referenced from table "realm_externalresource". {prepstmnt 1989356175 DELETE FROM ExternalResource WHERE id = ?} [code=0, state=23503]