[jira] Commented: (CONTINUUM-1385) Foreign key konstraint violation

["Pavel Halas (JIRA)" <ji...@codehaus.org>]

    [ http://jira.codehaus.org/browse/CONTINUUM-1385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_104788 ] 

Pavel Halas commented on CONTINUUM-1385:
----------------------------------------

Build: continuum-20070727.010000.war

> Foreign key konstraint violation
> --------------------------------
>
>                 Key: CONTINUUM-1385
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-1385
>             Project: Continuum
>          Issue Type: Bug
>          Components: Database
>    Affects Versions: 1.1-beta-2
>         Environment: Linux, Tomcat 5.5.17, Derby
>            Reporter: Pavel Halas
>
> Hi,
> I tried to delete an ant project from a group and get the following message (see below). Removing all the build results helped. Nevertheless, I think there should be a delete cascade, not a contstraint.
> {noformat}
> javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? NestedThrowables: SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK1' for key (6). The statement has been rolled back.
> {noformat}

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira