Francesco Chicchiriccò created SYNCOPE-1131:
-----------------------------------------------
Summary: Cannot delete resources owned by realms
Key: SYNCOPE-1131
URL: https://issues.apache.org/jira/browse/SYNCOPE-1131
Project: Syncope
Issue Type: Bug
Components: core
Affects Versions: 2.0.3
Reporter: Francesco Chicchiriccò
Assignee: Francesco Chicchiriccò
Fix For: 2.0.4, 2.1.0
When attempting to delete a resource assigned to one or more realms, an error
is reported:
{code}
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]
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)