Session entity securityContext holds a reference to the principal entity, causing a principal entity deletion to fail:

ERROR JDBCExceptionReporter:234 - Cannot delete or update a parent row: a foreign key constraint fails (`appname`.`_SecurityContext`, CONSTRAINT `FK18F8BBF01EFAEF19` FOREIGN KEY (`SecurityContext_principal`) REFERENCES `_Person` (`id`))

ERROR exception during execution of action
org.hibernate.exception.ConstraintViolationException: could not delete: [webdsl.generated.domain.Person#75c1831b-xxxx-xxxx-xxxx-xxxxxxxxxx]

After manually deleting the reference-holding SecurityContext from the db:

ERROR JDBCExceptionReporter:234 - Cannot delete or update a parent row: a foreign key constraint fails (`evaluaties`.`_RequestLogEntry`, CONSTRAINT `FK8A9B44DE121F7267` FOREIGN KEY (`RequestLogEntry_principal`) REFERENCES `_Person` (`id`))

ERROR exception during execution of action
org.hibernate.exception.ConstraintViolationException: could not delete: [webdsl.generated.domain.Person#75c1831b-xxxx-xxxx-xxxx-xxxxxxxxxx]
Submitted by Elmer van Chastelet on 28 October 2013 at 15:22

On 28 October 2013 at 15:25 Elmer van Chastelet tagged error

Log in to post comments