Uploaded image for project: 'Jetspeed 2 (Retired)'
  1. Jetspeed 2 (Retired)
  2. JS2-227

FK Constraint Error deleting Users on SSO Site to Principals

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0-M2
    • 2.0-FINAL
    • SSO
    • None
    • Hypersonic SQL database only

    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)

      Attachments

        Issue Links

          Activity

            People

              rogerrut Roger Ruttimann
              taylor David Sean Taylor
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: