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
Assigned to: David Sean Taylor
     Fix For: 2.0-M3


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
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jaka...
For additional commands, e-mail: jetspeed-dev-help@jaka...