[jira] Updated: (JS2-227) FK Constraint Error deleting Users on SSO Site to Principals

["Michael Lipp (JIRA)" <je...@portals.apache.org>]

     [ http://issues.apache.org/jira/browse/JS2-227?page=all ]

Michael Lipp updated JS2-227:
-----------------------------

    Fix Version: 2.0-FINAL
                     (was: 2.0-M4)

> FK Constraint Error deleting Users on SSO Site to Principals
> ------------------------------------------------------------
>
>          Key: JS2-227
>          URL: http://issues.apache.org/jira/browse/JS2-227
>      Project: Jetspeed 2
>         Type: Bug
>   Components: SSO
>     Versions: 2.0-M2
>  Environment: Hypersonic SQL database only
>     Reporter: David Sean Taylor
>     Assignee: David Sean Taylor
>      Fix For: 2.0-FINAL

>
> FK Constraint Error deleting Users on SSO Site to Principals
> The unit test, TestSSOComponent.java, fails with a 
> java.sql.SQLException: Integrity constraint violation: SSO_SITE_TO_PRINCIPALS_FK_2 table: SSO_SITE_TO_PRINCIPALS in statement [DELETE FROM SECURITY_PRINCIPAL WHERE principal_id = 422 ]
> error. It seems that Torque is not correctly generated the cascading deletes for HSQL.
> This error does not exist on other databases tested.
> Disabling the unit test until this fixed.
> WARNING: deleting users with SSO credentials will cause a FK error and the user won't delete (again this is only a bug with HSQL)

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


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org