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

Jetspeed 2

FK Constraint Error deleting Users on SSO Site to Principals

Created: 03/Apr/05 10:21 AM Updated: 19/Nov/05 05:44 AM

Return to search

Component/s:

SSO

Affects Version/s:

2.0-M2

Fix Version/s:

2.0-FINAL

Time Tracking:

Not Specified

Environment:

Hypersonic SQL database only

Issue Links:

Incorporates

This issue is part of:

~~JS2-388~~ SSO

Resolution Date:

19/Nov/05 05:44 AM

Description

« Hide

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)

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

David Sean Taylor made changes - 25/May/05 10:42 AM

Field	Original Value	New Value
Fix Version/s		2.0-M4 [ 11186 ]
Fix Version/s	2.0-M3 [ 11127 ]

Michael Lipp made changes - 26/Oct/05 04:54 PM

Link

This issue is part of ~~JS2-388~~ [ ~~JS2-388~~ ]

Michael Lipp made changes - 31/Oct/05 04:30 AM

Fix Version/s	2.0-M4 [ 11186 ]
Fix Version/s		2.0-FINAL [ 10940 ]

[ Permlink | « Hide ]

David Sean Taylor added a comment - 19/Nov/05 05:25 AM

think this is fixed
please verify

David Sean Taylor made changes - 19/Nov/05 05:25 AM

Assignee

David Sean Taylor [ taylor ]

Roger Ruttimann [ rogerrut ]

[ Permlink | « Hide ]

David Sean Taylor added a comment - 19/Nov/05 05:44 AM

Resolved -- tests pass on Derby

David Sean Taylor made changes - 19/Nov/05 05:44 AM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]