[jira] [Commented] (SYNCOPE-1131) Cannot delete resources owned by realms

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SYNCOPE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16064982#comment-16064982 ] 

ASF subversion and git services commented on SYNCOPE-1131:
----------------------------------------------------------

Commit cfb6c638d570536233743cca16a5498dcceea6ce in syncope's branch refs/heads/master from [~ilgrosso]
[ https://git-wip-us.apache.org/repos/asf?p=syncope.git;h=cfb6c63 ]

[SYNCOPE-1131] Missing resource removal before delete (for realms)


> 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)