[JS2-227] FK Constraint Error deleting Users on SSO Site to Principals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-M2
• Fix Version/s: 2.0-FINAL
• Component/s: SSO
• Environment: Hypersonic SQL database only
• Assignee: Roger Ruttimann
• Reporter: David Sean Taylor
• Created: 03/Apr/05 10:21
• Updated: 04/Oct/11 21:38
• Resolved: 19/Nov/05 05:44

Description

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)

Issue Links

• is part of: JS2-388 SSO